ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,927 rows where county = "York" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-30 5
- 2020-03-31 5
- 2020-04-01 5
- 2020-04-02 5
- 2020-04-03 5
- 2020-04-04 5
- 2020-04-05 5
- 2020-04-06 5
- 2020-04-07 5
- 2020-04-08 5
- 2020-04-09 5
- 2020-04-10 5
- 2020-04-11 5
- 2020-04-12 5
- 2020-04-13 5
- 2020-04-14 5
- 2020-04-15 5
- 2020-04-16 5
- 2020-04-17 5
- 2020-04-18 5
- 2020-04-19 5
- 2020-04-20 5
- 2020-04-21 5
- 2020-04-22 5
- 2020-04-23 5
- 2020-04-24 5
- 2020-04-25 5
- 2020-04-26 5
- 2020-04-27 5
- 2020-04-28 5
- …
state 5
- Virginia 789
- Maine 788
- South Carolina 788
- Pennsylvania 787
- Nebraska 775
county 1
- York · 3,927 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3181 | 3181 | 2020-03-16 | York | Virginia | 51199 | 1 | 0 |
3431 | 3431 | 2020-03-17 | York | Maine | 23031 | 1 | 0 |
3652 | 3652 | 2020-03-17 | York | South Carolina | 45091 | 1 | 0 |
3721 | 3721 | 2020-03-17 | York | Virginia | 51199 | 1 | 0 |
4013 | 4013 | 2020-03-18 | York | Maine | 23031 | 1 | 0 |
4272 | 4272 | 2020-03-18 | York | South Carolina | 45091 | 1 | 0 |
4355 | 4355 | 2020-03-18 | York | Virginia | 51199 | 1 | 0 |
5017 | 5017 | 2020-03-19 | York | South Carolina | 45091 | 1 | 0 |
5111 | 5111 | 2020-03-19 | York | Virginia | 51199 | 1 | 0 |
5898 | 5898 | 2020-03-20 | York | South Carolina | 45091 | 1 | 0 |
20803 | 20803 | 2020-03-30 | York | Nebraska | 31185 | 1 | 0 |
22926 | 22926 | 2020-03-31 | York | Nebraska | 31185 | 1 | 0 |
25117 | 25117 | 2020-04-01 | York | Nebraska | 31185 | 1 | 0 |
27377 | 27377 | 2020-04-02 | York | Nebraska | 31185 | 1 | 0 |
29700 | 29700 | 2020-04-03 | York | Nebraska | 31185 | 1 | 0 |
32083 | 32083 | 2020-04-04 | York | Nebraska | 31185 | 1 | 0 |
34514 | 34514 | 2020-04-05 | York | Nebraska | 31185 | 1 | 0 |
36984 | 36984 | 2020-04-06 | York | Nebraska | 31185 | 1 | 0 |
4256 | 4256 | 2020-03-18 | York | Pennsylvania | 42133 | 2 | 0 |
4998 | 4998 | 2020-03-19 | York | Pennsylvania | 42133 | 2 | 0 |
6908 | 6908 | 2020-03-21 | York | South Carolina | 45091 | 2 | 0 |
39500 | 39500 | 2020-04-07 | York | Nebraska | 31185 | 2 | 0 |
42056 | 42056 | 2020-04-08 | York | Nebraska | 31185 | 2 | 0 |
44638 | 44638 | 2020-04-09 | York | Nebraska | 31185 | 2 | 0 |
4715 | 4715 | 2020-03-19 | York | Maine | 23031 | 3 | 0 |
6012 | 6012 | 2020-03-20 | York | Virginia | 51199 | 3 | 0 |
7043 | 7043 | 2020-03-21 | York | Virginia | 51199 | 3 | 0 |
47251 | 47251 | 2020-04-10 | York | Nebraska | 31185 | 3 | 0 |
49903 | 49903 | 2020-04-11 | York | Nebraska | 31185 | 3 | 0 |
8029 | 8029 | 2020-03-22 | York | South Carolina | 45091 | 4 | 0 |
52577 | 52577 | 2020-04-12 | York | Nebraska | 31185 | 4 | 0 |
55259 | 55259 | 2020-04-13 | York | Nebraska | 31185 | 4 | 0 |
5533 | 5533 | 2020-03-20 | York | Maine | 23031 | 5 | 0 |
8180 | 8180 | 2020-03-22 | York | Virginia | 51199 | 5 | 0 |
9403 | 9403 | 2020-03-23 | York | Virginia | 51199 | 5 | 0 |
57958 | 57958 | 2020-04-14 | York | Nebraska | 31185 | 5 | 0 |
60673 | 60673 | 2020-04-15 | York | Nebraska | 31185 | 5 | 0 |
5871 | 5871 | 2020-03-20 | York | Pennsylvania | 42133 | 6 | 0 |
10752 | 10752 | 2020-03-24 | York | Virginia | 51199 | 6 | 0 |
63398 | 63398 | 2020-04-16 | York | Nebraska | 31185 | 6 | 0 |
66140 | 66140 | 2020-04-17 | York | Nebraska | 31185 | 6 | 0 |
9243 | 9243 | 2020-03-23 | York | South Carolina | 45091 | 7 | 0 |
68895 | 68895 | 2020-04-18 | York | Nebraska | 31185 | 7 | 0 |
71663 | 71663 | 2020-04-19 | York | Nebraska | 31185 | 7 | 0 |
74437 | 74437 | 2020-04-20 | York | Nebraska | 31185 | 7 | 0 |
77217 | 77217 | 2020-04-21 | York | Nebraska | 31185 | 7 | 0 |
80006 | 80006 | 2020-04-22 | York | Nebraska | 31185 | 7 | 0 |
6489 | 6489 | 2020-03-21 | York | Maine | 23031 | 8 | 0 |
7564 | 7564 | 2020-03-22 | York | Maine | 23031 | 8 | 0 |
12274 | 12274 | 2020-03-25 | York | Virginia | 51199 | 8 | 0 |
82804 | 82804 | 2020-04-23 | York | Nebraska | 31185 | 8 | 0 |
6875 | 6875 | 2020-03-21 | York | Pennsylvania | 42133 | 9 | 0 |
13924 | 13924 | 2020-03-26 | York | Virginia | 51199 | 9 | 0 |
15692 | 15692 | 2020-03-27 | York | Virginia | 51199 | 9 | 0 |
17572 | 17572 | 2020-03-28 | York | Virginia | 51199 | 9 | 0 |
19537 | 19537 | 2020-03-29 | York | Virginia | 51199 | 9 | 0 |
85608 | 85608 | 2020-04-24 | York | Nebraska | 31185 | 9 | 0 |
88419 | 88419 | 2020-04-25 | York | Nebraska | 31185 | 9 | 0 |
7995 | 7995 | 2020-03-22 | York | Pennsylvania | 42133 | 10 | 0 |
9206 | 9206 | 2020-03-23 | York | Pennsylvania | 42133 | 10 | 0 |
10569 | 10569 | 2020-03-24 | York | South Carolina | 45091 | 11 | 0 |
21604 | 21604 | 2020-03-30 | York | Virginia | 51199 | 11 | 0 |
91235 | 91235 | 2020-04-26 | York | Nebraska | 31185 | 11 | 0 |
94058 | 94058 | 2020-04-27 | York | Nebraska | 31185 | 11 | 0 |
96894 | 96894 | 2020-04-28 | York | Nebraska | 31185 | 11 | 0 |
99741 | 99741 | 2020-04-29 | York | Nebraska | 31185 | 11 | 0 |
8734 | 8734 | 2020-03-23 | York | Maine | 23031 | 12 | 0 |
102594 | 102594 | 2020-04-30 | York | Nebraska | 31185 | 12 | 0 |
105456 | 105456 | 2020-05-01 | York | Nebraska | 31185 | 12 | 0 |
108322 | 108322 | 2020-05-02 | York | Nebraska | 31185 | 12 | 0 |
111195 | 111195 | 2020-05-03 | York | Nebraska | 31185 | 12 | 0 |
114076 | 114076 | 2020-05-04 | York | Nebraska | 31185 | 13 | 0 |
23753 | 23753 | 2020-03-31 | York | Virginia | 51199 | 14 | 0 |
116957 | 116957 | 2020-05-05 | York | Nebraska | 31185 | 15 | 0 |
119918 | 119918 | 2020-05-06 | York | Nebraska | 31185 | 15 | 0 |
122893 | 122893 | 2020-05-07 | York | Nebraska | 31185 | 15 | 0 |
125875 | 125875 | 2020-05-08 | York | Nebraska | 31185 | 15 | 0 |
10023 | 10023 | 2020-03-24 | York | Maine | 23031 | 16 | 0 |
25971 | 25971 | 2020-04-01 | York | Virginia | 51199 | 16 | 0 |
28261 | 28261 | 2020-04-02 | York | Virginia | 51199 | 17 | 0 |
30613 | 30613 | 2020-04-03 | York | Virginia | 51199 | 17 | 0 |
128864 | 128864 | 2020-05-09 | York | Nebraska | 31185 | 17 | 0 |
131854 | 131854 | 2020-05-10 | York | Nebraska | 31185 | 17 | 0 |
10531 | 10531 | 2020-03-24 | York | Pennsylvania | 42133 | 18 | 0 |
12043 | 12043 | 2020-03-25 | York | South Carolina | 45091 | 18 | 0 |
13665 | 13665 | 2020-03-26 | York | South Carolina | 45091 | 19 | 0 |
15412 | 15412 | 2020-03-27 | York | South Carolina | 45091 | 19 | 0 |
33013 | 33013 | 2020-04-04 | York | Virginia | 51199 | 19 | 0 |
11997 | 11997 | 2020-03-25 | York | Pennsylvania | 42133 | 20 | 0 |
35451 | 35451 | 2020-04-05 | York | Virginia | 51199 | 20 | 0 |
13619 | 13619 | 2020-03-26 | York | Pennsylvania | 42133 | 21 | 0 |
37935 | 37935 | 2020-04-06 | York | Virginia | 51199 | 21 | 0 |
11433 | 11433 | 2020-03-25 | York | Maine | 23031 | 23 | 0 |
40470 | 40470 | 2020-04-07 | York | Virginia | 51199 | 25 | 1 |
43039 | 43039 | 2020-04-08 | York | Virginia | 51199 | 25 | 1 |
45635 | 45635 | 2020-04-09 | York | Virginia | 51199 | 25 | 1 |
48262 | 48262 | 2020-04-10 | York | Virginia | 51199 | 25 | 1 |
134844 | 134844 | 2020-05-11 | York | Nebraska | 31185 | 25 | 0 |
137834 | 137834 | 2020-05-12 | York | Nebraska | 31185 | 25 | 0 |
140830 | 140830 | 2020-05-13 | York | Nebraska | 31185 | 25 | 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);