ny_times_us_counties

Table actions
⚠️ 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

9,212 rows where county = "Adams" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 12

fips 12

county 1

  • Adams · 9,212 ✖
Link rowid date ▲ county state fips cases deaths
2499820 2499820 2022-05-13 Adams Colorado 8001 137720 1380
2500134 2500134 2022-05-13 Adams Idaho 16003 704 15
2500177 2500177 2022-05-13 Adams Illinois 17001 22525 238
2500280 2500280 2022-05-13 Adams Indiana 18001 7288 112
2500374 2500374 2022-05-13 Adams Iowa 19003 820 14
2500993 2500993 2022-05-13 Adams Mississippi 28001 7224 143
2501249 2501249 2022-05-13 Adams Nebraska 31001 6541 73
2501586 2501586 2022-05-13 Adams North Dakota 38001 598 10
2501644 2501644 2022-05-13 Adams Ohio 39001 7022 148
2501847 2501847 2022-05-13 Adams Pennsylvania 42001 25114 364
2502643 2502643 2022-05-13 Adams Washington 53001 4926 39
2502738 2502738 2022-05-13 Adams Wisconsin 55001 4738 61
2496562 2496562 2022-05-12 Adams Colorado 8001 137545 1379
2496876 2496876 2022-05-12 Adams Idaho 16003 703 15
2496919 2496919 2022-05-12 Adams Illinois 17001 22513 238
2497022 2497022 2022-05-12 Adams Indiana 18001 7284 112
2497116 2497116 2022-05-12 Adams Iowa 19003 820 14
2497735 2497735 2022-05-12 Adams Mississippi 28001 7224 143
2497991 2497991 2022-05-12 Adams Nebraska 31001 6529 73
2498328 2498328 2022-05-12 Adams North Dakota 38001 598 10
2498386 2498386 2022-05-12 Adams Ohio 39001 7022 148
2498589 2498589 2022-05-12 Adams Pennsylvania 42001 25114 364
2499385 2499385 2022-05-12 Adams Washington 53001 4925 39
2499480 2499480 2022-05-12 Adams Wisconsin 55001 4727 61
2493304 2493304 2022-05-11 Adams Colorado 8001 137428 1378
2493618 2493618 2022-05-11 Adams Idaho 16003 703 15
2493661 2493661 2022-05-11 Adams Illinois 17001 22496 238
2493764 2493764 2022-05-11 Adams Indiana 18001 7284 112
2493858 2493858 2022-05-11 Adams Iowa 19003 820 14
2494477 2494477 2022-05-11 Adams Mississippi 28001 7224 143
2494733 2494733 2022-05-11 Adams Nebraska 31001 6529 73
2495070 2495070 2022-05-11 Adams North Dakota 38001 598 10
2495128 2495128 2022-05-11 Adams Ohio 39001 6999 148
2495331 2495331 2022-05-11 Adams Pennsylvania 42001 25114 364
2496127 2496127 2022-05-11 Adams Washington 53001 4925 39
2496222 2496222 2022-05-11 Adams Wisconsin 55001 4717 61
2490046 2490046 2022-05-10 Adams Colorado 8001 137373 1378
2490360 2490360 2022-05-10 Adams Idaho 16003 703 15
2490403 2490403 2022-05-10 Adams Illinois 17001 22486 238
2490506 2490506 2022-05-10 Adams Indiana 18001 7281 112
2490600 2490600 2022-05-10 Adams Iowa 19003 819 13
2491219 2491219 2022-05-10 Adams Mississippi 28001 7224 143
2491475 2491475 2022-05-10 Adams Nebraska 31001 6655 73
2491812 2491812 2022-05-10 Adams North Dakota 38001 598 10
2491870 2491870 2022-05-10 Adams Ohio 39001 6999 148
2492073 2492073 2022-05-10 Adams Pennsylvania 42001 24996 362
2492869 2492869 2022-05-10 Adams Washington 53001 4921 38
2492964 2492964 2022-05-10 Adams Wisconsin 55001 4706 61
2486789 2486789 2022-05-09 Adams Colorado 8001 137047 1376
2487103 2487103 2022-05-09 Adams Idaho 16003 703 15
2487146 2487146 2022-05-09 Adams Illinois 17001 22479 238
2487249 2487249 2022-05-09 Adams Indiana 18001 7281 112
2487343 2487343 2022-05-09 Adams Iowa 19003 819 13
2487962 2487962 2022-05-09 Adams Mississippi 28001 7224 143
2488217 2488217 2022-05-09 Adams Nebraska 31001 6655 73
2488554 2488554 2022-05-09 Adams North Dakota 38001 598 10
2488612 2488612 2022-05-09 Adams Ohio 39001 6999 148
2488815 2488815 2022-05-09 Adams Pennsylvania 42001 24996 362
2489611 2489611 2022-05-09 Adams Washington 53001 4921 38
2489706 2489706 2022-05-09 Adams Wisconsin 55001 4705 61
2483531 2483531 2022-05-08 Adams Colorado 8001 137047 1376
2483845 2483845 2022-05-08 Adams Idaho 16003 703 15
2483888 2483888 2022-05-08 Adams Illinois 17001 22469 238
2483991 2483991 2022-05-08 Adams Indiana 18001 7276 112
2484085 2484085 2022-05-08 Adams Iowa 19003 819 13
2484704 2484704 2022-05-08 Adams Mississippi 28001 7174 142
2484960 2484960 2022-05-08 Adams Nebraska 31001 6660 73
2485297 2485297 2022-05-08 Adams North Dakota 38001 598 10
2485355 2485355 2022-05-08 Adams Ohio 39001 6999 148
2485558 2485558 2022-05-08 Adams Pennsylvania 42001 24996 362
2486354 2486354 2022-05-08 Adams Washington 53001 4920 38
2486449 2486449 2022-05-08 Adams Wisconsin 55001 4689 61
2480273 2480273 2022-05-07 Adams Colorado 8001 137047 1376
2480587 2480587 2022-05-07 Adams Idaho 16003 703 15
2480630 2480630 2022-05-07 Adams Illinois 17001 22469 238
2480733 2480733 2022-05-07 Adams Indiana 18001 7276 112
2480827 2480827 2022-05-07 Adams Iowa 19003 819 13
2481446 2481446 2022-05-07 Adams Mississippi 28001 7174 142
2481702 2481702 2022-05-07 Adams Nebraska 31001 6660 73
2482039 2482039 2022-05-07 Adams North Dakota 38001 598 10
2482097 2482097 2022-05-07 Adams Ohio 39001 6999 148
2482300 2482300 2022-05-07 Adams Pennsylvania 42001 24996 362
2483096 2483096 2022-05-07 Adams Washington 53001 4920 38
2483191 2483191 2022-05-07 Adams Wisconsin 55001 4689 61
2477015 2477015 2022-05-06 Adams Colorado 8001 137033 1376
2477329 2477329 2022-05-06 Adams Idaho 16003 703 15
2477372 2477372 2022-05-06 Adams Illinois 17001 22469 238
2477475 2477475 2022-05-06 Adams Indiana 18001 7276 112
2477569 2477569 2022-05-06 Adams Iowa 19003 819 13
2478188 2478188 2022-05-06 Adams Mississippi 28001 7174 142
2478444 2478444 2022-05-06 Adams Nebraska 31001 6660 73
2478781 2478781 2022-05-06 Adams North Dakota 38001 598 10
2478839 2478839 2022-05-06 Adams Ohio 39001 6999 148
2479042 2479042 2022-05-06 Adams Pennsylvania 42001 24996 362
2479838 2479838 2022-05-06 Adams Washington 53001 4920 38
2479933 2479933 2022-05-06 Adams Wisconsin 55001 4689 61
2473757 2473757 2022-05-05 Adams Colorado 8001 136944 1375
2474071 2474071 2022-05-05 Adams Idaho 16003 702 15
2474114 2474114 2022-05-05 Adams Illinois 17001 22460 238
2474217 2474217 2022-05-05 Adams Indiana 18001 7276 112

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);