ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Clinton" 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 |
---|---|---|---|---|---|---|---|
30108 | 30108 | 2020-04-03 | Clinton | Pennsylvania | 42035 | 1 | 0 |
32498 | 32498 | 2020-04-04 | Clinton | Pennsylvania | 42035 | 1 | 0 |
34933 | 34933 | 2020-04-05 | Clinton | Pennsylvania | 42035 | 1 | 0 |
37408 | 37408 | 2020-04-06 | Clinton | Pennsylvania | 42035 | 3 | 0 |
39929 | 39929 | 2020-04-07 | Clinton | Pennsylvania | 42035 | 3 | 0 |
42489 | 42489 | 2020-04-08 | Clinton | Pennsylvania | 42035 | 3 | 0 |
45075 | 45075 | 2020-04-09 | Clinton | Pennsylvania | 42035 | 4 | 0 |
47692 | 47692 | 2020-04-10 | Clinton | Pennsylvania | 42035 | 6 | 0 |
50349 | 50349 | 2020-04-11 | Clinton | Pennsylvania | 42035 | 7 | 0 |
53022 | 53022 | 2020-04-12 | Clinton | Pennsylvania | 42035 | 8 | 0 |
55707 | 55707 | 2020-04-13 | Clinton | Pennsylvania | 42035 | 8 | 0 |
58410 | 58410 | 2020-04-14 | Clinton | Pennsylvania | 42035 | 8 | 0 |
61125 | 61125 | 2020-04-15 | Clinton | Pennsylvania | 42035 | 8 | 0 |
63851 | 63851 | 2020-04-16 | Clinton | Pennsylvania | 42035 | 8 | 0 |
66597 | 66597 | 2020-04-17 | Clinton | Pennsylvania | 42035 | 10 | 0 |
69355 | 69355 | 2020-04-18 | Clinton | Pennsylvania | 42035 | 11 | 0 |
72122 | 72122 | 2020-04-19 | Clinton | Pennsylvania | 42035 | 11 | 0 |
74897 | 74897 | 2020-04-20 | Clinton | Pennsylvania | 42035 | 11 | 0 |
77679 | 77679 | 2020-04-21 | Clinton | Pennsylvania | 42035 | 11 | 0 |
80469 | 80469 | 2020-04-22 | Clinton | Pennsylvania | 42035 | 13 | 0 |
83268 | 83268 | 2020-04-23 | Clinton | Pennsylvania | 42035 | 14 | 0 |
86072 | 86072 | 2020-04-24 | Clinton | Pennsylvania | 42035 | 17 | 0 |
88886 | 88886 | 2020-04-25 | Clinton | Pennsylvania | 42035 | 18 | 0 |
91702 | 91702 | 2020-04-26 | Clinton | Pennsylvania | 42035 | 21 | 0 |
94529 | 94529 | 2020-04-27 | Clinton | Pennsylvania | 42035 | 25 | 0 |
97368 | 97368 | 2020-04-28 | Clinton | Pennsylvania | 42035 | 29 | 0 |
100217 | 100217 | 2020-04-29 | Clinton | Pennsylvania | 42035 | 30 | 0 |
103070 | 103070 | 2020-04-30 | Clinton | Pennsylvania | 42035 | 31 | 0 |
105933 | 105933 | 2020-05-01 | Clinton | Pennsylvania | 42035 | 32 | 0 |
108800 | 108800 | 2020-05-02 | Clinton | Pennsylvania | 42035 | 34 | 0 |
111674 | 111674 | 2020-05-03 | Clinton | Pennsylvania | 42035 | 32 | 0 |
114556 | 114556 | 2020-05-04 | Clinton | Pennsylvania | 42035 | 33 | 0 |
117437 | 117437 | 2020-05-05 | Clinton | Pennsylvania | 42035 | 33 | 0 |
120399 | 120399 | 2020-05-06 | Clinton | Pennsylvania | 42035 | 34 | 0 |
123376 | 123376 | 2020-05-07 | Clinton | Pennsylvania | 42035 | 35 | 0 |
126359 | 126359 | 2020-05-08 | Clinton | Pennsylvania | 42035 | 37 | 0 |
129348 | 129348 | 2020-05-09 | Clinton | Pennsylvania | 42035 | 41 | 0 |
132337 | 132337 | 2020-05-10 | Clinton | Pennsylvania | 42035 | 41 | 0 |
135328 | 135328 | 2020-05-11 | Clinton | Pennsylvania | 42035 | 41 | 0 |
138318 | 138318 | 2020-05-12 | Clinton | Pennsylvania | 42035 | 41 | 0 |
141314 | 141314 | 2020-05-13 | Clinton | Pennsylvania | 42035 | 41 | 0 |
144310 | 144310 | 2020-05-14 | Clinton | Pennsylvania | 42035 | 43 | 0 |
147311 | 147311 | 2020-05-15 | Clinton | Pennsylvania | 42035 | 43 | 0 |
150318 | 150318 | 2020-05-16 | Clinton | Pennsylvania | 42035 | 43 | 0 |
153329 | 153329 | 2020-05-17 | Clinton | Pennsylvania | 42035 | 44 | 0 |
156346 | 156346 | 2020-05-18 | Clinton | Pennsylvania | 42035 | 44 | 0 |
159367 | 159367 | 2020-05-19 | Clinton | Pennsylvania | 42035 | 45 | 0 |
162394 | 162394 | 2020-05-20 | Clinton | Pennsylvania | 42035 | 45 | 0 |
165423 | 165423 | 2020-05-21 | Clinton | Pennsylvania | 42035 | 48 | 0 |
168459 | 168459 | 2020-05-22 | Clinton | Pennsylvania | 42035 | 48 | 0 |
171498 | 171498 | 2020-05-23 | Clinton | Pennsylvania | 42035 | 49 | 1 |
174540 | 174540 | 2020-05-24 | Clinton | Pennsylvania | 42035 | 50 | 1 |
177584 | 177584 | 2020-05-25 | Clinton | Pennsylvania | 42035 | 51 | 1 |
180627 | 180627 | 2020-05-26 | Clinton | Pennsylvania | 42035 | 54 | 1 |
183677 | 183677 | 2020-05-27 | Clinton | Pennsylvania | 42035 | 54 | 1 |
186734 | 186734 | 2020-05-28 | Clinton | Pennsylvania | 42035 | 55 | 2 |
189795 | 189795 | 2020-05-29 | Clinton | Pennsylvania | 42035 | 55 | 2 |
192860 | 192860 | 2020-05-30 | Clinton | Pennsylvania | 42035 | 56 | 3 |
195929 | 195929 | 2020-05-31 | Clinton | Pennsylvania | 42035 | 56 | 3 |
199002 | 199002 | 2020-06-01 | Clinton | Pennsylvania | 42035 | 57 | 3 |
202077 | 202077 | 2020-06-02 | Clinton | Pennsylvania | 42035 | 60 | 3 |
205154 | 205154 | 2020-06-03 | Clinton | Pennsylvania | 42035 | 60 | 3 |
208235 | 208235 | 2020-06-04 | Clinton | Pennsylvania | 42035 | 60 | 3 |
211317 | 211317 | 2020-06-05 | Clinton | Pennsylvania | 42035 | 60 | 3 |
214403 | 214403 | 2020-06-06 | Clinton | Pennsylvania | 42035 | 60 | 3 |
217493 | 217493 | 2020-06-07 | Clinton | Pennsylvania | 42035 | 60 | 3 |
220585 | 220585 | 2020-06-08 | Clinton | Pennsylvania | 42035 | 61 | 3 |
223680 | 223680 | 2020-06-09 | Clinton | Pennsylvania | 42035 | 61 | 3 |
226780 | 226780 | 2020-06-10 | Clinton | Pennsylvania | 42035 | 62 | 3 |
229884 | 229884 | 2020-06-11 | Clinton | Pennsylvania | 42035 | 61 | 3 |
232989 | 232989 | 2020-06-12 | Clinton | Pennsylvania | 42035 | 61 | 3 |
236094 | 236094 | 2020-06-13 | Clinton | Pennsylvania | 42035 | 63 | 3 |
239202 | 239202 | 2020-06-14 | Clinton | Pennsylvania | 42035 | 63 | 3 |
242311 | 242311 | 2020-06-15 | Clinton | Pennsylvania | 42035 | 64 | 3 |
245423 | 245423 | 2020-06-16 | Clinton | Pennsylvania | 42035 | 64 | 3 |
248536 | 248536 | 2020-06-17 | Clinton | Pennsylvania | 42035 | 64 | 3 |
251651 | 251651 | 2020-06-18 | Clinton | Pennsylvania | 42035 | 65 | 3 |
254766 | 254766 | 2020-06-19 | Clinton | Pennsylvania | 42035 | 67 | 3 |
257892 | 257892 | 2020-06-20 | Clinton | Pennsylvania | 42035 | 70 | 3 |
261019 | 261019 | 2020-06-21 | Clinton | Pennsylvania | 42035 | 70 | 3 |
264147 | 264147 | 2020-06-22 | Clinton | Pennsylvania | 42035 | 71 | 3 |
267275 | 267275 | 2020-06-23 | Clinton | Pennsylvania | 42035 | 73 | 3 |
270409 | 270409 | 2020-06-24 | Clinton | Pennsylvania | 42035 | 73 | 3 |
273548 | 273548 | 2020-06-25 | Clinton | Pennsylvania | 42035 | 74 | 4 |
276695 | 276695 | 2020-06-26 | Clinton | Pennsylvania | 42035 | 75 | 4 |
279843 | 279843 | 2020-06-27 | Clinton | Pennsylvania | 42035 | 75 | 4 |
282989 | 282989 | 2020-06-28 | Clinton | Pennsylvania | 42035 | 75 | 4 |
286134 | 286134 | 2020-06-29 | Clinton | Pennsylvania | 42035 | 77 | 4 |
289285 | 289285 | 2020-06-30 | Clinton | Pennsylvania | 42035 | 78 | 4 |
292437 | 292437 | 2020-07-01 | Clinton | Pennsylvania | 42035 | 80 | 4 |
295593 | 295593 | 2020-07-02 | Clinton | Pennsylvania | 42035 | 80 | 4 |
298752 | 298752 | 2020-07-03 | Clinton | Pennsylvania | 42035 | 80 | 4 |
301916 | 301916 | 2020-07-04 | Clinton | Pennsylvania | 42035 | 80 | 4 |
305079 | 305079 | 2020-07-05 | Clinton | Pennsylvania | 42035 | 80 | 4 |
308246 | 308246 | 2020-07-06 | Clinton | Pennsylvania | 42035 | 81 | 4 |
311415 | 311415 | 2020-07-07 | Clinton | Pennsylvania | 42035 | 81 | 4 |
314587 | 314587 | 2020-07-08 | Clinton | Pennsylvania | 42035 | 86 | 4 |
317760 | 317760 | 2020-07-09 | Clinton | Pennsylvania | 42035 | 91 | 4 |
320938 | 320938 | 2020-07-10 | Clinton | Pennsylvania | 42035 | 95 | 4 |
324118 | 324118 | 2020-07-11 | Clinton | Pennsylvania | 42035 | 95 | 4 |
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);