ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42001 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4238 | 4238 | 2020-03-18 | Adams | Pennsylvania | 42001 | 1 | 0 |
4977 | 4977 | 2020-03-19 | Adams | Pennsylvania | 42001 | 2 | 0 |
5846 | 5846 | 2020-03-20 | Adams | Pennsylvania | 42001 | 5 | 0 |
6848 | 6848 | 2020-03-21 | Adams | Pennsylvania | 42001 | 5 | 0 |
7963 | 7963 | 2020-03-22 | Adams | Pennsylvania | 42001 | 5 | 0 |
9173 | 9173 | 2020-03-23 | Adams | Pennsylvania | 42001 | 6 | 0 |
10492 | 10492 | 2020-03-24 | Adams | Pennsylvania | 42001 | 6 | 0 |
11954 | 11954 | 2020-03-25 | Adams | Pennsylvania | 42001 | 6 | 0 |
13572 | 13572 | 2020-03-26 | Adams | Pennsylvania | 42001 | 7 | 0 |
15318 | 15318 | 2020-03-27 | Adams | Pennsylvania | 42001 | 8 | 0 |
17165 | 17165 | 2020-03-28 | Adams | Pennsylvania | 42001 | 8 | 0 |
19103 | 19103 | 2020-03-29 | Adams | Pennsylvania | 42001 | 8 | 0 |
21153 | 21153 | 2020-03-30 | Adams | Pennsylvania | 42001 | 8 | 0 |
23288 | 23288 | 2020-03-31 | Adams | Pennsylvania | 42001 | 9 | 0 |
25486 | 25486 | 2020-04-01 | Adams | Pennsylvania | 42001 | 12 | 0 |
27758 | 27758 | 2020-04-02 | Adams | Pennsylvania | 42001 | 18 | 0 |
30091 | 30091 | 2020-04-03 | Adams | Pennsylvania | 42001 | 19 | 0 |
32481 | 32481 | 2020-04-04 | Adams | Pennsylvania | 42001 | 21 | 0 |
34916 | 34916 | 2020-04-05 | Adams | Pennsylvania | 42001 | 22 | 0 |
37391 | 37391 | 2020-04-06 | Adams | Pennsylvania | 42001 | 25 | 0 |
39912 | 39912 | 2020-04-07 | Adams | Pennsylvania | 42001 | 28 | 0 |
42472 | 42472 | 2020-04-08 | Adams | Pennsylvania | 42001 | 33 | 0 |
45058 | 45058 | 2020-04-09 | Adams | Pennsylvania | 42001 | 38 | 1 |
47675 | 47675 | 2020-04-10 | Adams | Pennsylvania | 42001 | 43 | 1 |
50332 | 50332 | 2020-04-11 | Adams | Pennsylvania | 42001 | 44 | 1 |
53005 | 53005 | 2020-04-12 | Adams | Pennsylvania | 42001 | 48 | 1 |
55690 | 55690 | 2020-04-13 | Adams | Pennsylvania | 42001 | 56 | 1 |
58393 | 58393 | 2020-04-14 | Adams | Pennsylvania | 42001 | 63 | 1 |
61108 | 61108 | 2020-04-15 | Adams | Pennsylvania | 42001 | 64 | 1 |
63834 | 63834 | 2020-04-16 | Adams | Pennsylvania | 42001 | 67 | 1 |
66580 | 66580 | 2020-04-17 | Adams | Pennsylvania | 42001 | 70 | 1 |
69338 | 69338 | 2020-04-18 | Adams | Pennsylvania | 42001 | 74 | 1 |
72105 | 72105 | 2020-04-19 | Adams | Pennsylvania | 42001 | 80 | 1 |
74880 | 74880 | 2020-04-20 | Adams | Pennsylvania | 42001 | 85 | 1 |
77662 | 77662 | 2020-04-21 | Adams | Pennsylvania | 42001 | 91 | 2 |
80452 | 80452 | 2020-04-22 | Adams | Pennsylvania | 42001 | 92 | 2 |
83251 | 83251 | 2020-04-23 | Adams | Pennsylvania | 42001 | 95 | 2 |
86055 | 86055 | 2020-04-24 | Adams | Pennsylvania | 42001 | 110 | 2 |
88869 | 88869 | 2020-04-25 | Adams | Pennsylvania | 42001 | 113 | 2 |
91685 | 91685 | 2020-04-26 | Adams | Pennsylvania | 42001 | 117 | 2 |
94512 | 94512 | 2020-04-27 | Adams | Pennsylvania | 42001 | 122 | 2 |
97351 | 97351 | 2020-04-28 | Adams | Pennsylvania | 42001 | 124 | 2 |
100200 | 100200 | 2020-04-29 | Adams | Pennsylvania | 42001 | 130 | 4 |
103053 | 103053 | 2020-04-30 | Adams | Pennsylvania | 42001 | 137 | 4 |
105916 | 105916 | 2020-05-01 | Adams | Pennsylvania | 42001 | 140 | 4 |
108783 | 108783 | 2020-05-02 | Adams | Pennsylvania | 42001 | 141 | 4 |
111657 | 111657 | 2020-05-03 | Adams | Pennsylvania | 42001 | 145 | 4 |
114539 | 114539 | 2020-05-04 | Adams | Pennsylvania | 42001 | 148 | 4 |
117420 | 117420 | 2020-05-05 | Adams | Pennsylvania | 42001 | 148 | 5 |
120382 | 120382 | 2020-05-06 | Adams | Pennsylvania | 42001 | 148 | 5 |
123359 | 123359 | 2020-05-07 | Adams | Pennsylvania | 42001 | 151 | 5 |
126342 | 126342 | 2020-05-08 | Adams | Pennsylvania | 42001 | 154 | 5 |
129331 | 129331 | 2020-05-09 | Adams | Pennsylvania | 42001 | 156 | 5 |
132320 | 132320 | 2020-05-10 | Adams | Pennsylvania | 42001 | 159 | 5 |
135311 | 135311 | 2020-05-11 | Adams | Pennsylvania | 42001 | 167 | 5 |
138301 | 138301 | 2020-05-12 | Adams | Pennsylvania | 42001 | 167 | 5 |
141297 | 141297 | 2020-05-13 | Adams | Pennsylvania | 42001 | 169 | 5 |
144293 | 144293 | 2020-05-14 | Adams | Pennsylvania | 42001 | 174 | 5 |
147294 | 147294 | 2020-05-15 | Adams | Pennsylvania | 42001 | 183 | 6 |
150301 | 150301 | 2020-05-16 | Adams | Pennsylvania | 42001 | 185 | 6 |
153312 | 153312 | 2020-05-17 | Adams | Pennsylvania | 42001 | 189 | 6 |
156329 | 156329 | 2020-05-18 | Adams | Pennsylvania | 42001 | 194 | 5 |
159350 | 159350 | 2020-05-19 | Adams | Pennsylvania | 42001 | 194 | 5 |
162377 | 162377 | 2020-05-20 | Adams | Pennsylvania | 42001 | 197 | 5 |
165406 | 165406 | 2020-05-21 | Adams | Pennsylvania | 42001 | 204 | 5 |
168442 | 168442 | 2020-05-22 | Adams | Pennsylvania | 42001 | 214 | 5 |
171481 | 171481 | 2020-05-23 | Adams | Pennsylvania | 42001 | 222 | 6 |
174523 | 174523 | 2020-05-24 | Adams | Pennsylvania | 42001 | 226 | 7 |
177567 | 177567 | 2020-05-25 | Adams | Pennsylvania | 42001 | 227 | 7 |
180610 | 180610 | 2020-05-26 | Adams | Pennsylvania | 42001 | 233 | 7 |
183660 | 183660 | 2020-05-27 | Adams | Pennsylvania | 42001 | 236 | 7 |
186717 | 186717 | 2020-05-28 | Adams | Pennsylvania | 42001 | 240 | 7 |
189778 | 189778 | 2020-05-29 | Adams | Pennsylvania | 42001 | 241 | 7 |
192843 | 192843 | 2020-05-30 | Adams | Pennsylvania | 42001 | 245 | 8 |
195912 | 195912 | 2020-05-31 | Adams | Pennsylvania | 42001 | 251 | 8 |
198985 | 198985 | 2020-06-01 | Adams | Pennsylvania | 42001 | 250 | 8 |
202060 | 202060 | 2020-06-02 | Adams | Pennsylvania | 42001 | 255 | 8 |
205137 | 205137 | 2020-06-03 | Adams | Pennsylvania | 42001 | 260 | 8 |
208218 | 208218 | 2020-06-04 | Adams | Pennsylvania | 42001 | 263 | 8 |
211300 | 211300 | 2020-06-05 | Adams | Pennsylvania | 42001 | 264 | 8 |
214386 | 214386 | 2020-06-06 | Adams | Pennsylvania | 42001 | 269 | 8 |
217476 | 217476 | 2020-06-07 | Adams | Pennsylvania | 42001 | 273 | 8 |
220568 | 220568 | 2020-06-08 | Adams | Pennsylvania | 42001 | 275 | 8 |
223663 | 223663 | 2020-06-09 | Adams | Pennsylvania | 42001 | 275 | 9 |
226763 | 226763 | 2020-06-10 | Adams | Pennsylvania | 42001 | 278 | 9 |
229867 | 229867 | 2020-06-11 | Adams | Pennsylvania | 42001 | 279 | 9 |
232972 | 232972 | 2020-06-12 | Adams | Pennsylvania | 42001 | 284 | 9 |
236077 | 236077 | 2020-06-13 | Adams | Pennsylvania | 42001 | 289 | 9 |
239185 | 239185 | 2020-06-14 | Adams | Pennsylvania | 42001 | 290 | 9 |
242294 | 242294 | 2020-06-15 | Adams | Pennsylvania | 42001 | 296 | 9 |
245406 | 245406 | 2020-06-16 | Adams | Pennsylvania | 42001 | 298 | 10 |
248519 | 248519 | 2020-06-17 | Adams | Pennsylvania | 42001 | 300 | 10 |
251634 | 251634 | 2020-06-18 | Adams | Pennsylvania | 42001 | 304 | 11 |
254749 | 254749 | 2020-06-19 | Adams | Pennsylvania | 42001 | 309 | 11 |
257875 | 257875 | 2020-06-20 | Adams | Pennsylvania | 42001 | 311 | 11 |
261002 | 261002 | 2020-06-21 | Adams | Pennsylvania | 42001 | 314 | 11 |
264130 | 264130 | 2020-06-22 | Adams | Pennsylvania | 42001 | 317 | 11 |
267258 | 267258 | 2020-06-23 | Adams | Pennsylvania | 42001 | 322 | 12 |
270392 | 270392 | 2020-06-24 | Adams | Pennsylvania | 42001 | 321 | 12 |
273531 | 273531 | 2020-06-25 | Adams | Pennsylvania | 42001 | 323 | 12 |
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);