ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,932 rows where county = "Knox" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
county 1
- Knox · 6,932 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500224 | 2500224 | 2022-05-13 | Knox | Illinois | 17095 | 12722 | 246 |
2500321 | 2500321 | 2022-05-13 | Knox | Indiana | 18083 | 10800 | 153 |
2500639 | 2500639 | 2022-05-13 | Knox | Kentucky | 21121 | 11523 | 144 |
2500770 | 2500770 | 2022-05-13 | Knox | Maine | 23013 | 6414 | 38 |
2501129 | 2501129 | 2022-05-13 | Knox | Missouri | 29103 | 990 | 14 |
2501302 | 2501302 | 2022-05-13 | Knox | Nebraska | 31107 | 1667 | 13 |
2501685 | 2501685 | 2022-05-13 | Knox | Ohio | 39083 | 13325 | 228 |
2502157 | 2502157 | 2022-05-13 | Knox | Tennessee | 47093 | 128707 | 1385 |
2502344 | 2502344 | 2022-05-13 | Knox | Texas | 48275 | 492 | 25 |
2496966 | 2496966 | 2022-05-12 | Knox | Illinois | 17095 | 12705 | 246 |
2497063 | 2497063 | 2022-05-12 | Knox | Indiana | 18083 | 10792 | 153 |
2497381 | 2497381 | 2022-05-12 | Knox | Kentucky | 21121 | 11523 | 144 |
2497512 | 2497512 | 2022-05-12 | Knox | Maine | 23013 | 6391 | 38 |
2497871 | 2497871 | 2022-05-12 | Knox | Missouri | 29103 | 989 | 14 |
2498044 | 2498044 | 2022-05-12 | Knox | Nebraska | 31107 | 1666 | 13 |
2498427 | 2498427 | 2022-05-12 | Knox | Ohio | 39083 | 13325 | 228 |
2498899 | 2498899 | 2022-05-12 | Knox | Tennessee | 47093 | 128707 | 1385 |
2499086 | 2499086 | 2022-05-12 | Knox | Texas | 48275 | 492 | 25 |
2493708 | 2493708 | 2022-05-11 | Knox | Illinois | 17095 | 12692 | 246 |
2493805 | 2493805 | 2022-05-11 | Knox | Indiana | 18083 | 10792 | 153 |
2494123 | 2494123 | 2022-05-11 | Knox | Kentucky | 21121 | 11523 | 144 |
2494254 | 2494254 | 2022-05-11 | Knox | Maine | 23013 | 6381 | 37 |
2494613 | 2494613 | 2022-05-11 | Knox | Missouri | 29103 | 989 | 14 |
2494786 | 2494786 | 2022-05-11 | Knox | Nebraska | 31107 | 1666 | 13 |
2495169 | 2495169 | 2022-05-11 | Knox | Ohio | 39083 | 13255 | 228 |
2495641 | 2495641 | 2022-05-11 | Knox | Tennessee | 47093 | 128707 | 1385 |
2495828 | 2495828 | 2022-05-11 | Knox | Texas | 48275 | 492 | 25 |
2490450 | 2490450 | 2022-05-10 | Knox | Illinois | 17095 | 12680 | 246 |
2490547 | 2490547 | 2022-05-10 | Knox | Indiana | 18083 | 10785 | 153 |
2490865 | 2490865 | 2022-05-10 | Knox | Kentucky | 21121 | 11523 | 144 |
2490996 | 2490996 | 2022-05-10 | Knox | Maine | 23013 | 6360 | 37 |
2491355 | 2491355 | 2022-05-10 | Knox | Missouri | 29103 | 989 | 14 |
2491528 | 2491528 | 2022-05-10 | Knox | Nebraska | 31107 | 1694 | 13 |
2491911 | 2491911 | 2022-05-10 | Knox | Ohio | 39083 | 13255 | 228 |
2492383 | 2492383 | 2022-05-10 | Knox | Tennessee | 47093 | 128435 | 1380 |
2492570 | 2492570 | 2022-05-10 | Knox | Texas | 48275 | 492 | 25 |
2487193 | 2487193 | 2022-05-09 | Knox | Illinois | 17095 | 12666 | 246 |
2487290 | 2487290 | 2022-05-09 | Knox | Indiana | 18083 | 10785 | 153 |
2487608 | 2487608 | 2022-05-09 | Knox | Kentucky | 21121 | 11523 | 144 |
2487739 | 2487739 | 2022-05-09 | Knox | Maine | 23013 | 6340 | 37 |
2488097 | 2488097 | 2022-05-09 | Knox | Missouri | 29103 | 989 | 14 |
2488270 | 2488270 | 2022-05-09 | Knox | Nebraska | 31107 | 1694 | 13 |
2488653 | 2488653 | 2022-05-09 | Knox | Ohio | 39083 | 13255 | 228 |
2489125 | 2489125 | 2022-05-09 | Knox | Tennessee | 47093 | 128435 | 1380 |
2489312 | 2489312 | 2022-05-09 | Knox | Texas | 48275 | 492 | 25 |
2483935 | 2483935 | 2022-05-08 | Knox | Illinois | 17095 | 12653 | 246 |
2484032 | 2484032 | 2022-05-08 | Knox | Indiana | 18083 | 10770 | 153 |
2484350 | 2484350 | 2022-05-08 | Knox | Kentucky | 21121 | 11512 | 141 |
2484481 | 2484481 | 2022-05-08 | Knox | Maine | 23013 | 6333 | 37 |
2484840 | 2484840 | 2022-05-08 | Knox | Missouri | 29103 | 989 | 14 |
2485013 | 2485013 | 2022-05-08 | Knox | Nebraska | 31107 | 1693 | 13 |
2485396 | 2485396 | 2022-05-08 | Knox | Ohio | 39083 | 13255 | 228 |
2485868 | 2485868 | 2022-05-08 | Knox | Tennessee | 47093 | 128435 | 1380 |
2486055 | 2486055 | 2022-05-08 | Knox | Texas | 48275 | 492 | 25 |
2480677 | 2480677 | 2022-05-07 | Knox | Illinois | 17095 | 12653 | 246 |
2480774 | 2480774 | 2022-05-07 | Knox | Indiana | 18083 | 10770 | 153 |
2481092 | 2481092 | 2022-05-07 | Knox | Kentucky | 21121 | 11512 | 141 |
2481223 | 2481223 | 2022-05-07 | Knox | Maine | 23013 | 6333 | 37 |
2481582 | 2481582 | 2022-05-07 | Knox | Missouri | 29103 | 989 | 14 |
2481755 | 2481755 | 2022-05-07 | Knox | Nebraska | 31107 | 1693 | 13 |
2482138 | 2482138 | 2022-05-07 | Knox | Ohio | 39083 | 13255 | 228 |
2482610 | 2482610 | 2022-05-07 | Knox | Tennessee | 47093 | 128435 | 1380 |
2482797 | 2482797 | 2022-05-07 | Knox | Texas | 48275 | 492 | 25 |
2477419 | 2477419 | 2022-05-06 | Knox | Illinois | 17095 | 12653 | 246 |
2477516 | 2477516 | 2022-05-06 | Knox | Indiana | 18083 | 10770 | 153 |
2477834 | 2477834 | 2022-05-06 | Knox | Kentucky | 21121 | 11512 | 141 |
2477965 | 2477965 | 2022-05-06 | Knox | Maine | 23013 | 6315 | 37 |
2478324 | 2478324 | 2022-05-06 | Knox | Missouri | 29103 | 989 | 14 |
2478497 | 2478497 | 2022-05-06 | Knox | Nebraska | 31107 | 1693 | 13 |
2478880 | 2478880 | 2022-05-06 | Knox | Ohio | 39083 | 13255 | 228 |
2479352 | 2479352 | 2022-05-06 | Knox | Tennessee | 47093 | 128435 | 1380 |
2479539 | 2479539 | 2022-05-06 | Knox | Texas | 48275 | 492 | 25 |
2474161 | 2474161 | 2022-05-05 | Knox | Illinois | 17095 | 12645 | 246 |
2474258 | 2474258 | 2022-05-05 | Knox | Indiana | 18083 | 10770 | 153 |
2474576 | 2474576 | 2022-05-05 | Knox | Kentucky | 21121 | 11512 | 141 |
2474707 | 2474707 | 2022-05-05 | Knox | Maine | 23013 | 6291 | 36 |
2475066 | 2475066 | 2022-05-05 | Knox | Missouri | 29103 | 985 | 14 |
2475239 | 2475239 | 2022-05-05 | Knox | Nebraska | 31107 | 1693 | 13 |
2475622 | 2475622 | 2022-05-05 | Knox | Ohio | 39083 | 13255 | 228 |
2476094 | 2476094 | 2022-05-05 | Knox | Tennessee | 47093 | 128435 | 1380 |
2476281 | 2476281 | 2022-05-05 | Knox | Texas | 48275 | 492 | 25 |
2470904 | 2470904 | 2022-05-04 | Knox | Illinois | 17095 | 12637 | 246 |
2471001 | 2471001 | 2022-05-04 | Knox | Indiana | 18083 | 10770 | 153 |
2471319 | 2471319 | 2022-05-04 | Knox | Kentucky | 21121 | 11512 | 141 |
2471450 | 2471450 | 2022-05-04 | Knox | Maine | 23013 | 6268 | 36 |
2471809 | 2471809 | 2022-05-04 | Knox | Missouri | 29103 | 977 | 13 |
2471982 | 2471982 | 2022-05-04 | Knox | Nebraska | 31107 | 1693 | 13 |
2472365 | 2472365 | 2022-05-04 | Knox | Ohio | 39083 | 13219 | 228 |
2472837 | 2472837 | 2022-05-04 | Knox | Tennessee | 47093 | 128435 | 1380 |
2473024 | 2473024 | 2022-05-04 | Knox | Texas | 48275 | 492 | 25 |
2467648 | 2467648 | 2022-05-03 | Knox | Illinois | 17095 | 12632 | 246 |
2467745 | 2467745 | 2022-05-03 | Knox | Indiana | 18083 | 10766 | 153 |
2468063 | 2468063 | 2022-05-03 | Knox | Kentucky | 21121 | 11512 | 141 |
2468194 | 2468194 | 2022-05-03 | Knox | Maine | 23013 | 6243 | 36 |
2468553 | 2468553 | 2022-05-03 | Knox | Missouri | 29103 | 977 | 13 |
2468726 | 2468726 | 2022-05-03 | Knox | Nebraska | 31107 | 1693 | 13 |
2469109 | 2469109 | 2022-05-03 | Knox | Ohio | 39083 | 13219 | 228 |
2469581 | 2469581 | 2022-05-03 | Knox | Tennessee | 47093 | 128199 | 1378 |
2469768 | 2469768 | 2022-05-03 | Knox | Texas | 48275 | 492 | 25 |
2464393 | 2464393 | 2022-05-02 | Knox | Illinois | 17095 | 12623 | 246 |
Advanced export
JSON shape: default, array, newline-delimited
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);