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

6,200 rows where county = "Boone" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 8

fips 8

county 1

  • Boone · 6,200 ✖
Link rowid date ▲ county state fips cases deaths
2499690 2499690 2022-05-13 Boone Arkansas 5009 9468 179
2500180 2500180 2022-05-13 Boone Illinois 17007 14162 130
2500285 2500285 2022-05-13 Boone Indiana 18011 15456 186
2500380 2500380 2022-05-13 Boone Iowa 19015 5519 54
2500586 2500586 2022-05-13 Boone Kentucky 21015 40084 297
2501085 2501085 2022-05-13 Boone Missouri 29019 45035 252
2501254 2501254 2022-05-13 Boone Nebraska 31011 1074 5
2502685 2502685 2022-05-13 Boone West Virginia 54005 6660 75
2496432 2496432 2022-05-12 Boone Arkansas 5009 9465 179
2496922 2496922 2022-05-12 Boone Illinois 17007 14140 130
2497027 2497027 2022-05-12 Boone Indiana 18011 15430 186
2497122 2497122 2022-05-12 Boone Iowa 19015 5519 54
2497328 2497328 2022-05-12 Boone Kentucky 21015 39942 297
2497827 2497827 2022-05-12 Boone Missouri 29019 44976 250
2497996 2497996 2022-05-12 Boone Nebraska 31011 1073 5
2499427 2499427 2022-05-12 Boone West Virginia 54005 6655 75
2493174 2493174 2022-05-11 Boone Arkansas 5009 9463 179
2493664 2493664 2022-05-11 Boone Illinois 17007 14122 130
2493769 2493769 2022-05-11 Boone Indiana 18011 15430 186
2493864 2493864 2022-05-11 Boone Iowa 19015 5519 54
2494070 2494070 2022-05-11 Boone Kentucky 21015 39942 297
2494569 2494569 2022-05-11 Boone Missouri 29019 44932 250
2494738 2494738 2022-05-11 Boone Nebraska 31011 1073 5
2496169 2496169 2022-05-11 Boone West Virginia 54005 6650 75
2489916 2489916 2022-05-10 Boone Arkansas 5009 9462 179
2490406 2490406 2022-05-10 Boone Illinois 17007 14106 130
2490511 2490511 2022-05-10 Boone Indiana 18011 15404 185
2490606 2490606 2022-05-10 Boone Iowa 19015 5505 54
2490812 2490812 2022-05-10 Boone Kentucky 21015 39942 297
2491311 2491311 2022-05-10 Boone Missouri 29019 44876 250
2491480 2491480 2022-05-10 Boone Nebraska 31011 1111 5
2492911 2492911 2022-05-10 Boone West Virginia 54005 6632 75
2486659 2486659 2022-05-09 Boone Arkansas 5009 9457 180
2487149 2487149 2022-05-09 Boone Illinois 17007 14095 130
2487254 2487254 2022-05-09 Boone Indiana 18011 15404 185
2487349 2487349 2022-05-09 Boone Iowa 19015 5505 54
2487555 2487555 2022-05-09 Boone Kentucky 21015 39942 297
2488053 2488053 2022-05-09 Boone Missouri 29019 44836 250
2488222 2488222 2022-05-09 Boone Nebraska 31011 1111 5
2489653 2489653 2022-05-09 Boone West Virginia 54005 6632 75
2483401 2483401 2022-05-08 Boone Arkansas 5009 9457 180
2483891 2483891 2022-05-08 Boone Illinois 17007 14062 130
2483996 2483996 2022-05-08 Boone Indiana 18011 15357 184
2484091 2484091 2022-05-08 Boone Iowa 19015 5505 54
2484297 2484297 2022-05-08 Boone Kentucky 21015 39942 290
2484796 2484796 2022-05-08 Boone Missouri 29019 44754 250
2484965 2484965 2022-05-08 Boone Nebraska 31011 1111 5
2486396 2486396 2022-05-08 Boone West Virginia 54005 6612 75
2480143 2480143 2022-05-07 Boone Arkansas 5009 9457 180
2480633 2480633 2022-05-07 Boone Illinois 17007 14062 130
2480738 2480738 2022-05-07 Boone Indiana 18011 15357 184
2480833 2480833 2022-05-07 Boone Iowa 19015 5505 54
2481039 2481039 2022-05-07 Boone Kentucky 21015 39942 290
2481538 2481538 2022-05-07 Boone Missouri 29019 44754 250
2481707 2481707 2022-05-07 Boone Nebraska 31011 1111 5
2483138 2483138 2022-05-07 Boone West Virginia 54005 6612 75
2476885 2476885 2022-05-06 Boone Arkansas 5009 9454 180
2477375 2477375 2022-05-06 Boone Illinois 17007 14062 130
2477480 2477480 2022-05-06 Boone Indiana 18011 15357 184
2477575 2477575 2022-05-06 Boone Iowa 19015 5505 54
2477781 2477781 2022-05-06 Boone Kentucky 21015 39942 290
2478280 2478280 2022-05-06 Boone Missouri 29019 44754 250
2478449 2478449 2022-05-06 Boone Nebraska 31011 1111 5
2479880 2479880 2022-05-06 Boone West Virginia 54005 6612 75
2473627 2473627 2022-05-05 Boone Arkansas 5009 9454 180
2474117 2474117 2022-05-05 Boone Illinois 17007 14034 130
2474222 2474222 2022-05-05 Boone Indiana 18011 15357 184
2474317 2474317 2022-05-05 Boone Iowa 19015 5505 54
2474523 2474523 2022-05-05 Boone Kentucky 21015 39848 290
2475022 2475022 2022-05-05 Boone Missouri 29019 44730 250
2475191 2475191 2022-05-05 Boone Nebraska 31011 1111 5
2476622 2476622 2022-05-05 Boone West Virginia 54005 6609 75
2470370 2470370 2022-05-04 Boone Arkansas 5009 9448 180
2470860 2470860 2022-05-04 Boone Illinois 17007 14019 130
2470965 2470965 2022-05-04 Boone Indiana 18011 15357 184
2471060 2471060 2022-05-04 Boone Iowa 19015 5505 54
2471266 2471266 2022-05-04 Boone Kentucky 21015 39848 290
2471765 2471765 2022-05-04 Boone Missouri 29019 44697 250
2471934 2471934 2022-05-04 Boone Nebraska 31011 1112 5
2473364 2473364 2022-05-04 Boone West Virginia 54005 6607 75
2467114 2467114 2022-05-03 Boone Arkansas 5009 9445 180
2467604 2467604 2022-05-03 Boone Illinois 17007 13997 129
2467709 2467709 2022-05-03 Boone Indiana 18011 15345 184
2467804 2467804 2022-05-03 Boone Iowa 19015 5495 54
2468010 2468010 2022-05-03 Boone Kentucky 21015 39848 290
2468509 2468509 2022-05-03 Boone Missouri 29019 44677 250
2468678 2468678 2022-05-03 Boone Nebraska 31011 1112 5
2470107 2470107 2022-05-03 Boone West Virginia 54005 6606 75
2463859 2463859 2022-05-02 Boone Arkansas 5009 9446 180
2464349 2464349 2022-05-02 Boone Illinois 17007 13984 129
2464454 2464454 2022-05-02 Boone Indiana 18011 15345 184
2464549 2464549 2022-05-02 Boone Iowa 19015 5495 54
2464755 2464755 2022-05-02 Boone Kentucky 21015 39848 290
2465253 2465253 2022-05-02 Boone Missouri 29019 44656 250
2465422 2465422 2022-05-02 Boone Nebraska 31011 1110 5
2466851 2466851 2022-05-02 Boone West Virginia 54005 6603 75
2460603 2460603 2022-05-01 Boone Arkansas 5009 9446 180
2461093 2461093 2022-05-01 Boone Illinois 17007 13944 129
2461198 2461198 2022-05-01 Boone Indiana 18011 15328 183
2461293 2461293 2022-05-01 Boone Iowa 19015 5495 54

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