ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 42109 and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
17212 | 17212 | 2020-03-28 | Snyder | Pennsylvania | 42109 | 1 | 0 |
19151 | 19151 | 2020-03-29 | Snyder | Pennsylvania | 42109 | 2 | 0 |
21201 | 21201 | 2020-03-30 | Snyder | Pennsylvania | 42109 | 2 | 0 |
23337 | 23337 | 2020-03-31 | Snyder | Pennsylvania | 42109 | 2 | 1 |
25535 | 25535 | 2020-04-01 | Snyder | Pennsylvania | 42109 | 3 | 1 |
27808 | 27808 | 2020-04-02 | Snyder | Pennsylvania | 42109 | 3 | 1 |
30142 | 30142 | 2020-04-03 | Snyder | Pennsylvania | 42109 | 4 | 1 |
32532 | 32532 | 2020-04-04 | Snyder | Pennsylvania | 42109 | 6 | 1 |
34968 | 34968 | 2020-04-05 | Snyder | Pennsylvania | 42109 | 8 | 1 |
37443 | 37443 | 2020-04-06 | Snyder | Pennsylvania | 42109 | 8 | 1 |
39966 | 39966 | 2020-04-07 | Snyder | Pennsylvania | 42109 | 9 | 1 |
42526 | 42526 | 2020-04-08 | Snyder | Pennsylvania | 42109 | 9 | 1 |
45112 | 45112 | 2020-04-09 | Snyder | Pennsylvania | 42109 | 9 | 1 |
47729 | 47729 | 2020-04-10 | Snyder | Pennsylvania | 42109 | 12 | 1 |
50386 | 50386 | 2020-04-11 | Snyder | Pennsylvania | 42109 | 16 | 1 |
53059 | 53059 | 2020-04-12 | Snyder | Pennsylvania | 42109 | 20 | 1 |
55744 | 55744 | 2020-04-13 | Snyder | Pennsylvania | 42109 | 23 | 1 |
58447 | 58447 | 2020-04-14 | Snyder | Pennsylvania | 42109 | 24 | 1 |
61162 | 61162 | 2020-04-15 | Snyder | Pennsylvania | 42109 | 24 | 1 |
63888 | 63888 | 2020-04-16 | Snyder | Pennsylvania | 42109 | 24 | 1 |
66634 | 66634 | 2020-04-17 | Snyder | Pennsylvania | 42109 | 25 | 1 |
69392 | 69392 | 2020-04-18 | Snyder | Pennsylvania | 42109 | 27 | 1 |
72159 | 72159 | 2020-04-19 | Snyder | Pennsylvania | 42109 | 27 | 1 |
74934 | 74934 | 2020-04-20 | Snyder | Pennsylvania | 42109 | 28 | 1 |
77716 | 77716 | 2020-04-21 | Snyder | Pennsylvania | 42109 | 30 | 1 |
80506 | 80506 | 2020-04-22 | Snyder | Pennsylvania | 42109 | 31 | 1 |
83305 | 83305 | 2020-04-23 | Snyder | Pennsylvania | 42109 | 31 | 1 |
86109 | 86109 | 2020-04-24 | Snyder | Pennsylvania | 42109 | 31 | 1 |
88923 | 88923 | 2020-04-25 | Snyder | Pennsylvania | 42109 | 32 | 1 |
91739 | 91739 | 2020-04-26 | Snyder | Pennsylvania | 42109 | 33 | 1 |
94566 | 94566 | 2020-04-27 | Snyder | Pennsylvania | 42109 | 33 | 1 |
97405 | 97405 | 2020-04-28 | Snyder | Pennsylvania | 42109 | 33 | 1 |
100254 | 100254 | 2020-04-29 | Snyder | Pennsylvania | 42109 | 33 | 1 |
103107 | 103107 | 2020-04-30 | Snyder | Pennsylvania | 42109 | 33 | 1 |
105970 | 105970 | 2020-05-01 | Snyder | Pennsylvania | 42109 | 33 | 1 |
108837 | 108837 | 2020-05-02 | Snyder | Pennsylvania | 42109 | 33 | 1 |
111711 | 111711 | 2020-05-03 | Snyder | Pennsylvania | 42109 | 33 | 1 |
114593 | 114593 | 2020-05-04 | Snyder | Pennsylvania | 42109 | 33 | 1 |
117474 | 117474 | 2020-05-05 | Snyder | Pennsylvania | 42109 | 33 | 1 |
120436 | 120436 | 2020-05-06 | Snyder | Pennsylvania | 42109 | 33 | 1 |
123413 | 123413 | 2020-05-07 | Snyder | Pennsylvania | 42109 | 33 | 1 |
126396 | 126396 | 2020-05-08 | Snyder | Pennsylvania | 42109 | 33 | 1 |
129385 | 129385 | 2020-05-09 | Snyder | Pennsylvania | 42109 | 33 | 1 |
132374 | 132374 | 2020-05-10 | Snyder | Pennsylvania | 42109 | 33 | 1 |
135365 | 135365 | 2020-05-11 | Snyder | Pennsylvania | 42109 | 33 | 1 |
138355 | 138355 | 2020-05-12 | Snyder | Pennsylvania | 42109 | 33 | 1 |
141351 | 141351 | 2020-05-13 | Snyder | Pennsylvania | 42109 | 33 | 1 |
144347 | 144347 | 2020-05-14 | Snyder | Pennsylvania | 42109 | 33 | 1 |
147348 | 147348 | 2020-05-15 | Snyder | Pennsylvania | 42109 | 33 | 2 |
150355 | 150355 | 2020-05-16 | Snyder | Pennsylvania | 42109 | 33 | 2 |
153366 | 153366 | 2020-05-17 | Snyder | Pennsylvania | 42109 | 33 | 2 |
156383 | 156383 | 2020-05-18 | Snyder | Pennsylvania | 42109 | 33 | 1 |
159404 | 159404 | 2020-05-19 | Snyder | Pennsylvania | 42109 | 33 | 1 |
162431 | 162431 | 2020-05-20 | Snyder | Pennsylvania | 42109 | 33 | 1 |
165460 | 165460 | 2020-05-21 | Snyder | Pennsylvania | 42109 | 33 | 1 |
168496 | 168496 | 2020-05-22 | Snyder | Pennsylvania | 42109 | 35 | 1 |
171535 | 171535 | 2020-05-23 | Snyder | Pennsylvania | 42109 | 38 | 1 |
174577 | 174577 | 2020-05-24 | Snyder | Pennsylvania | 42109 | 38 | 1 |
177621 | 177621 | 2020-05-25 | Snyder | Pennsylvania | 42109 | 38 | 1 |
180664 | 180664 | 2020-05-26 | Snyder | Pennsylvania | 42109 | 38 | 1 |
183714 | 183714 | 2020-05-27 | Snyder | Pennsylvania | 42109 | 39 | 1 |
186771 | 186771 | 2020-05-28 | Snyder | Pennsylvania | 42109 | 39 | 1 |
189832 | 189832 | 2020-05-29 | Snyder | Pennsylvania | 42109 | 39 | 1 |
192897 | 192897 | 2020-05-30 | Snyder | Pennsylvania | 42109 | 42 | 1 |
195966 | 195966 | 2020-05-31 | Snyder | Pennsylvania | 42109 | 45 | 1 |
199039 | 199039 | 2020-06-01 | Snyder | Pennsylvania | 42109 | 45 | 1 |
202114 | 202114 | 2020-06-02 | Snyder | Pennsylvania | 42109 | 45 | 1 |
205191 | 205191 | 2020-06-03 | Snyder | Pennsylvania | 42109 | 45 | 1 |
208272 | 208272 | 2020-06-04 | Snyder | Pennsylvania | 42109 | 51 | 1 |
211354 | 211354 | 2020-06-05 | Snyder | Pennsylvania | 42109 | 53 | 1 |
214440 | 214440 | 2020-06-06 | Snyder | Pennsylvania | 42109 | 54 | 1 |
217530 | 217530 | 2020-06-07 | Snyder | Pennsylvania | 42109 | 55 | 1 |
220622 | 220622 | 2020-06-08 | Snyder | Pennsylvania | 42109 | 55 | 1 |
223717 | 223717 | 2020-06-09 | Snyder | Pennsylvania | 42109 | 57 | 1 |
226817 | 226817 | 2020-06-10 | Snyder | Pennsylvania | 42109 | 59 | 1 |
229921 | 229921 | 2020-06-11 | Snyder | Pennsylvania | 42109 | 59 | 1 |
233026 | 233026 | 2020-06-12 | Snyder | Pennsylvania | 42109 | 59 | 1 |
236131 | 236131 | 2020-06-13 | Snyder | Pennsylvania | 42109 | 59 | 1 |
239239 | 239239 | 2020-06-14 | Snyder | Pennsylvania | 42109 | 59 | 1 |
242348 | 242348 | 2020-06-15 | Snyder | Pennsylvania | 42109 | 60 | 1 |
245460 | 245460 | 2020-06-16 | Snyder | Pennsylvania | 42109 | 60 | 1 |
248573 | 248573 | 2020-06-17 | Snyder | Pennsylvania | 42109 | 60 | 1 |
251688 | 251688 | 2020-06-18 | Snyder | Pennsylvania | 42109 | 61 | 1 |
254803 | 254803 | 2020-06-19 | Snyder | Pennsylvania | 42109 | 61 | 1 |
257929 | 257929 | 2020-06-20 | Snyder | Pennsylvania | 42109 | 61 | 1 |
261056 | 261056 | 2020-06-21 | Snyder | Pennsylvania | 42109 | 61 | 1 |
264184 | 264184 | 2020-06-22 | Snyder | Pennsylvania | 42109 | 61 | 1 |
267312 | 267312 | 2020-06-23 | Snyder | Pennsylvania | 42109 | 61 | 1 |
270446 | 270446 | 2020-06-24 | Snyder | Pennsylvania | 42109 | 61 | 2 |
273585 | 273585 | 2020-06-25 | Snyder | Pennsylvania | 42109 | 61 | 2 |
276732 | 276732 | 2020-06-26 | Snyder | Pennsylvania | 42109 | 61 | 2 |
279880 | 279880 | 2020-06-27 | Snyder | Pennsylvania | 42109 | 63 | 2 |
283026 | 283026 | 2020-06-28 | Snyder | Pennsylvania | 42109 | 65 | 2 |
286171 | 286171 | 2020-06-29 | Snyder | Pennsylvania | 42109 | 65 | 2 |
289322 | 289322 | 2020-06-30 | Snyder | Pennsylvania | 42109 | 66 | 2 |
292474 | 292474 | 2020-07-01 | Snyder | Pennsylvania | 42109 | 66 | 2 |
295630 | 295630 | 2020-07-02 | Snyder | Pennsylvania | 42109 | 67 | 2 |
298789 | 298789 | 2020-07-03 | Snyder | Pennsylvania | 42109 | 67 | 2 |
301953 | 301953 | 2020-07-04 | Snyder | Pennsylvania | 42109 | 68 | 2 |
305116 | 305116 | 2020-07-05 | Snyder | Pennsylvania | 42109 | 68 | 2 |
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);