CODEWITHSUNDEEP
socrata
Henry F
Henry F

Reputation: 48

How to determine number of records on a socrata table

Is there a way to determine how many records are available to download for a socarata table?

I'm using the API endpoint routines. I can down the file but it would be nice to know how many records are available to download before starting a download.

Upvotes: 1

Views: 96

Answers (1)

Jon
Jon

Reputation: 46

If I understand the question right, the most straightforward way would be to view the source dataset.

Example: https://data.cityofchicago.org/Transportation/Transportation-Network-Providers-Trips/m6dm-c72p

Screen clip of "What's in this Dataset?"

Screen clip of more precise count from the bottom of the data preview grid

However, you can also do it through the API.

Example: https://data.cityofchicago.org/resource/m6dm-c72p.json?$select=count(*)

[{"count":"100717116"}]

Upvotes: 1

Related Questions