ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 42117 and state = "Pennsylvania" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17215 | 17215 | 2020-03-28 | Tioga | Pennsylvania | 42117 | 1 | 0 |
19154 | 19154 | 2020-03-29 | Tioga | Pennsylvania | 42117 | 1 | 0 |
21204 | 21204 | 2020-03-30 | Tioga | Pennsylvania | 42117 | 1 | 0 |
23340 | 23340 | 2020-03-31 | Tioga | Pennsylvania | 42117 | 2 | 0 |
25538 | 25538 | 2020-04-01 | Tioga | Pennsylvania | 42117 | 2 | 0 |
27811 | 27811 | 2020-04-02 | Tioga | Pennsylvania | 42117 | 2 | 0 |
30145 | 30145 | 2020-04-03 | Tioga | Pennsylvania | 42117 | 3 | 0 |
32536 | 32536 | 2020-04-04 | Tioga | Pennsylvania | 42117 | 3 | 0 |
34972 | 34972 | 2020-04-05 | Tioga | Pennsylvania | 42117 | 3 | 0 |
37447 | 37447 | 2020-04-06 | Tioga | Pennsylvania | 42117 | 8 | 0 |
39970 | 39970 | 2020-04-07 | Tioga | Pennsylvania | 42117 | 10 | 0 |
42530 | 42530 | 2020-04-08 | Tioga | Pennsylvania | 42117 | 10 | 0 |
45116 | 45116 | 2020-04-09 | Tioga | Pennsylvania | 42117 | 10 | 0 |
47733 | 47733 | 2020-04-10 | Tioga | Pennsylvania | 42117 | 11 | 0 |
50390 | 50390 | 2020-04-11 | Tioga | Pennsylvania | 42117 | 12 | 1 |
53063 | 53063 | 2020-04-12 | Tioga | Pennsylvania | 42117 | 13 | 1 |
55748 | 55748 | 2020-04-13 | Tioga | Pennsylvania | 42117 | 14 | 1 |
58451 | 58451 | 2020-04-14 | Tioga | Pennsylvania | 42117 | 13 | 1 |
61166 | 61166 | 2020-04-15 | Tioga | Pennsylvania | 42117 | 13 | 1 |
63892 | 63892 | 2020-04-16 | Tioga | Pennsylvania | 42117 | 13 | 1 |
66638 | 66638 | 2020-04-17 | Tioga | Pennsylvania | 42117 | 14 | 1 |
69396 | 69396 | 2020-04-18 | Tioga | Pennsylvania | 42117 | 14 | 1 |
72163 | 72163 | 2020-04-19 | Tioga | Pennsylvania | 42117 | 14 | 1 |
74938 | 74938 | 2020-04-20 | Tioga | Pennsylvania | 42117 | 14 | 1 |
77720 | 77720 | 2020-04-21 | Tioga | Pennsylvania | 42117 | 15 | 2 |
80510 | 80510 | 2020-04-22 | Tioga | Pennsylvania | 42117 | 15 | 2 |
83309 | 83309 | 2020-04-23 | Tioga | Pennsylvania | 42117 | 14 | 2 |
86113 | 86113 | 2020-04-24 | Tioga | Pennsylvania | 42117 | 14 | 2 |
88927 | 88927 | 2020-04-25 | Tioga | Pennsylvania | 42117 | 14 | 2 |
91743 | 91743 | 2020-04-26 | Tioga | Pennsylvania | 42117 | 14 | 2 |
94570 | 94570 | 2020-04-27 | Tioga | Pennsylvania | 42117 | 14 | 2 |
97409 | 97409 | 2020-04-28 | Tioga | Pennsylvania | 42117 | 14 | 2 |
100258 | 100258 | 2020-04-29 | Tioga | Pennsylvania | 42117 | 14 | 2 |
103111 | 103111 | 2020-04-30 | Tioga | Pennsylvania | 42117 | 16 | 2 |
105974 | 105974 | 2020-05-01 | Tioga | Pennsylvania | 42117 | 16 | 2 |
108841 | 108841 | 2020-05-02 | Tioga | Pennsylvania | 42117 | 16 | 2 |
111715 | 111715 | 2020-05-03 | Tioga | Pennsylvania | 42117 | 16 | 2 |
114597 | 114597 | 2020-05-04 | Tioga | Pennsylvania | 42117 | 16 | 2 |
117478 | 117478 | 2020-05-05 | Tioga | Pennsylvania | 42117 | 16 | 2 |
120440 | 120440 | 2020-05-06 | Tioga | Pennsylvania | 42117 | 16 | 2 |
123417 | 123417 | 2020-05-07 | Tioga | Pennsylvania | 42117 | 16 | 2 |
126400 | 126400 | 2020-05-08 | Tioga | Pennsylvania | 42117 | 16 | 2 |
129389 | 129389 | 2020-05-09 | Tioga | Pennsylvania | 42117 | 16 | 2 |
132378 | 132378 | 2020-05-10 | Tioga | Pennsylvania | 42117 | 16 | 2 |
135369 | 135369 | 2020-05-11 | Tioga | Pennsylvania | 42117 | 16 | 2 |
138359 | 138359 | 2020-05-12 | Tioga | Pennsylvania | 42117 | 16 | 2 |
141355 | 141355 | 2020-05-13 | Tioga | Pennsylvania | 42117 | 16 | 2 |
144351 | 144351 | 2020-05-14 | Tioga | Pennsylvania | 42117 | 16 | 2 |
147352 | 147352 | 2020-05-15 | Tioga | Pennsylvania | 42117 | 16 | 2 |
150359 | 150359 | 2020-05-16 | Tioga | Pennsylvania | 42117 | 16 | 2 |
153370 | 153370 | 2020-05-17 | Tioga | Pennsylvania | 42117 | 16 | 2 |
156387 | 156387 | 2020-05-18 | Tioga | Pennsylvania | 42117 | 16 | 2 |
159408 | 159408 | 2020-05-19 | Tioga | Pennsylvania | 42117 | 16 | 2 |
162435 | 162435 | 2020-05-20 | Tioga | Pennsylvania | 42117 | 16 | 2 |
165464 | 165464 | 2020-05-21 | Tioga | Pennsylvania | 42117 | 16 | 2 |
168500 | 168500 | 2020-05-22 | Tioga | Pennsylvania | 42117 | 16 | 2 |
171539 | 171539 | 2020-05-23 | Tioga | Pennsylvania | 42117 | 16 | 2 |
174581 | 174581 | 2020-05-24 | Tioga | Pennsylvania | 42117 | 16 | 2 |
177625 | 177625 | 2020-05-25 | Tioga | Pennsylvania | 42117 | 16 | 2 |
180668 | 180668 | 2020-05-26 | Tioga | Pennsylvania | 42117 | 16 | 2 |
183718 | 183718 | 2020-05-27 | Tioga | Pennsylvania | 42117 | 16 | 2 |
186775 | 186775 | 2020-05-28 | Tioga | Pennsylvania | 42117 | 16 | 2 |
189836 | 189836 | 2020-05-29 | Tioga | Pennsylvania | 42117 | 17 | 2 |
192901 | 192901 | 2020-05-30 | Tioga | Pennsylvania | 42117 | 17 | 2 |
195970 | 195970 | 2020-05-31 | Tioga | Pennsylvania | 42117 | 17 | 2 |
199043 | 199043 | 2020-06-01 | Tioga | Pennsylvania | 42117 | 17 | 2 |
202118 | 202118 | 2020-06-02 | Tioga | Pennsylvania | 42117 | 19 | 2 |
205195 | 205195 | 2020-06-03 | Tioga | Pennsylvania | 42117 | 19 | 2 |
208276 | 208276 | 2020-06-04 | Tioga | Pennsylvania | 42117 | 19 | 2 |
211358 | 211358 | 2020-06-05 | Tioga | Pennsylvania | 42117 | 19 | 2 |
214444 | 214444 | 2020-06-06 | Tioga | Pennsylvania | 42117 | 19 | 2 |
217534 | 217534 | 2020-06-07 | Tioga | Pennsylvania | 42117 | 19 | 2 |
220626 | 220626 | 2020-06-08 | Tioga | Pennsylvania | 42117 | 19 | 2 |
223721 | 223721 | 2020-06-09 | Tioga | Pennsylvania | 42117 | 19 | 2 |
226821 | 226821 | 2020-06-10 | Tioga | Pennsylvania | 42117 | 19 | 2 |
229925 | 229925 | 2020-06-11 | Tioga | Pennsylvania | 42117 | 20 | 2 |
233030 | 233030 | 2020-06-12 | Tioga | Pennsylvania | 42117 | 20 | 2 |
236135 | 236135 | 2020-06-13 | Tioga | Pennsylvania | 42117 | 20 | 2 |
239243 | 239243 | 2020-06-14 | Tioga | Pennsylvania | 42117 | 20 | 2 |
242352 | 242352 | 2020-06-15 | Tioga | Pennsylvania | 42117 | 20 | 2 |
245464 | 245464 | 2020-06-16 | Tioga | Pennsylvania | 42117 | 20 | 2 |
248577 | 248577 | 2020-06-17 | Tioga | Pennsylvania | 42117 | 20 | 2 |
251692 | 251692 | 2020-06-18 | Tioga | Pennsylvania | 42117 | 20 | 2 |
254807 | 254807 | 2020-06-19 | Tioga | Pennsylvania | 42117 | 20 | 2 |
257933 | 257933 | 2020-06-20 | Tioga | Pennsylvania | 42117 | 20 | 2 |
261060 | 261060 | 2020-06-21 | Tioga | Pennsylvania | 42117 | 22 | 2 |
264188 | 264188 | 2020-06-22 | Tioga | Pennsylvania | 42117 | 23 | 2 |
267316 | 267316 | 2020-06-23 | Tioga | Pennsylvania | 42117 | 23 | 2 |
270450 | 270450 | 2020-06-24 | Tioga | Pennsylvania | 42117 | 23 | 2 |
273589 | 273589 | 2020-06-25 | Tioga | Pennsylvania | 42117 | 23 | 2 |
276736 | 276736 | 2020-06-26 | Tioga | Pennsylvania | 42117 | 23 | 2 |
279884 | 279884 | 2020-06-27 | Tioga | Pennsylvania | 42117 | 24 | 2 |
283030 | 283030 | 2020-06-28 | Tioga | Pennsylvania | 42117 | 24 | 2 |
286175 | 286175 | 2020-06-29 | Tioga | Pennsylvania | 42117 | 25 | 2 |
289326 | 289326 | 2020-06-30 | Tioga | Pennsylvania | 42117 | 25 | 2 |
292478 | 292478 | 2020-07-01 | Tioga | Pennsylvania | 42117 | 25 | 2 |
295634 | 295634 | 2020-07-02 | Tioga | Pennsylvania | 42117 | 25 | 2 |
298793 | 298793 | 2020-07-03 | Tioga | Pennsylvania | 42117 | 26 | 2 |
301957 | 301957 | 2020-07-04 | Tioga | Pennsylvania | 42117 | 26 | 2 |
305120 | 305120 | 2020-07-05 | Tioga | Pennsylvania | 42117 | 27 | 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);