Database extraction request

Support
1

Hello

For statistical purpose, i would like to request a huge number of parts details.
In csv or excel files would be preferred.

Basicly the table that can by downloaded on the Website but in one go in stead of 100 parts at a time.

Depending on whats easier to get:

  • All Parts from Capacitors Category: 1,368,445 Parts

or: Single Categories

  • Aluminum - Polymer Capacitors
  • Aluminum Electrolytic Capacitors
  • Ceramic Capacitors
  • Electric Double Layer Capacitors (EDLC), Supercapacitors
  • Film Capacitors
  • Mica and PTFE Capacitors
  • Motor Start, Motor Run Capacitors (AC)
  • Niobium Oxide Capacitors
  • Silicon Capacitors
  • Tantalum - Polymer Capacitors
  • Tantalum Capacitors
  • Thin Film Capacitors

I already tried to use the API, but because it is heavily rate and/or offset limited, this is not an viable option.

2

Hi @MarcoG, Large scale data export isn’t a service we provide at this time, but if you’d like to go into more detail either in this thread, or in a DM to me, I’d love to better understand what you are trying to achieve. I’d also be available for a live conversation if you think it’d be easier to communicate your needs that way.

3

Hi @Ben_Hest

We are looking for a dataset to statistically analyze an gain knowledge.
For example energy density vs. voltage or energy density vs. size etc.
There may be a very niche market, where common battery technology is not viable for energy storage.
We would like to make calculations if it is possible for us to develop a product for it.

Would it be possible to do get an increase of the API restrictions? Especially the offset limit is very restrictive.

4

My technique when confronted with similar situations is to shrink the solution space using known information and heuristics;

  • Obsolete products aren’t likely candidates for new designs
  • Product classes with costs in the dollar per pF range aren’t likely candidates for bulk energy storage applications
  • Each example of a commoditized product doesn’t need to be evaluated separately; if one example of a 0.1uF/16v ceramic in 0805 package is nonviable by a factor of 100, it’s unlikely that any of the other ~200 examples of the same will magically be 100x better.
  • Building a massive array of devices known for pyrotechnic failure stemming from assembly-induced defect probably isn’t the world’s greatest idea.

I enjoy the luxury of a comprehensive dataset myself, but in truth many questions of this type do not require it.

5

Hi @rick_1976

I do mostly agree with you.

  • Yes, i did think it would not be reasonable to ask for additional filtering since it could be done easily on our end.
  • Yes, but still interesting for analysis.
  • You are right about this as well. We are set on a range since early on. But to statistically confirm previous finding would be nice.
  • We avoid Tantalum capacitors as much as possible. Other than these, i did not experience a higher burn rate than resistors, at least in the last 20 years of working in this field.

My initial hope was, that someone could “hack” an SQL command in to the database and provide the dataset with almost no expense.

I would like to thank everyone responding to my request.

As far as i am concerned, this topic can be closed.