ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,200 rows where county = "Boone" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 8
county 1
- Boone · 6,200 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1059 | 1059 | 2020-03-10 | Boone | Indiana | 18011 | 1 | 0 |
1234 | 1234 | 2020-03-11 | Boone | Indiana | 18011 | 1 | 0 |
1448 | 1448 | 2020-03-12 | Boone | Indiana | 18011 | 1 | 0 |
1719 | 1719 | 2020-03-13 | Boone | Indiana | 18011 | 1 | 0 |
2050 | 2050 | 2020-03-14 | Boone | Indiana | 18011 | 1 | 0 |
2443 | 2443 | 2020-03-15 | Boone | Indiana | 18011 | 1 | 0 |
2887 | 2887 | 2020-03-16 | Boone | Indiana | 18011 | 1 | 0 |
3376 | 3376 | 2020-03-17 | Boone | Indiana | 18011 | 1 | 0 |
3493 | 3493 | 2020-03-17 | Boone | Missouri | 29019 | 1 | 0 |
3946 | 3946 | 2020-03-18 | Boone | Indiana | 18011 | 1 | 0 |
4082 | 4082 | 2020-03-18 | Boone | Missouri | 29019 | 1 | 1 |
4429 | 4429 | 2020-03-19 | Boone | Arkansas | 5009 | 1 | 0 |
4622 | 4622 | 2020-03-19 | Boone | Indiana | 18011 | 1 | 0 |
4801 | 4801 | 2020-03-19 | Boone | Missouri | 29019 | 3 | 1 |
5201 | 5201 | 2020-03-20 | Boone | Arkansas | 5009 | 1 | 0 |
5429 | 5429 | 2020-03-20 | Boone | Indiana | 18011 | 2 | 0 |
5634 | 5634 | 2020-03-20 | Boone | Missouri | 29019 | 10 | 1 |
6120 | 6120 | 2020-03-21 | Boone | Arkansas | 5009 | 1 | 0 |
6364 | 6364 | 2020-03-21 | Boone | Indiana | 18011 | 2 | 0 |
6622 | 6622 | 2020-03-21 | Boone | Missouri | 29019 | 11 | 1 |
7154 | 7154 | 2020-03-22 | Boone | Arkansas | 5009 | 1 | 0 |
7418 | 7418 | 2020-03-22 | Boone | Indiana | 18011 | 3 | 0 |
7711 | 7711 | 2020-03-22 | Boone | Missouri | 29019 | 11 | 1 |
8297 | 8297 | 2020-03-23 | Boone | Arkansas | 5009 | 1 | 0 |
8575 | 8575 | 2020-03-23 | Boone | Indiana | 18011 | 3 | 0 |
8895 | 8895 | 2020-03-23 | Boone | Missouri | 29019 | 17 | 1 |
9526 | 9526 | 2020-03-24 | Boone | Arkansas | 5009 | 1 | 0 |
9839 | 9839 | 2020-03-24 | Boone | Indiana | 18011 | 3 | 0 |
10193 | 10193 | 2020-03-24 | Boone | Missouri | 29019 | 20 | 1 |
10896 | 10896 | 2020-03-25 | Boone | Arkansas | 5009 | 1 | 0 |
11232 | 11232 | 2020-03-25 | Boone | Indiana | 18011 | 4 | 0 |
11614 | 11614 | 2020-03-25 | Boone | Missouri | 29019 | 20 | 1 |
12437 | 12437 | 2020-03-26 | Boone | Arkansas | 5009 | 1 | 0 |
12788 | 12788 | 2020-03-26 | Boone | Indiana | 18011 | 7 | 0 |
12909 | 12909 | 2020-03-26 | Boone | Kentucky | 21015 | 2 | 0 |
13211 | 13211 | 2020-03-26 | Boone | Missouri | 29019 | 25 | 1 |
14101 | 14101 | 2020-03-27 | Boone | Arkansas | 5009 | 1 | 0 |
14466 | 14466 | 2020-03-27 | Boone | Indiana | 18011 | 7 | 0 |
14612 | 14612 | 2020-03-27 | Boone | Kentucky | 21015 | 3 | 0 |
14934 | 14934 | 2020-03-27 | Boone | Missouri | 29019 | 37 | 1 |
15881 | 15881 | 2020-03-28 | Boone | Arkansas | 5009 | 1 | 0 |
16263 | 16263 | 2020-03-28 | Boone | Indiana | 18011 | 8 | 0 |
16340 | 16340 | 2020-03-28 | Boone | Iowa | 19015 | 1 | 0 |
16420 | 16420 | 2020-03-28 | Boone | Kentucky | 21015 | 4 | 0 |
16758 | 16758 | 2020-03-28 | Boone | Missouri | 29019 | 49 | 1 |
17767 | 17767 | 2020-03-29 | Boone | Arkansas | 5009 | 1 | 0 |
18164 | 18164 | 2020-03-29 | Boone | Indiana | 18011 | 13 | 0 |
18245 | 18245 | 2020-03-29 | Boone | Iowa | 19015 | 1 | 0 |
18329 | 18329 | 2020-03-29 | Boone | Kentucky | 21015 | 4 | 0 |
18680 | 18680 | 2020-03-29 | Boone | Missouri | 29019 | 50 | 1 |
19741 | 19741 | 2020-03-30 | Boone | Arkansas | 5009 | 1 | 0 |
20170 | 20170 | 2020-03-30 | Boone | Indiana | 18011 | 20 | 0 |
20252 | 20252 | 2020-03-30 | Boone | Iowa | 19015 | 1 | 0 |
20343 | 20343 | 2020-03-30 | Boone | Kentucky | 21015 | 5 | 0 |
20704 | 20704 | 2020-03-30 | Boone | Missouri | 29019 | 59 | 1 |
21813 | 21813 | 2020-03-31 | Boone | Arkansas | 5009 | 2 | 0 |
22263 | 22263 | 2020-03-31 | Boone | Indiana | 18011 | 22 | 0 |
22347 | 22347 | 2020-03-31 | Boone | Iowa | 19015 | 1 | 0 |
22443 | 22443 | 2020-03-31 | Boone | Kentucky | 21015 | 5 | 0 |
22822 | 22822 | 2020-03-31 | Boone | Missouri | 29019 | 64 | 1 |
23969 | 23969 | 2020-04-01 | Boone | Arkansas | 5009 | 3 | 0 |
24433 | 24433 | 2020-04-01 | Boone | Indiana | 18011 | 29 | 0 |
24519 | 24519 | 2020-04-01 | Boone | Iowa | 19015 | 1 | 0 |
24619 | 24619 | 2020-04-01 | Boone | Kentucky | 21015 | 5 | 0 |
25006 | 25006 | 2020-04-01 | Boone | Missouri | 29019 | 65 | 1 |
26193 | 26193 | 2020-04-02 | Boone | Arkansas | 5009 | 3 | 0 |
26672 | 26672 | 2020-04-02 | Boone | Indiana | 18011 | 32 | 0 |
26759 | 26759 | 2020-04-02 | Boone | Iowa | 19015 | 2 | 0 |
26864 | 26864 | 2020-04-02 | Boone | Kentucky | 21015 | 5 | 0 |
27261 | 27261 | 2020-04-02 | Boone | Missouri | 29019 | 69 | 1 |
28490 | 28490 | 2020-04-03 | Boone | Arkansas | 5009 | 3 | 0 |
28982 | 28982 | 2020-04-03 | Boone | Indiana | 18011 | 38 | 0 |
29070 | 29070 | 2020-04-03 | Boone | Iowa | 19015 | 2 | 0 |
29180 | 29180 | 2020-04-03 | Boone | Kentucky | 21015 | 5 | 0 |
29580 | 29580 | 2020-04-03 | Boone | Missouri | 29019 | 74 | 1 |
30847 | 30847 | 2020-04-04 | Boone | Arkansas | 5009 | 3 | 0 |
31348 | 31348 | 2020-04-04 | Boone | Indiana | 18011 | 50 | 0 |
31438 | 31438 | 2020-04-04 | Boone | Iowa | 19015 | 2 | 0 |
31554 | 31554 | 2020-04-04 | Boone | Kentucky | 21015 | 6 | 1 |
31960 | 31960 | 2020-04-04 | Boone | Missouri | 29019 | 75 | 1 |
33251 | 33251 | 2020-04-05 | Boone | Arkansas | 5009 | 3 | 0 |
33684 | 33684 | 2020-04-05 | Boone | Illinois | 17007 | 3 | 0 |
33758 | 33758 | 2020-04-05 | Boone | Indiana | 18011 | 58 | 2 |
33849 | 33849 | 2020-04-05 | Boone | Iowa | 19015 | 3 | 0 |
33971 | 33971 | 2020-04-05 | Boone | Kentucky | 21015 | 27 | 1 |
34388 | 34388 | 2020-04-05 | Boone | Missouri | 29019 | 76 | 1 |
35691 | 35691 | 2020-04-06 | Boone | Arkansas | 5009 | 3 | 0 |
36135 | 36135 | 2020-04-06 | Boone | Illinois | 17007 | 4 | 0 |
36211 | 36211 | 2020-04-06 | Boone | Indiana | 18011 | 65 | 2 |
36302 | 36302 | 2020-04-06 | Boone | Iowa | 19015 | 3 | 0 |
36429 | 36429 | 2020-04-06 | Boone | Kentucky | 21015 | 27 | 1 |
36851 | 36851 | 2020-04-06 | Boone | Missouri | 29019 | 76 | 1 |
38180 | 38180 | 2020-04-07 | Boone | Arkansas | 5009 | 4 | 0 |
38629 | 38629 | 2020-04-07 | Boone | Illinois | 17007 | 6 | 0 |
38709 | 38709 | 2020-04-07 | Boone | Indiana | 18011 | 75 | 2 |
38800 | 38800 | 2020-04-07 | Boone | Iowa | 19015 | 3 | 0 |
38934 | 38934 | 2020-04-07 | Boone | Kentucky | 21015 | 34 | 1 |
39362 | 39362 | 2020-04-07 | Boone | Missouri | 29019 | 77 | 1 |
40723 | 40723 | 2020-04-08 | Boone | Arkansas | 5009 | 3 | 0 |
41173 | 41173 | 2020-04-08 | Boone | Illinois | 17007 | 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);