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 rowid
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 |
---|---|---|---|---|---|---|---|
1571 | 1571 | 2020-03-12 | Knox | Tennessee | 47093 | 1 | 0 |
1874 | 1874 | 2020-03-13 | Knox | Tennessee | 47093 | 1 | 0 |
2239 | 2239 | 2020-03-14 | Knox | Tennessee | 47093 | 1 | 0 |
2664 | 2664 | 2020-03-15 | Knox | Tennessee | 47093 | 1 | 0 |
3130 | 3130 | 2020-03-16 | Knox | Tennessee | 47093 | 1 | 0 |
3507 | 3507 | 2020-03-17 | Knox | Nebraska | 31107 | 1 | 0 |
3663 | 3663 | 2020-03-17 | Knox | Tennessee | 47093 | 2 | 0 |
4099 | 4099 | 2020-03-18 | Knox | Nebraska | 31107 | 2 | 0 |
4284 | 4284 | 2020-03-18 | Knox | Tennessee | 47093 | 2 | 0 |
4822 | 4822 | 2020-03-19 | Knox | Nebraska | 31107 | 2 | 0 |
5031 | 5031 | 2020-03-19 | Knox | Tennessee | 47093 | 2 | 0 |
5662 | 5662 | 2020-03-20 | Knox | Nebraska | 31107 | 2 | 0 |
5918 | 5918 | 2020-03-20 | Knox | Tennessee | 47093 | 3 | 0 |
6654 | 6654 | 2020-03-21 | Knox | Nebraska | 31107 | 2 | 0 |
6931 | 6931 | 2020-03-21 | Knox | Tennessee | 47093 | 4 | 0 |
7744 | 7744 | 2020-03-22 | Knox | Nebraska | 31107 | 2 | 0 |
8057 | 8057 | 2020-03-22 | Knox | Tennessee | 47093 | 5 | 0 |
8728 | 8728 | 2020-03-23 | Knox | Maine | 23013 | 1 | 0 |
8937 | 8937 | 2020-03-23 | Knox | Nebraska | 31107 | 2 | 0 |
9115 | 9115 | 2020-03-23 | Knox | Ohio | 39083 | 1 | 0 |
9275 | 9275 | 2020-03-23 | Knox | Tennessee | 47093 | 5 | 0 |
10017 | 10017 | 2020-03-24 | Knox | Maine | 23013 | 1 | 0 |
10240 | 10240 | 2020-03-24 | Knox | Nebraska | 31107 | 2 | 0 |
10431 | 10431 | 2020-03-24 | Knox | Ohio | 39083 | 1 | 0 |
10606 | 10606 | 2020-03-24 | Knox | Tennessee | 47093 | 15 | 0 |
11426 | 11426 | 2020-03-25 | Knox | Maine | 23013 | 1 | 0 |
11671 | 11671 | 2020-03-25 | Knox | Nebraska | 31107 | 2 | 0 |
11879 | 11879 | 2020-03-25 | Knox | Ohio | 39083 | 2 | 0 |
12084 | 12084 | 2020-03-25 | Knox | Tennessee | 47093 | 20 | 0 |
13007 | 13007 | 2020-03-26 | Knox | Maine | 23013 | 1 | 0 |
13274 | 13274 | 2020-03-26 | Knox | Nebraska | 31107 | 2 | 0 |
13487 | 13487 | 2020-03-26 | Knox | Ohio | 39083 | 2 | 0 |
13708 | 13708 | 2020-03-26 | Knox | Tennessee | 47093 | 26 | 0 |
14715 | 14715 | 2020-03-27 | Knox | Maine | 23013 | 2 | 0 |
15006 | 15006 | 2020-03-27 | Knox | Nebraska | 31107 | 2 | 0 |
15225 | 15225 | 2020-03-27 | Knox | Ohio | 39083 | 2 | 0 |
15460 | 15460 | 2020-03-27 | Knox | Tennessee | 47093 | 31 | 0 |
16535 | 16535 | 2020-03-28 | Knox | Maine | 23013 | 2 | 0 |
16833 | 16833 | 2020-03-28 | Knox | Nebraska | 31107 | 2 | 0 |
17067 | 17067 | 2020-03-28 | Knox | Ohio | 39083 | 2 | 0 |
17323 | 17323 | 2020-03-28 | Knox | Tennessee | 47093 | 33 | 0 |
18136 | 18136 | 2020-03-29 | Knox | Illinois | 17095 | 1 | 0 |
18196 | 18196 | 2020-03-29 | Knox | Indiana | 18083 | 2 | 0 |
18449 | 18449 | 2020-03-29 | Knox | Maine | 23013 | 4 | 0 |
18756 | 18756 | 2020-03-29 | Knox | Nebraska | 31107 | 2 | 0 |
19001 | 19001 | 2020-03-29 | Knox | Ohio | 39083 | 3 | 0 |
19271 | 19271 | 2020-03-29 | Knox | Tennessee | 47093 | 38 | 0 |
20138 | 20138 | 2020-03-30 | Knox | Illinois | 17095 | 1 | 0 |
20202 | 20202 | 2020-03-30 | Knox | Indiana | 18083 | 2 | 0 |
20465 | 20465 | 2020-03-30 | Knox | Maine | 23013 | 4 | 0 |
20792 | 20792 | 2020-03-30 | Knox | Nebraska | 31107 | 2 | 0 |
21046 | 21046 | 2020-03-30 | Knox | Ohio | 39083 | 3 | 0 |
21326 | 21326 | 2020-03-30 | Knox | Tennessee | 47093 | 52 | 0 |
22230 | 22230 | 2020-03-31 | Knox | Illinois | 17095 | 1 | 0 |
22297 | 22297 | 2020-03-31 | Knox | Indiana | 18083 | 2 | 0 |
22574 | 22574 | 2020-03-31 | Knox | Maine | 23013 | 5 | 0 |
22916 | 22916 | 2020-03-31 | Knox | Nebraska | 31107 | 2 | 0 |
23178 | 23178 | 2020-03-31 | Knox | Ohio | 39083 | 4 | 0 |
23465 | 23465 | 2020-03-31 | Knox | Tennessee | 47093 | 66 | 1 |
24398 | 24398 | 2020-04-01 | Knox | Illinois | 17095 | 1 | 0 |
24468 | 24468 | 2020-04-01 | Knox | Indiana | 18083 | 3 | 0 |
24751 | 24751 | 2020-04-01 | Knox | Maine | 23013 | 5 | 0 |
25106 | 25106 | 2020-04-01 | Knox | Nebraska | 31107 | 2 | 0 |
25373 | 25373 | 2020-04-01 | Knox | Ohio | 39083 | 4 | 0 |
25666 | 25666 | 2020-04-01 | Knox | Tennessee | 47093 | 78 | 1 |
26631 | 26631 | 2020-04-02 | Knox | Illinois | 17095 | 1 | 0 |
26707 | 26707 | 2020-04-02 | Knox | Indiana | 18083 | 4 | 0 |
27002 | 27002 | 2020-04-02 | Knox | Maine | 23013 | 7 | 0 |
27365 | 27365 | 2020-04-02 | Knox | Nebraska | 31107 | 2 | 0 |
27641 | 27641 | 2020-04-02 | Knox | Ohio | 39083 | 5 | 1 |
27945 | 27945 | 2020-04-02 | Knox | Tennessee | 47093 | 92 | 1 |
28941 | 28941 | 2020-04-03 | Knox | Illinois | 17095 | 1 | 0 |
29017 | 29017 | 2020-04-03 | Knox | Indiana | 18083 | 4 | 0 |
29320 | 29320 | 2020-04-03 | Knox | Maine | 23013 | 9 | 0 |
29688 | 29688 | 2020-04-03 | Knox | Nebraska | 31107 | 2 | 0 |
29970 | 29970 | 2020-04-03 | Knox | Ohio | 39083 | 6 | 1 |
30280 | 30280 | 2020-04-03 | Knox | Tennessee | 47093 | 98 | 1 |
31304 | 31304 | 2020-04-04 | Knox | Illinois | 17095 | 1 | 0 |
31383 | 31383 | 2020-04-04 | Knox | Indiana | 18083 | 5 | 0 |
31698 | 31698 | 2020-04-04 | Knox | Maine | 23013 | 9 | 0 |
32071 | 32071 | 2020-04-04 | Knox | Nebraska | 31107 | 2 | 0 |
32359 | 32359 | 2020-04-04 | Knox | Ohio | 39083 | 6 | 1 |
32671 | 32671 | 2020-04-04 | Knox | Tennessee | 47093 | 99 | 1 |
33714 | 33714 | 2020-04-05 | Knox | Illinois | 17095 | 1 | 0 |
33794 | 33794 | 2020-04-05 | Knox | Indiana | 18083 | 7 | 0 |
34123 | 34123 | 2020-04-05 | Knox | Maine | 23013 | 9 | 0 |
34500 | 34500 | 2020-04-05 | Knox | Nebraska | 31107 | 2 | 0 |
34792 | 34792 | 2020-04-05 | Knox | Ohio | 39083 | 7 | 1 |
35108 | 35108 | 2020-04-05 | Knox | Tennessee | 47093 | 115 | 1 |
36166 | 36166 | 2020-04-06 | Knox | Illinois | 17095 | 1 | 0 |
36247 | 36247 | 2020-04-06 | Knox | Indiana | 18083 | 8 | 0 |
36582 | 36582 | 2020-04-06 | Knox | Maine | 23013 | 9 | 0 |
36969 | 36969 | 2020-04-06 | Knox | Nebraska | 31107 | 2 | 0 |
37261 | 37261 | 2020-04-06 | Knox | Ohio | 39083 | 7 | 1 |
37584 | 37584 | 2020-04-06 | Knox | Tennessee | 47093 | 119 | 3 |
38661 | 38661 | 2020-04-07 | Knox | Illinois | 17095 | 1 | 0 |
38745 | 38745 | 2020-04-07 | Knox | Indiana | 18083 | 9 | 0 |
39090 | 39090 | 2020-04-07 | Knox | Maine | 23013 | 9 | 0 |
39485 | 39485 | 2020-04-07 | Knox | Nebraska | 31107 | 2 | 0 |
39778 | 39778 | 2020-04-07 | Knox | Ohio | 39083 | 7 | 1 |
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);