ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 42093 and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6867 | 6867 | 2020-03-21 | Montour | Pennsylvania | 42093 | 1 | 0 |
7986 | 7986 | 2020-03-22 | Montour | Pennsylvania | 42093 | 1 | 0 |
9197 | 9197 | 2020-03-23 | Montour | Pennsylvania | 42093 | 1 | 0 |
10521 | 10521 | 2020-03-24 | Montour | Pennsylvania | 42093 | 3 | 0 |
11986 | 11986 | 2020-03-25 | Montour | Pennsylvania | 42093 | 4 | 0 |
13607 | 13607 | 2020-03-26 | Montour | Pennsylvania | 42093 | 4 | 0 |
15353 | 15353 | 2020-03-27 | Montour | Pennsylvania | 42093 | 4 | 0 |
17204 | 17204 | 2020-03-28 | Montour | Pennsylvania | 42093 | 5 | 0 |
19143 | 19143 | 2020-03-29 | Montour | Pennsylvania | 42093 | 5 | 0 |
21193 | 21193 | 2020-03-30 | Montour | Pennsylvania | 42093 | 10 | 0 |
23329 | 23329 | 2020-03-31 | Montour | Pennsylvania | 42093 | 10 | 0 |
25527 | 25527 | 2020-04-01 | Montour | Pennsylvania | 42093 | 13 | 0 |
27800 | 27800 | 2020-04-02 | Montour | Pennsylvania | 42093 | 15 | 0 |
30134 | 30134 | 2020-04-03 | Montour | Pennsylvania | 42093 | 16 | 0 |
32524 | 32524 | 2020-04-04 | Montour | Pennsylvania | 42093 | 19 | 0 |
34960 | 34960 | 2020-04-05 | Montour | Pennsylvania | 42093 | 37 | 0 |
37435 | 37435 | 2020-04-06 | Montour | Pennsylvania | 42093 | 33 | 0 |
39958 | 39958 | 2020-04-07 | Montour | Pennsylvania | 42093 | 27 | 0 |
42518 | 42518 | 2020-04-08 | Montour | Pennsylvania | 42093 | 26 | 0 |
45104 | 45104 | 2020-04-09 | Montour | Pennsylvania | 42093 | 25 | 0 |
47721 | 47721 | 2020-04-10 | Montour | Pennsylvania | 42093 | 29 | 0 |
50378 | 50378 | 2020-04-11 | Montour | Pennsylvania | 42093 | 29 | 0 |
53051 | 53051 | 2020-04-12 | Montour | Pennsylvania | 42093 | 29 | 0 |
55736 | 55736 | 2020-04-13 | Montour | Pennsylvania | 42093 | 39 | 0 |
58439 | 58439 | 2020-04-14 | Montour | Pennsylvania | 42093 | 44 | 0 |
61154 | 61154 | 2020-04-15 | Montour | Pennsylvania | 42093 | 44 | 0 |
63880 | 63880 | 2020-04-16 | Montour | Pennsylvania | 42093 | 48 | 0 |
66626 | 66626 | 2020-04-17 | Montour | Pennsylvania | 42093 | 48 | 0 |
69384 | 69384 | 2020-04-18 | Montour | Pennsylvania | 42093 | 49 | 0 |
72151 | 72151 | 2020-04-19 | Montour | Pennsylvania | 42093 | 48 | 0 |
74926 | 74926 | 2020-04-20 | Montour | Pennsylvania | 42093 | 48 | 0 |
77708 | 77708 | 2020-04-21 | Montour | Pennsylvania | 42093 | 48 | 0 |
80498 | 80498 | 2020-04-22 | Montour | Pennsylvania | 42093 | 48 | 0 |
83297 | 83297 | 2020-04-23 | Montour | Pennsylvania | 42093 | 48 | 0 |
86101 | 86101 | 2020-04-24 | Montour | Pennsylvania | 42093 | 48 | 0 |
88915 | 88915 | 2020-04-25 | Montour | Pennsylvania | 42093 | 48 | 0 |
91731 | 91731 | 2020-04-26 | Montour | Pennsylvania | 42093 | 48 | 0 |
94558 | 94558 | 2020-04-27 | Montour | Pennsylvania | 42093 | 48 | 0 |
97397 | 97397 | 2020-04-28 | Montour | Pennsylvania | 42093 | 48 | 0 |
100246 | 100246 | 2020-04-29 | Montour | Pennsylvania | 42093 | 48 | 0 |
103099 | 103099 | 2020-04-30 | Montour | Pennsylvania | 42093 | 48 | 0 |
105962 | 105962 | 2020-05-01 | Montour | Pennsylvania | 42093 | 48 | 0 |
108829 | 108829 | 2020-05-02 | Montour | Pennsylvania | 42093 | 49 | 0 |
111703 | 111703 | 2020-05-03 | Montour | Pennsylvania | 42093 | 50 | 0 |
114585 | 114585 | 2020-05-04 | Montour | Pennsylvania | 42093 | 50 | 0 |
117466 | 117466 | 2020-05-05 | Montour | Pennsylvania | 42093 | 50 | 0 |
120428 | 120428 | 2020-05-06 | Montour | Pennsylvania | 42093 | 50 | 0 |
123405 | 123405 | 2020-05-07 | Montour | Pennsylvania | 42093 | 50 | 0 |
126388 | 126388 | 2020-05-08 | Montour | Pennsylvania | 42093 | 50 | 0 |
129377 | 129377 | 2020-05-09 | Montour | Pennsylvania | 42093 | 49 | 0 |
132366 | 132366 | 2020-05-10 | Montour | Pennsylvania | 42093 | 49 | 0 |
135357 | 135357 | 2020-05-11 | Montour | Pennsylvania | 42093 | 49 | 0 |
138347 | 138347 | 2020-05-12 | Montour | Pennsylvania | 42093 | 49 | 0 |
141343 | 141343 | 2020-05-13 | Montour | Pennsylvania | 42093 | 50 | 0 |
144339 | 144339 | 2020-05-14 | Montour | Pennsylvania | 42093 | 50 | 0 |
147340 | 147340 | 2020-05-15 | Montour | Pennsylvania | 42093 | 50 | 1 |
150347 | 150347 | 2020-05-16 | Montour | Pennsylvania | 42093 | 50 | 1 |
153358 | 153358 | 2020-05-17 | Montour | Pennsylvania | 42093 | 50 | 1 |
156375 | 156375 | 2020-05-18 | Montour | Pennsylvania | 42093 | 50 | 0 |
159396 | 159396 | 2020-05-19 | Montour | Pennsylvania | 42093 | 50 | 0 |
162423 | 162423 | 2020-05-20 | Montour | Pennsylvania | 42093 | 50 | 0 |
165452 | 165452 | 2020-05-21 | Montour | Pennsylvania | 42093 | 51 | 0 |
168488 | 168488 | 2020-05-22 | Montour | Pennsylvania | 42093 | 50 | 0 |
171527 | 171527 | 2020-05-23 | Montour | Pennsylvania | 42093 | 50 | 0 |
174569 | 174569 | 2020-05-24 | Montour | Pennsylvania | 42093 | 50 | 0 |
177613 | 177613 | 2020-05-25 | Montour | Pennsylvania | 42093 | 50 | 0 |
180656 | 180656 | 2020-05-26 | Montour | Pennsylvania | 42093 | 50 | 0 |
183706 | 183706 | 2020-05-27 | Montour | Pennsylvania | 42093 | 50 | 0 |
186763 | 186763 | 2020-05-28 | Montour | Pennsylvania | 42093 | 50 | 0 |
189824 | 189824 | 2020-05-29 | Montour | Pennsylvania | 42093 | 50 | 0 |
192889 | 192889 | 2020-05-30 | Montour | Pennsylvania | 42093 | 50 | 0 |
195958 | 195958 | 2020-05-31 | Montour | Pennsylvania | 42093 | 52 | 0 |
199031 | 199031 | 2020-06-01 | Montour | Pennsylvania | 42093 | 53 | 0 |
202106 | 202106 | 2020-06-02 | Montour | Pennsylvania | 42093 | 53 | 0 |
205183 | 205183 | 2020-06-03 | Montour | Pennsylvania | 42093 | 53 | 0 |
208264 | 208264 | 2020-06-04 | Montour | Pennsylvania | 42093 | 53 | 0 |
211346 | 211346 | 2020-06-05 | Montour | Pennsylvania | 42093 | 53 | 0 |
214432 | 214432 | 2020-06-06 | Montour | Pennsylvania | 42093 | 53 | 0 |
217522 | 217522 | 2020-06-07 | Montour | Pennsylvania | 42093 | 53 | 0 |
220614 | 220614 | 2020-06-08 | Montour | Pennsylvania | 42093 | 53 | 0 |
223709 | 223709 | 2020-06-09 | Montour | Pennsylvania | 42093 | 53 | 0 |
226809 | 226809 | 2020-06-10 | Montour | Pennsylvania | 42093 | 53 | 0 |
229913 | 229913 | 2020-06-11 | Montour | Pennsylvania | 42093 | 55 | 0 |
233018 | 233018 | 2020-06-12 | Montour | Pennsylvania | 42093 | 56 | 0 |
236123 | 236123 | 2020-06-13 | Montour | Pennsylvania | 42093 | 64 | 0 |
239231 | 239231 | 2020-06-14 | Montour | Pennsylvania | 42093 | 64 | 0 |
242340 | 242340 | 2020-06-15 | Montour | Pennsylvania | 42093 | 65 | 0 |
245452 | 245452 | 2020-06-16 | Montour | Pennsylvania | 42093 | 65 | 0 |
248565 | 248565 | 2020-06-17 | Montour | Pennsylvania | 42093 | 67 | 0 |
251680 | 251680 | 2020-06-18 | Montour | Pennsylvania | 42093 | 68 | 0 |
254795 | 254795 | 2020-06-19 | Montour | Pennsylvania | 42093 | 68 | 0 |
257921 | 257921 | 2020-06-20 | Montour | Pennsylvania | 42093 | 68 | 0 |
261048 | 261048 | 2020-06-21 | Montour | Pennsylvania | 42093 | 68 | 0 |
264176 | 264176 | 2020-06-22 | Montour | Pennsylvania | 42093 | 68 | 0 |
267304 | 267304 | 2020-06-23 | Montour | Pennsylvania | 42093 | 68 | 0 |
270438 | 270438 | 2020-06-24 | Montour | Pennsylvania | 42093 | 68 | 0 |
273577 | 273577 | 2020-06-25 | Montour | Pennsylvania | 42093 | 68 | 0 |
276724 | 276724 | 2020-06-26 | Montour | Pennsylvania | 42093 | 69 | 0 |
279872 | 279872 | 2020-06-27 | Montour | Pennsylvania | 42093 | 70 | 0 |
283018 | 283018 | 2020-06-28 | Montour | Pennsylvania | 42093 | 73 | 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);