home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

803 rows where fips = 6081 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • California 803

fips 1

  • 6081 · 803 ✖

county 1

  • San Mateo 803
Link rowid date ▲ county state fips cases deaths
2499802 2499802 2022-05-13 San Mateo California 6081 137238 755
2496544 2496544 2022-05-12 San Mateo California 6081 136379 755
2493286 2493286 2022-05-11 San Mateo California 6081 136379 755
2490028 2490028 2022-05-10 San Mateo California 6081 136379 755
2486771 2486771 2022-05-09 San Mateo California 6081 135173 755
2483513 2483513 2022-05-08 San Mateo California 6081 135173 754
2480255 2480255 2022-05-07 San Mateo California 6081 135173 754
2476997 2476997 2022-05-06 San Mateo California 6081 135173 754
2473739 2473739 2022-05-05 San Mateo California 6081 134174 754
2470482 2470482 2022-05-04 San Mateo California 6081 134174 754
2467226 2467226 2022-05-03 San Mateo California 6081 134174 754
2463971 2463971 2022-05-02 San Mateo California 6081 133181 754
2460715 2460715 2022-05-01 San Mateo California 6081 133181 754
2457459 2457459 2022-04-30 San Mateo California 6081 133181 754
2454203 2454203 2022-04-29 San Mateo California 6081 133181 754
2450947 2450947 2022-04-28 San Mateo California 6081 132241 754
2447691 2447691 2022-04-27 San Mateo California 6081 132241 754
2444435 2444435 2022-04-26 San Mateo California 6081 132241 754
2441179 2441179 2022-04-25 San Mateo California 6081 131329 754
2437923 2437923 2022-04-24 San Mateo California 6081 131329 754
2434667 2434667 2022-04-23 San Mateo California 6081 131329 751
2431411 2431411 2022-04-22 San Mateo California 6081 131329 751
2428155 2428155 2022-04-21 San Mateo California 6081 130380 751
2424899 2424899 2022-04-20 San Mateo California 6081 130380 751
2421643 2421643 2022-04-19 San Mateo California 6081 130380 751
2418387 2418387 2022-04-18 San Mateo California 6081 129753 751
2415131 2415131 2022-04-17 San Mateo California 6081 129753 751
2411875 2411875 2022-04-16 San Mateo California 6081 129753 747
2408619 2408619 2022-04-15 San Mateo California 6081 129753 747
2405363 2405363 2022-04-14 San Mateo California 6081 129268 747
2402108 2402108 2022-04-13 San Mateo California 6081 128573 747
2398853 2398853 2022-04-12 San Mateo California 6081 128573 747
2395598 2395598 2022-04-11 San Mateo California 6081 128573 747
2392342 2392342 2022-04-10 San Mateo California 6081 128573 747
2389086 2389086 2022-04-09 San Mateo California 6081 128573 747
2385831 2385831 2022-04-08 San Mateo California 6081 128573 745
2382576 2382576 2022-04-07 San Mateo California 6081 128100 745
2379321 2379321 2022-04-06 San Mateo California 6081 128100 745
2376067 2376067 2022-04-05 San Mateo California 6081 128100 745
2372815 2372815 2022-04-04 San Mateo California 6081 127776 745
2369562 2369562 2022-04-03 San Mateo California 6081 127776 745
2366309 2366309 2022-04-02 San Mateo California 6081 127776 743
2363056 2363056 2022-04-01 San Mateo California 6081 127776 743
2359802 2359802 2022-03-31 San Mateo California 6081 127607 743
2356548 2356548 2022-03-30 San Mateo California 6081 127481 743
2353295 2353295 2022-03-29 San Mateo California 6081 127383 743
2350043 2350043 2022-03-28 San Mateo California 6081 127370 743
2346790 2346790 2022-03-27 San Mateo California 6081 127211 743
2343537 2343537 2022-03-26 San Mateo California 6081 127211 743
2340284 2340284 2022-03-25 San Mateo California 6081 127211 742
2337031 2337031 2022-03-24 San Mateo California 6081 127126 742
2333777 2333777 2022-03-23 San Mateo California 6081 126981 742
2330523 2330523 2022-03-22 San Mateo California 6081 126905 742
2327271 2327271 2022-03-21 San Mateo California 6081 126907 736
2324018 2324018 2022-03-20 San Mateo California 6081 126788 736
2320764 2320764 2022-03-19 San Mateo California 6081 126788 736
2317510 2317510 2022-03-18 San Mateo California 6081 126788 736
2314257 2314257 2022-03-17 San Mateo California 6081 126686 736
2311004 2311004 2022-03-16 San Mateo California 6081 126569 736
2307751 2307751 2022-03-15 San Mateo California 6081 126547 736
2304500 2304500 2022-03-14 San Mateo California 6081 126504 736
2301248 2301248 2022-03-13 San Mateo California 6081 126271 736
2297996 2297996 2022-03-12 San Mateo California 6081 126271 736
2294744 2294744 2022-03-11 San Mateo California 6081 126271 730
2291492 2291492 2022-03-10 San Mateo California 6081 126177 730
2288240 2288240 2022-03-09 San Mateo California 6081 126025 730
2284989 2284989 2022-03-08 San Mateo California 6081 125957 730
2281737 2281737 2022-03-07 San Mateo California 6081 125838 730
2278484 2278484 2022-03-06 San Mateo California 6081 125568 730
2275231 2275231 2022-03-05 San Mateo California 6081 125568 711
2271978 2271978 2022-03-04 San Mateo California 6081 125568 711
2268726 2268726 2022-03-03 San Mateo California 6081 125440 711
2265473 2265473 2022-03-02 San Mateo California 6081 125224 711
2262222 2262222 2022-03-01 San Mateo California 6081 125167 711
2258971 2258971 2022-02-28 San Mateo California 6081 125110 711
2255720 2255720 2022-02-27 San Mateo California 6081 124726 711
2252469 2252469 2022-02-26 San Mateo California 6081 124726 711
2249218 2249218 2022-02-25 San Mateo California 6081 124726 711
2245967 2245967 2022-02-24 San Mateo California 6081 124451 700
2242716 2242716 2022-02-23 San Mateo California 6081 124247 700
2239465 2239465 2022-02-22 San Mateo California 6081 124088 700
2236214 2236214 2022-02-21 San Mateo California 6081 123477 700
2232963 2232963 2022-02-20 San Mateo California 6081 123477 700
2229712 2229712 2022-02-19 San Mateo California 6081 123477 700
2226461 2226461 2022-02-18 San Mateo California 6081 123477 700
2223210 2223210 2022-02-17 San Mateo California 6081 123267 685
2219959 2219959 2022-02-16 San Mateo California 6081 123709 685
2216708 2216708 2022-02-15 San Mateo California 6081 123585 685
2213457 2213457 2022-02-14 San Mateo California 6081 123332 685
2210205 2210205 2022-02-13 San Mateo California 6081 122691 685
2206952 2206952 2022-02-12 San Mateo California 6081 122691 685
2203699 2203699 2022-02-11 San Mateo California 6081 122691 685
2200446 2200446 2022-02-10 San Mateo California 6081 122346 665
2197192 2197192 2022-02-09 San Mateo California 6081 129567 665
2193937 2193937 2022-02-08 San Mateo California 6081 122086 665
2190684 2190684 2022-02-07 San Mateo California 6081 120582 665
2187431 2187431 2022-02-06 San Mateo California 6081 119836 665
2184178 2184178 2022-02-05 San Mateo California 6081 119836 665
2180926 2180926 2022-02-04 San Mateo California 6081 119836 665
2177675 2177675 2022-02-03 San Mateo California 6081 119227 655

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);
Powered by Datasette · Queries took 84.836ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette