ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Wayne" and state = "Pennsylvania" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- …
state 1
- Pennsylvania · 799 ✖
fips 1
- 42127 799
county 1
- Wayne · 799 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636 | 636 | 2020-03-06 | Wayne | Pennsylvania | 42127 | 1 | 0 |
728 | 728 | 2020-03-07 | Wayne | Pennsylvania | 42127 | 1 | 0 |
837 | 837 | 2020-03-08 | Wayne | Pennsylvania | 42127 | 1 | 0 |
966 | 966 | 2020-03-09 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1119 | 1119 | 2020-03-10 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1313 | 1313 | 2020-03-11 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1559 | 1559 | 2020-03-12 | Wayne | Pennsylvania | 42127 | 1 | 0 |
1858 | 1858 | 2020-03-13 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2220 | 2220 | 2020-03-14 | Wayne | Pennsylvania | 42127 | 1 | 0 |
2642 | 2642 | 2020-03-15 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3107 | 3107 | 2020-03-16 | Wayne | Pennsylvania | 42127 | 1 | 0 |
3637 | 3637 | 2020-03-17 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4255 | 4255 | 2020-03-18 | Wayne | Pennsylvania | 42127 | 1 | 0 |
4996 | 4996 | 2020-03-19 | Wayne | Pennsylvania | 42127 | 1 | 0 |
5869 | 5869 | 2020-03-20 | Wayne | Pennsylvania | 42127 | 1 | 0 |
6873 | 6873 | 2020-03-21 | Wayne | Pennsylvania | 42127 | 1 | 0 |
7993 | 7993 | 2020-03-22 | Wayne | Pennsylvania | 42127 | 2 | 0 |
9204 | 9204 | 2020-03-23 | Wayne | Pennsylvania | 42127 | 3 | 0 |
10529 | 10529 | 2020-03-24 | Wayne | Pennsylvania | 42127 | 4 | 0 |
11995 | 11995 | 2020-03-25 | Wayne | Pennsylvania | 42127 | 4 | 0 |
13617 | 13617 | 2020-03-26 | Wayne | Pennsylvania | 42127 | 6 | 0 |
15364 | 15364 | 2020-03-27 | Wayne | Pennsylvania | 42127 | 6 | 0 |
17218 | 17218 | 2020-03-28 | Wayne | Pennsylvania | 42127 | 6 | 0 |
19158 | 19158 | 2020-03-29 | Wayne | Pennsylvania | 42127 | 7 | 0 |
21209 | 21209 | 2020-03-30 | Wayne | Pennsylvania | 42127 | 10 | 0 |
23346 | 23346 | 2020-03-31 | Wayne | Pennsylvania | 42127 | 10 | 0 |
25543 | 25543 | 2020-04-01 | Wayne | Pennsylvania | 42127 | 14 | 0 |
27816 | 27816 | 2020-04-02 | Wayne | Pennsylvania | 42127 | 17 | 0 |
30151 | 30151 | 2020-04-03 | Wayne | Pennsylvania | 42127 | 23 | 0 |
32541 | 32541 | 2020-04-04 | Wayne | Pennsylvania | 42127 | 28 | 0 |
34977 | 34977 | 2020-04-05 | Wayne | Pennsylvania | 42127 | 33 | 0 |
37452 | 37452 | 2020-04-06 | Wayne | Pennsylvania | 42127 | 35 | 0 |
39975 | 39975 | 2020-04-07 | Wayne | Pennsylvania | 42127 | 40 | 0 |
42535 | 42535 | 2020-04-08 | Wayne | Pennsylvania | 42127 | 47 | 0 |
45121 | 45121 | 2020-04-09 | Wayne | Pennsylvania | 42127 | 49 | 0 |
47738 | 47738 | 2020-04-10 | Wayne | Pennsylvania | 42127 | 53 | 0 |
50395 | 50395 | 2020-04-11 | Wayne | Pennsylvania | 42127 | 57 | 1 |
53068 | 53068 | 2020-04-12 | Wayne | Pennsylvania | 42127 | 63 | 1 |
55753 | 55753 | 2020-04-13 | Wayne | Pennsylvania | 42127 | 67 | 1 |
58456 | 58456 | 2020-04-14 | Wayne | Pennsylvania | 42127 | 70 | 1 |
61171 | 61171 | 2020-04-15 | Wayne | Pennsylvania | 42127 | 75 | 2 |
63897 | 63897 | 2020-04-16 | Wayne | Pennsylvania | 42127 | 77 | 2 |
66643 | 66643 | 2020-04-17 | Wayne | Pennsylvania | 42127 | 81 | 2 |
69401 | 69401 | 2020-04-18 | Wayne | Pennsylvania | 42127 | 84 | 2 |
72168 | 72168 | 2020-04-19 | Wayne | Pennsylvania | 42127 | 84 | 3 |
74943 | 74943 | 2020-04-20 | Wayne | Pennsylvania | 42127 | 85 | 3 |
77725 | 77725 | 2020-04-21 | Wayne | Pennsylvania | 42127 | 86 | 3 |
80515 | 80515 | 2020-04-22 | Wayne | Pennsylvania | 42127 | 86 | 3 |
83314 | 83314 | 2020-04-23 | Wayne | Pennsylvania | 42127 | 87 | 3 |
86118 | 86118 | 2020-04-24 | Wayne | Pennsylvania | 42127 | 88 | 3 |
88932 | 88932 | 2020-04-25 | Wayne | Pennsylvania | 42127 | 92 | 3 |
91748 | 91748 | 2020-04-26 | Wayne | Pennsylvania | 42127 | 92 | 3 |
94575 | 94575 | 2020-04-27 | Wayne | Pennsylvania | 42127 | 93 | 3 |
97414 | 97414 | 2020-04-28 | Wayne | Pennsylvania | 42127 | 93 | 3 |
100263 | 100263 | 2020-04-29 | Wayne | Pennsylvania | 42127 | 95 | 5 |
103116 | 103116 | 2020-04-30 | Wayne | Pennsylvania | 42127 | 100 | 5 |
105979 | 105979 | 2020-05-01 | Wayne | Pennsylvania | 42127 | 102 | 5 |
108846 | 108846 | 2020-05-02 | Wayne | Pennsylvania | 42127 | 104 | 5 |
111720 | 111720 | 2020-05-03 | Wayne | Pennsylvania | 42127 | 109 | 5 |
114602 | 114602 | 2020-05-04 | Wayne | Pennsylvania | 42127 | 109 | 5 |
117483 | 117483 | 2020-05-05 | Wayne | Pennsylvania | 42127 | 109 | 5 |
120445 | 120445 | 2020-05-06 | Wayne | Pennsylvania | 42127 | 110 | 5 |
123422 | 123422 | 2020-05-07 | Wayne | Pennsylvania | 42127 | 113 | 5 |
126405 | 126405 | 2020-05-08 | Wayne | Pennsylvania | 42127 | 113 | 5 |
129394 | 129394 | 2020-05-09 | Wayne | Pennsylvania | 42127 | 116 | 5 |
132383 | 132383 | 2020-05-10 | Wayne | Pennsylvania | 42127 | 117 | 5 |
135374 | 135374 | 2020-05-11 | Wayne | Pennsylvania | 42127 | 117 | 5 |
138364 | 138364 | 2020-05-12 | Wayne | Pennsylvania | 42127 | 117 | 5 |
141360 | 141360 | 2020-05-13 | Wayne | Pennsylvania | 42127 | 107 | 5 |
144356 | 144356 | 2020-05-14 | Wayne | Pennsylvania | 42127 | 107 | 5 |
147357 | 147357 | 2020-05-15 | Wayne | Pennsylvania | 42127 | 107 | 7 |
150364 | 150364 | 2020-05-16 | Wayne | Pennsylvania | 42127 | 108 | 7 |
153375 | 153375 | 2020-05-17 | Wayne | Pennsylvania | 42127 | 108 | 7 |
156392 | 156392 | 2020-05-18 | Wayne | Pennsylvania | 42127 | 108 | 7 |
159413 | 159413 | 2020-05-19 | Wayne | Pennsylvania | 42127 | 110 | 7 |
162440 | 162440 | 2020-05-20 | Wayne | Pennsylvania | 42127 | 110 | 7 |
165469 | 165469 | 2020-05-21 | Wayne | Pennsylvania | 42127 | 112 | 7 |
168505 | 168505 | 2020-05-22 | Wayne | Pennsylvania | 42127 | 115 | 6 |
171544 | 171544 | 2020-05-23 | Wayne | Pennsylvania | 42127 | 117 | 7 |
174586 | 174586 | 2020-05-24 | Wayne | Pennsylvania | 42127 | 117 | 7 |
177630 | 177630 | 2020-05-25 | Wayne | Pennsylvania | 42127 | 118 | 7 |
180673 | 180673 | 2020-05-26 | Wayne | Pennsylvania | 42127 | 118 | 7 |
183723 | 183723 | 2020-05-27 | Wayne | Pennsylvania | 42127 | 118 | 7 |
186780 | 186780 | 2020-05-28 | Wayne | Pennsylvania | 42127 | 118 | 7 |
189841 | 189841 | 2020-05-29 | Wayne | Pennsylvania | 42127 | 119 | 7 |
192906 | 192906 | 2020-05-30 | Wayne | Pennsylvania | 42127 | 119 | 8 |
195975 | 195975 | 2020-05-31 | Wayne | Pennsylvania | 42127 | 119 | 8 |
199048 | 199048 | 2020-06-01 | Wayne | Pennsylvania | 42127 | 120 | 8 |
202123 | 202123 | 2020-06-02 | Wayne | Pennsylvania | 42127 | 120 | 8 |
205200 | 205200 | 2020-06-03 | Wayne | Pennsylvania | 42127 | 120 | 8 |
208281 | 208281 | 2020-06-04 | Wayne | Pennsylvania | 42127 | 121 | 8 |
211363 | 211363 | 2020-06-05 | Wayne | Pennsylvania | 42127 | 123 | 9 |
214449 | 214449 | 2020-06-06 | Wayne | Pennsylvania | 42127 | 123 | 9 |
217539 | 217539 | 2020-06-07 | Wayne | Pennsylvania | 42127 | 126 | 9 |
220631 | 220631 | 2020-06-08 | Wayne | Pennsylvania | 42127 | 124 | 9 |
223726 | 223726 | 2020-06-09 | Wayne | Pennsylvania | 42127 | 124 | 9 |
226826 | 226826 | 2020-06-10 | Wayne | Pennsylvania | 42127 | 123 | 9 |
229930 | 229930 | 2020-06-11 | Wayne | Pennsylvania | 42127 | 125 | 9 |
233035 | 233035 | 2020-06-12 | Wayne | Pennsylvania | 42127 | 125 | 9 |
236140 | 236140 | 2020-06-13 | Wayne | Pennsylvania | 42127 | 126 | 9 |
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);