ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 42033 and state = "Pennsylvania" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10504 | 10504 | 2020-03-24 | Clearfield | Pennsylvania | 42033 | 1 | 0 |
11966 | 11966 | 2020-03-25 | Clearfield | Pennsylvania | 42033 | 2 | 0 |
13585 | 13585 | 2020-03-26 | Clearfield | Pennsylvania | 42033 | 2 | 0 |
15331 | 15331 | 2020-03-27 | Clearfield | Pennsylvania | 42033 | 2 | 0 |
17180 | 17180 | 2020-03-28 | Clearfield | Pennsylvania | 42033 | 2 | 0 |
19118 | 19118 | 2020-03-29 | Clearfield | Pennsylvania | 42033 | 2 | 0 |
21168 | 21168 | 2020-03-30 | Clearfield | Pennsylvania | 42033 | 4 | 0 |
23304 | 23304 | 2020-03-31 | Clearfield | Pennsylvania | 42033 | 4 | 0 |
25502 | 25502 | 2020-04-01 | Clearfield | Pennsylvania | 42033 | 4 | 0 |
27774 | 27774 | 2020-04-02 | Clearfield | Pennsylvania | 42033 | 4 | 0 |
30107 | 30107 | 2020-04-03 | Clearfield | Pennsylvania | 42033 | 5 | 0 |
32497 | 32497 | 2020-04-04 | Clearfield | Pennsylvania | 42033 | 7 | 0 |
34932 | 34932 | 2020-04-05 | Clearfield | Pennsylvania | 42033 | 7 | 0 |
37407 | 37407 | 2020-04-06 | Clearfield | Pennsylvania | 42033 | 7 | 0 |
39928 | 39928 | 2020-04-07 | Clearfield | Pennsylvania | 42033 | 7 | 0 |
42488 | 42488 | 2020-04-08 | Clearfield | Pennsylvania | 42033 | 7 | 0 |
45074 | 45074 | 2020-04-09 | Clearfield | Pennsylvania | 42033 | 7 | 0 |
47691 | 47691 | 2020-04-10 | Clearfield | Pennsylvania | 42033 | 8 | 0 |
50348 | 50348 | 2020-04-11 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
53021 | 53021 | 2020-04-12 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
55706 | 55706 | 2020-04-13 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
58409 | 58409 | 2020-04-14 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
61124 | 61124 | 2020-04-15 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
63850 | 63850 | 2020-04-16 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
66596 | 66596 | 2020-04-17 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
69354 | 69354 | 2020-04-18 | Clearfield | Pennsylvania | 42033 | 9 | 0 |
72121 | 72121 | 2020-04-19 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
74896 | 74896 | 2020-04-20 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
77678 | 77678 | 2020-04-21 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
80468 | 80468 | 2020-04-22 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
83267 | 83267 | 2020-04-23 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
86071 | 86071 | 2020-04-24 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
88885 | 88885 | 2020-04-25 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
91701 | 91701 | 2020-04-26 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
94528 | 94528 | 2020-04-27 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
97367 | 97367 | 2020-04-28 | Clearfield | Pennsylvania | 42033 | 11 | 0 |
100216 | 100216 | 2020-04-29 | Clearfield | Pennsylvania | 42033 | 14 | 0 |
103069 | 103069 | 2020-04-30 | Clearfield | Pennsylvania | 42033 | 16 | 0 |
105932 | 105932 | 2020-05-01 | Clearfield | Pennsylvania | 42033 | 16 | 0 |
108799 | 108799 | 2020-05-02 | Clearfield | Pennsylvania | 42033 | 16 | 0 |
111673 | 111673 | 2020-05-03 | Clearfield | Pennsylvania | 42033 | 21 | 0 |
114555 | 114555 | 2020-05-04 | Clearfield | Pennsylvania | 42033 | 21 | 0 |
117436 | 117436 | 2020-05-05 | Clearfield | Pennsylvania | 42033 | 21 | 0 |
120398 | 120398 | 2020-05-06 | Clearfield | Pennsylvania | 42033 | 21 | 0 |
123375 | 123375 | 2020-05-07 | Clearfield | Pennsylvania | 42033 | 22 | 0 |
126358 | 126358 | 2020-05-08 | Clearfield | Pennsylvania | 42033 | 24 | 0 |
129347 | 129347 | 2020-05-09 | Clearfield | Pennsylvania | 42033 | 24 | 0 |
132336 | 132336 | 2020-05-10 | Clearfield | Pennsylvania | 42033 | 25 | 0 |
135327 | 135327 | 2020-05-11 | Clearfield | Pennsylvania | 42033 | 25 | 0 |
138317 | 138317 | 2020-05-12 | Clearfield | Pennsylvania | 42033 | 30 | 0 |
141313 | 141313 | 2020-05-13 | Clearfield | Pennsylvania | 42033 | 31 | 0 |
144309 | 144309 | 2020-05-14 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
147310 | 147310 | 2020-05-15 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
150317 | 150317 | 2020-05-16 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
153328 | 153328 | 2020-05-17 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
156345 | 156345 | 2020-05-18 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
159366 | 159366 | 2020-05-19 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
162393 | 162393 | 2020-05-20 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
165422 | 165422 | 2020-05-21 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
168458 | 168458 | 2020-05-22 | Clearfield | Pennsylvania | 42033 | 33 | 0 |
171497 | 171497 | 2020-05-23 | Clearfield | Pennsylvania | 42033 | 34 | 0 |
174539 | 174539 | 2020-05-24 | Clearfield | Pennsylvania | 42033 | 34 | 0 |
177583 | 177583 | 2020-05-25 | Clearfield | Pennsylvania | 42033 | 34 | 0 |
180626 | 180626 | 2020-05-26 | Clearfield | Pennsylvania | 42033 | 37 | 0 |
183676 | 183676 | 2020-05-27 | Clearfield | Pennsylvania | 42033 | 37 | 0 |
186733 | 186733 | 2020-05-28 | Clearfield | Pennsylvania | 42033 | 37 | 0 |
189794 | 189794 | 2020-05-29 | Clearfield | Pennsylvania | 42033 | 38 | 0 |
192859 | 192859 | 2020-05-30 | Clearfield | Pennsylvania | 42033 | 39 | 0 |
195928 | 195928 | 2020-05-31 | Clearfield | Pennsylvania | 42033 | 39 | 0 |
199001 | 199001 | 2020-06-01 | Clearfield | Pennsylvania | 42033 | 40 | 0 |
202076 | 202076 | 2020-06-02 | Clearfield | Pennsylvania | 42033 | 42 | 0 |
205153 | 205153 | 2020-06-03 | Clearfield | Pennsylvania | 42033 | 42 | 0 |
208234 | 208234 | 2020-06-04 | Clearfield | Pennsylvania | 42033 | 42 | 0 |
211316 | 211316 | 2020-06-05 | Clearfield | Pennsylvania | 42033 | 43 | 0 |
214402 | 214402 | 2020-06-06 | Clearfield | Pennsylvania | 42033 | 44 | 0 |
217492 | 217492 | 2020-06-07 | Clearfield | Pennsylvania | 42033 | 44 | 0 |
220584 | 220584 | 2020-06-08 | Clearfield | Pennsylvania | 42033 | 44 | 0 |
223679 | 223679 | 2020-06-09 | Clearfield | Pennsylvania | 42033 | 48 | 0 |
226779 | 226779 | 2020-06-10 | Clearfield | Pennsylvania | 42033 | 48 | 0 |
229883 | 229883 | 2020-06-11 | Clearfield | Pennsylvania | 42033 | 49 | 0 |
232988 | 232988 | 2020-06-12 | Clearfield | Pennsylvania | 42033 | 50 | 0 |
236093 | 236093 | 2020-06-13 | Clearfield | Pennsylvania | 42033 | 52 | 0 |
239201 | 239201 | 2020-06-14 | Clearfield | Pennsylvania | 42033 | 55 | 0 |
242310 | 242310 | 2020-06-15 | Clearfield | Pennsylvania | 42033 | 55 | 0 |
245422 | 245422 | 2020-06-16 | Clearfield | Pennsylvania | 42033 | 57 | 0 |
248535 | 248535 | 2020-06-17 | Clearfield | Pennsylvania | 42033 | 57 | 0 |
251650 | 251650 | 2020-06-18 | Clearfield | Pennsylvania | 42033 | 61 | 0 |
254765 | 254765 | 2020-06-19 | Clearfield | Pennsylvania | 42033 | 63 | 0 |
257891 | 257891 | 2020-06-20 | Clearfield | Pennsylvania | 42033 | 66 | 0 |
261018 | 261018 | 2020-06-21 | Clearfield | Pennsylvania | 42033 | 66 | 0 |
264146 | 264146 | 2020-06-22 | Clearfield | Pennsylvania | 42033 | 67 | 0 |
267274 | 267274 | 2020-06-23 | Clearfield | Pennsylvania | 42033 | 70 | 0 |
270408 | 270408 | 2020-06-24 | Clearfield | Pennsylvania | 42033 | 70 | 0 |
273547 | 273547 | 2020-06-25 | Clearfield | Pennsylvania | 42033 | 71 | 0 |
276694 | 276694 | 2020-06-26 | Clearfield | Pennsylvania | 42033 | 72 | 0 |
279842 | 279842 | 2020-06-27 | Clearfield | Pennsylvania | 42033 | 72 | 0 |
282988 | 282988 | 2020-06-28 | Clearfield | Pennsylvania | 42033 | 72 | 0 |
286133 | 286133 | 2020-06-29 | Clearfield | Pennsylvania | 42033 | 72 | 0 |
289284 | 289284 | 2020-06-30 | Clearfield | Pennsylvania | 42033 | 72 | 0 |
292436 | 292436 | 2020-07-01 | Clearfield | Pennsylvania | 42033 | 72 | 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);