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

1,571 rows where county = "Genesee" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

  • Michigan 786
  • New York 785

fips 2

  • 26049 786
  • 36037 785

county 1

  • Genesee · 1,571 ✖
Link rowid date ▲ county state fips cases deaths
2500845 2500845 2022-05-13 Genesee Michigan 26049 103601 1720
2501445 2501445 2022-05-13 Genesee New York 36037 14395 187
2497587 2497587 2022-05-12 Genesee Michigan 26049 103601 1720
2498187 2498187 2022-05-12 Genesee New York 36037 14395 187
2494329 2494329 2022-05-11 Genesee Michigan 26049 103601 1720
2494929 2494929 2022-05-11 Genesee New York 36037 14363 187
2491071 2491071 2022-05-10 Genesee Michigan 26049 102660 1715
2491671 2491671 2022-05-10 Genesee New York 36037 14331 187
2487814 2487814 2022-05-09 Genesee Michigan 26049 102660 1715
2488413 2488413 2022-05-09 Genesee New York 36037 14304 187
2484556 2484556 2022-05-08 Genesee Michigan 26049 102660 1715
2485156 2485156 2022-05-08 Genesee New York 36037 14281 187
2481298 2481298 2022-05-07 Genesee Michigan 26049 102660 1715
2481898 2481898 2022-05-07 Genesee New York 36037 14255 187
2478040 2478040 2022-05-06 Genesee Michigan 26049 102660 1715
2478640 2478640 2022-05-06 Genesee New York 36037 14230 187
2474782 2474782 2022-05-05 Genesee Michigan 26049 102660 1715
2475382 2475382 2022-05-05 Genesee New York 36037 14207 187
2471525 2471525 2022-05-04 Genesee Michigan 26049 102660 1715
2472125 2472125 2022-05-04 Genesee New York 36037 14181 187
2468269 2468269 2022-05-03 Genesee Michigan 26049 102026 1715
2468869 2468869 2022-05-03 Genesee New York 36037 14150 186
2465014 2465014 2022-05-02 Genesee Michigan 26049 102026 1715
2465613 2465613 2022-05-02 Genesee New York 36037 14126 186
2461758 2461758 2022-05-01 Genesee Michigan 26049 102026 1715
2462358 2462358 2022-05-01 Genesee New York 36037 14102 186
2458502 2458502 2022-04-30 Genesee Michigan 26049 102026 1715
2459102 2459102 2022-04-30 Genesee New York 36037 14085 186
2455246 2455246 2022-04-29 Genesee Michigan 26049 102026 1715
2455846 2455846 2022-04-29 Genesee New York 36037 14063 186
2451990 2451990 2022-04-28 Genesee Michigan 26049 102026 1715
2452590 2452590 2022-04-28 Genesee New York 36037 14038 186
2448734 2448734 2022-04-27 Genesee Michigan 26049 102026 1715
2449334 2449334 2022-04-27 Genesee New York 36037 14001 185
2445478 2445478 2022-04-26 Genesee Michigan 26049 101611 1711
2446077 2446077 2022-04-26 Genesee New York 36037 13972 185
2442222 2442222 2022-04-25 Genesee Michigan 26049 101611 1711
2442822 2442822 2022-04-25 Genesee New York 36037 13950 185
2438966 2438966 2022-04-24 Genesee Michigan 26049 101611 1711
2439566 2439566 2022-04-24 Genesee New York 36037 13929 185
2435710 2435710 2022-04-23 Genesee Michigan 26049 101611 1711
2436310 2436310 2022-04-23 Genesee New York 36037 13894 185
2432454 2432454 2022-04-22 Genesee Michigan 26049 101611 1711
2433054 2433054 2022-04-22 Genesee New York 36037 13874 185
2429198 2429198 2022-04-21 Genesee Michigan 26049 101611 1711
2429798 2429798 2022-04-21 Genesee New York 36037 13847 185
2425942 2425942 2022-04-20 Genesee Michigan 26049 101611 1711
2426542 2426542 2022-04-20 Genesee New York 36037 13824 185
2422686 2422686 2022-04-19 Genesee Michigan 26049 101373 1707
2423286 2423286 2022-04-19 Genesee New York 36037 13801 185
2419430 2419430 2022-04-18 Genesee Michigan 26049 101373 1707
2420029 2420029 2022-04-18 Genesee New York 36037 13793 185
2416174 2416174 2022-04-17 Genesee Michigan 26049 101373 1707
2416774 2416774 2022-04-17 Genesee New York 36037 13772 185
2412918 2412918 2022-04-16 Genesee Michigan 26049 101373 1707
2413518 2413518 2022-04-16 Genesee New York 36037 13761 185
2409662 2409662 2022-04-15 Genesee Michigan 26049 101373 1707
2410262 2410262 2022-04-15 Genesee New York 36037 13752 185
2406406 2406406 2022-04-14 Genesee Michigan 26049 101373 1707
2407006 2407006 2022-04-14 Genesee New York 36037 13733 185
2403150 2403150 2022-04-13 Genesee Michigan 26049 101373 1707
2403750 2403750 2022-04-13 Genesee New York 36037 13715 185
2399896 2399896 2022-04-12 Genesee Michigan 26049 101180 1705
2400495 2400495 2022-04-12 Genesee New York 36037 13703 185
2396640 2396640 2022-04-11 Genesee Michigan 26049 101180 1705
2397240 2397240 2022-04-11 Genesee New York 36037 13701 185
2393385 2393385 2022-04-10 Genesee Michigan 26049 101180 1705
2393985 2393985 2022-04-10 Genesee New York 36037 13697 185
2390129 2390129 2022-04-09 Genesee Michigan 26049 101180 1705
2390729 2390729 2022-04-09 Genesee New York 36037 13685 185
2386873 2386873 2022-04-08 Genesee Michigan 26049 101180 1705
2387473 2387473 2022-04-08 Genesee New York 36037 13677 185
2383618 2383618 2022-04-07 Genesee Michigan 26049 101180 1705
2384218 2384218 2022-04-07 Genesee New York 36037 13669 185
2380363 2380363 2022-04-06 Genesee Michigan 26049 101180 1705
2380963 2380963 2022-04-06 Genesee New York 36037 13655 185
2377108 2377108 2022-04-05 Genesee Michigan 26049 101110 1704
2377708 2377708 2022-04-05 Genesee New York 36037 13651 184
2373856 2373856 2022-04-04 Genesee Michigan 26049 101110 1704
2374455 2374455 2022-04-04 Genesee New York 36037 13649 184
2370603 2370603 2022-04-03 Genesee Michigan 26049 101110 1704
2371203 2371203 2022-04-03 Genesee New York 36037 13642 184
2367350 2367350 2022-04-02 Genesee Michigan 26049 101110 1704
2367950 2367950 2022-04-02 Genesee New York 36037 13641 184
2364097 2364097 2022-04-01 Genesee Michigan 26049 101110 1704
2364697 2364697 2022-04-01 Genesee New York 36037 13632 184
2360843 2360843 2022-03-31 Genesee Michigan 26049 101031 1704
2361443 2361443 2022-03-31 Genesee New York 36037 13627 184
2357589 2357589 2022-03-30 Genesee Michigan 26049 101031 1704
2358189 2358189 2022-03-30 Genesee New York 36037 13620 184
2354336 2354336 2022-03-29 Genesee Michigan 26049 100944 1700
2354935 2354935 2022-03-29 Genesee New York 36037 13615 184
2351084 2351084 2022-03-28 Genesee Michigan 26049 100944 1700
2351682 2351682 2022-03-28 Genesee New York 36037 13611 184
2347831 2347831 2022-03-27 Genesee Michigan 26049 100916 1698
2348430 2348430 2022-03-27 Genesee New York 36037 13611 184
2344578 2344578 2022-03-26 Genesee Michigan 26049 100916 1698
2345177 2345177 2022-03-26 Genesee New York 36037 13610 184
2341325 2341325 2022-03-25 Genesee Michigan 26049 100916 1698
2341924 2341924 2022-03-25 Genesee New York 36037 13600 184

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 97.877ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette