ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,478 rows where county = "Scott" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-07-03 11
- 2020-07-04 11
- 2020-07-05 11
- 2020-07-06 11
- 2020-07-07 11
- 2020-07-08 11
- 2020-07-09 11
- 2020-07-10 11
- 2020-07-11 11
- 2020-07-12 11
- 2020-07-13 11
- 2020-07-14 11
- 2020-07-15 11
- 2020-07-16 11
- 2020-07-17 11
- 2020-07-18 11
- 2020-07-19 11
- 2020-07-20 11
- 2020-07-21 11
- 2020-07-22 11
- 2020-07-23 11
- 2020-07-24 11
- 2020-07-25 11
- 2020-07-26 11
- 2020-07-27 11
- 2020-07-28 11
- 2020-07-29 11
- 2020-07-30 11
- 2020-07-31 11
- 2020-08-01 11
- …
state 11
fips 11
county 1
- Scott · 8,478 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4680 | 4680 | 2020-03-19 | Scott | Kentucky | 21209 | 1 | 0 |
4775 | 4775 | 2020-03-19 | Scott | Minnesota | 27139 | 1 | 0 |
4796 | 4796 | 2020-03-19 | Scott | Mississippi | 28123 | 1 | 0 |
5494 | 5494 | 2020-03-20 | Scott | Kentucky | 21209 | 1 | 0 |
5597 | 5597 | 2020-03-20 | Scott | Minnesota | 27139 | 2 | 0 |
5627 | 5627 | 2020-03-20 | Scott | Mississippi | 28123 | 1 | 0 |
5644 | 5644 | 2020-03-20 | Scott | Missouri | 29201 | 1 | 0 |
6441 | 6441 | 2020-03-21 | Scott | Kentucky | 21209 | 1 | 0 |
6567 | 6567 | 2020-03-21 | Scott | Minnesota | 27139 | 2 | 0 |
6610 | 6610 | 2020-03-21 | Scott | Mississippi | 28123 | 1 | 0 |
6634 | 6634 | 2020-03-21 | Scott | Missouri | 29201 | 1 | 0 |
6939 | 6939 | 2020-03-21 | Scott | Tennessee | 47151 | 2 | 0 |
7444 | 7444 | 2020-03-22 | Scott | Indiana | 18143 | 1 | 1 |
7471 | 7471 | 2020-03-22 | Scott | Iowa | 19163 | 1 | 0 |
7515 | 7515 | 2020-03-22 | Scott | Kentucky | 21209 | 1 | 0 |
7649 | 7649 | 2020-03-22 | Scott | Minnesota | 27139 | 3 | 0 |
7696 | 7696 | 2020-03-22 | Scott | Mississippi | 28123 | 1 | 0 |
7723 | 7723 | 2020-03-22 | Scott | Missouri | 29201 | 1 | 0 |
8069 | 8069 | 2020-03-22 | Scott | Tennessee | 47151 | 2 | 0 |
8602 | 8602 | 2020-03-23 | Scott | Indiana | 18143 | 1 | 1 |
8630 | 8630 | 2020-03-23 | Scott | Iowa | 19163 | 1 | 0 |
8678 | 8678 | 2020-03-23 | Scott | Kentucky | 21209 | 1 | 0 |
8828 | 8828 | 2020-03-23 | Scott | Minnesota | 27139 | 5 | 0 |
8878 | 8878 | 2020-03-23 | Scott | Mississippi | 28123 | 1 | 0 |
8914 | 8914 | 2020-03-23 | Scott | Missouri | 29201 | 1 | 0 |
9287 | 9287 | 2020-03-23 | Scott | Tennessee | 47151 | 2 | 0 |
9875 | 9875 | 2020-03-24 | Scott | Indiana | 18143 | 1 | 1 |
9909 | 9909 | 2020-03-24 | Scott | Iowa | 19163 | 1 | 0 |
9965 | 9965 | 2020-03-24 | Scott | Kentucky | 21209 | 1 | 0 |
10123 | 10123 | 2020-03-24 | Scott | Minnesota | 27139 | 5 | 0 |
10176 | 10176 | 2020-03-24 | Scott | Mississippi | 28123 | 2 | 0 |
10216 | 10216 | 2020-03-24 | Scott | Missouri | 29201 | 1 | 0 |
10621 | 10621 | 2020-03-24 | Scott | Tennessee | 47151 | 2 | 0 |
11271 | 11271 | 2020-03-25 | Scott | Indiana | 18143 | 1 | 1 |
11306 | 11306 | 2020-03-25 | Scott | Iowa | 19163 | 3 | 0 |
11368 | 11368 | 2020-03-25 | Scott | Kentucky | 21209 | 1 | 0 |
11541 | 11541 | 2020-03-25 | Scott | Minnesota | 27139 | 6 | 0 |
11597 | 11597 | 2020-03-25 | Scott | Mississippi | 28123 | 3 | 0 |
11644 | 11644 | 2020-03-25 | Scott | Missouri | 29201 | 1 | 0 |
12100 | 12100 | 2020-03-25 | Scott | Tennessee | 47151 | 2 | 0 |
12831 | 12831 | 2020-03-26 | Scott | Indiana | 18143 | 1 | 1 |
12873 | 12873 | 2020-03-26 | Scott | Iowa | 19163 | 7 | 0 |
12941 | 12941 | 2020-03-26 | Scott | Kentucky | 21209 | 1 | 0 |
13130 | 13130 | 2020-03-26 | Scott | Minnesota | 27139 | 6 | 0 |
13191 | 13191 | 2020-03-26 | Scott | Mississippi | 28123 | 4 | 0 |
13242 | 13242 | 2020-03-26 | Scott | Missouri | 29201 | 1 | 0 |
13726 | 13726 | 2020-03-26 | Scott | Tennessee | 47151 | 2 | 0 |
14517 | 14517 | 2020-03-27 | Scott | Indiana | 18143 | 1 | 1 |
14567 | 14567 | 2020-03-27 | Scott | Iowa | 19163 | 7 | 0 |
14647 | 14647 | 2020-03-27 | Scott | Kentucky | 21209 | 3 | 0 |
14846 | 14846 | 2020-03-27 | Scott | Minnesota | 27139 | 7 | 0 |
14910 | 14910 | 2020-03-27 | Scott | Mississippi | 28123 | 6 | 0 |
14970 | 14970 | 2020-03-27 | Scott | Missouri | 29201 | 1 | 0 |
15478 | 15478 | 2020-03-27 | Scott | Tennessee | 47151 | 2 | 0 |
16316 | 16316 | 2020-03-28 | Scott | Indiana | 18143 | 1 | 1 |
16372 | 16372 | 2020-03-28 | Scott | Iowa | 19163 | 10 | 0 |
16463 | 16463 | 2020-03-28 | Scott | Kentucky | 21209 | 5 | 0 |
16668 | 16668 | 2020-03-28 | Scott | Minnesota | 27139 | 8 | 0 |
16734 | 16734 | 2020-03-28 | Scott | Mississippi | 28123 | 7 | 0 |
16795 | 16795 | 2020-03-28 | Scott | Missouri | 29201 | 3 | 0 |
17342 | 17342 | 2020-03-28 | Scott | Tennessee | 47151 | 2 | 0 |
18220 | 18220 | 2020-03-29 | Scott | Indiana | 18143 | 1 | 1 |
18277 | 18277 | 2020-03-29 | Scott | Iowa | 19163 | 10 | 0 |
18374 | 18374 | 2020-03-29 | Scott | Kentucky | 21209 | 6 | 0 |
18588 | 18588 | 2020-03-29 | Scott | Minnesota | 27139 | 9 | 0 |
18656 | 18656 | 2020-03-29 | Scott | Mississippi | 28123 | 7 | 0 |
18717 | 18717 | 2020-03-29 | Scott | Missouri | 29201 | 3 | 0 |
19292 | 19292 | 2020-03-29 | Scott | Tennessee | 47151 | 2 | 0 |
20226 | 20226 | 2020-03-30 | Scott | Indiana | 18143 | 1 | 1 |
20288 | 20288 | 2020-03-30 | Scott | Iowa | 19163 | 16 | 0 |
20390 | 20390 | 2020-03-30 | Scott | Kentucky | 21209 | 6 | 0 |
20610 | 20610 | 2020-03-30 | Scott | Minnesota | 27139 | 10 | 0 |
20680 | 20680 | 2020-03-30 | Scott | Mississippi | 28123 | 9 | 0 |
20750 | 20750 | 2020-03-30 | Scott | Missouri | 29201 | 5 | 0 |
21349 | 21349 | 2020-03-30 | Scott | Tennessee | 47151 | 2 | 0 |
21851 | 21851 | 2020-03-31 | Scott | Arkansas | 5127 | 1 | 0 |
22321 | 22321 | 2020-03-31 | Scott | Indiana | 18143 | 1 | 1 |
22384 | 22384 | 2020-03-31 | Scott | Iowa | 19163 | 18 | 0 |
22498 | 22498 | 2020-03-31 | Scott | Kentucky | 21209 | 7 | 0 |
22725 | 22725 | 2020-03-31 | Scott | Minnesota | 27139 | 10 | 0 |
22797 | 22797 | 2020-03-31 | Scott | Mississippi | 28123 | 10 | 0 |
22869 | 22869 | 2020-03-31 | Scott | Missouri | 29201 | 6 | 0 |
23488 | 23488 | 2020-03-31 | Scott | Tennessee | 47151 | 2 | 0 |
24009 | 24009 | 2020-04-01 | Scott | Arkansas | 5127 | 1 | 0 |
24492 | 24492 | 2020-04-01 | Scott | Indiana | 18143 | 1 | 1 |
24558 | 24558 | 2020-04-01 | Scott | Iowa | 19163 | 21 | 0 |
24674 | 24674 | 2020-04-01 | Scott | Kentucky | 21209 | 7 | 0 |
24907 | 24907 | 2020-04-01 | Scott | Minnesota | 27139 | 10 | 0 |
24981 | 24981 | 2020-04-01 | Scott | Mississippi | 28123 | 12 | 0 |
25057 | 25057 | 2020-04-01 | Scott | Missouri | 29201 | 6 | 0 |
25690 | 25690 | 2020-04-01 | Scott | Tennessee | 47151 | 3 | 0 |
26236 | 26236 | 2020-04-02 | Scott | Arkansas | 5127 | 1 | 0 |
26731 | 26731 | 2020-04-02 | Scott | Indiana | 18143 | 5 | 1 |
26801 | 26801 | 2020-04-02 | Scott | Iowa | 19163 | 25 | 0 |
26924 | 26924 | 2020-04-02 | Scott | Kentucky | 21209 | 8 | 0 |
27161 | 27161 | 2020-04-02 | Scott | Minnesota | 27139 | 10 | 0 |
27235 | 27235 | 2020-04-02 | Scott | Mississippi | 28123 | 13 | 0 |
27314 | 27314 | 2020-04-02 | Scott | Missouri | 29201 | 6 | 0 |
27970 | 27970 | 2020-04-02 | Scott | Tennessee | 47151 | 3 | 0 |
28535 | 28535 | 2020-04-03 | Scott | Arkansas | 5127 | 1 | 0 |
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);