ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Fulton" and state = "Pennsylvania" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
34943 | 34943 | 2020-04-05 | Fulton | Pennsylvania | 42057 | 1 | 0 |
37418 | 37418 | 2020-04-06 | Fulton | Pennsylvania | 42057 | 1 | 0 |
39940 | 39940 | 2020-04-07 | Fulton | Pennsylvania | 42057 | 1 | 0 |
42500 | 42500 | 2020-04-08 | Fulton | Pennsylvania | 42057 | 1 | 0 |
45086 | 45086 | 2020-04-09 | Fulton | Pennsylvania | 42057 | 1 | 0 |
47703 | 47703 | 2020-04-10 | Fulton | Pennsylvania | 42057 | 1 | 0 |
50360 | 50360 | 2020-04-11 | Fulton | Pennsylvania | 42057 | 1 | 0 |
53033 | 53033 | 2020-04-12 | Fulton | Pennsylvania | 42057 | 1 | 0 |
55718 | 55718 | 2020-04-13 | Fulton | Pennsylvania | 42057 | 1 | 0 |
58421 | 58421 | 2020-04-14 | Fulton | Pennsylvania | 42057 | 2 | 0 |
61136 | 61136 | 2020-04-15 | Fulton | Pennsylvania | 42057 | 2 | 0 |
63862 | 63862 | 2020-04-16 | Fulton | Pennsylvania | 42057 | 2 | 0 |
66608 | 66608 | 2020-04-17 | Fulton | Pennsylvania | 42057 | 2 | 0 |
69366 | 69366 | 2020-04-18 | Fulton | Pennsylvania | 42057 | 2 | 0 |
72133 | 72133 | 2020-04-19 | Fulton | Pennsylvania | 42057 | 2 | 0 |
74908 | 74908 | 2020-04-20 | Fulton | Pennsylvania | 42057 | 2 | 0 |
77690 | 77690 | 2020-04-21 | Fulton | Pennsylvania | 42057 | 2 | 0 |
80480 | 80480 | 2020-04-22 | Fulton | Pennsylvania | 42057 | 2 | 0 |
83279 | 83279 | 2020-04-23 | Fulton | Pennsylvania | 42057 | 2 | 0 |
86083 | 86083 | 2020-04-24 | Fulton | Pennsylvania | 42057 | 2 | 0 |
88897 | 88897 | 2020-04-25 | Fulton | Pennsylvania | 42057 | 3 | 0 |
91713 | 91713 | 2020-04-26 | Fulton | Pennsylvania | 42057 | 3 | 0 |
94540 | 94540 | 2020-04-27 | Fulton | Pennsylvania | 42057 | 3 | 0 |
97379 | 97379 | 2020-04-28 | Fulton | Pennsylvania | 42057 | 3 | 0 |
100228 | 100228 | 2020-04-29 | Fulton | Pennsylvania | 42057 | 5 | 0 |
103081 | 103081 | 2020-04-30 | Fulton | Pennsylvania | 42057 | 5 | 0 |
105944 | 105944 | 2020-05-01 | Fulton | Pennsylvania | 42057 | 5 | 0 |
108811 | 108811 | 2020-05-02 | Fulton | Pennsylvania | 42057 | 6 | 0 |
111685 | 111685 | 2020-05-03 | Fulton | Pennsylvania | 42057 | 6 | 0 |
114567 | 114567 | 2020-05-04 | Fulton | Pennsylvania | 42057 | 6 | 0 |
117448 | 117448 | 2020-05-05 | Fulton | Pennsylvania | 42057 | 7 | 0 |
120410 | 120410 | 2020-05-06 | Fulton | Pennsylvania | 42057 | 7 | 0 |
123387 | 123387 | 2020-05-07 | Fulton | Pennsylvania | 42057 | 7 | 0 |
129359 | 129359 | 2020-05-09 | Fulton | Pennsylvania | 42057 | 8 | 0 |
132348 | 132348 | 2020-05-10 | Fulton | Pennsylvania | 42057 | 8 | 0 |
135339 | 135339 | 2020-05-11 | Fulton | Pennsylvania | 42057 | 8 | 0 |
138329 | 138329 | 2020-05-12 | Fulton | Pennsylvania | 42057 | 8 | 0 |
141325 | 141325 | 2020-05-13 | Fulton | Pennsylvania | 42057 | 8 | 0 |
144321 | 144321 | 2020-05-14 | Fulton | Pennsylvania | 42057 | 11 | 0 |
147322 | 147322 | 2020-05-15 | Fulton | Pennsylvania | 42057 | 11 | 0 |
150329 | 150329 | 2020-05-16 | Fulton | Pennsylvania | 42057 | 11 | 0 |
153340 | 153340 | 2020-05-17 | Fulton | Pennsylvania | 42057 | 11 | 0 |
126370 | 126370 | 2020-05-08 | Fulton | Pennsylvania | 42057 | 7 | 1 |
156357 | 156357 | 2020-05-18 | Fulton | Pennsylvania | 42057 | 11 | 1 |
159378 | 159378 | 2020-05-19 | Fulton | Pennsylvania | 42057 | 12 | 1 |
162405 | 162405 | 2020-05-20 | Fulton | Pennsylvania | 42057 | 13 | 1 |
165434 | 165434 | 2020-05-21 | Fulton | Pennsylvania | 42057 | 14 | 1 |
168470 | 168470 | 2020-05-22 | Fulton | Pennsylvania | 42057 | 14 | 1 |
171509 | 171509 | 2020-05-23 | Fulton | Pennsylvania | 42057 | 14 | 1 |
174551 | 174551 | 2020-05-24 | Fulton | Pennsylvania | 42057 | 14 | 1 |
177595 | 177595 | 2020-05-25 | Fulton | Pennsylvania | 42057 | 14 | 1 |
180638 | 180638 | 2020-05-26 | Fulton | Pennsylvania | 42057 | 15 | 1 |
183688 | 183688 | 2020-05-27 | Fulton | Pennsylvania | 42057 | 15 | 1 |
186745 | 186745 | 2020-05-28 | Fulton | Pennsylvania | 42057 | 15 | 1 |
189806 | 189806 | 2020-05-29 | Fulton | Pennsylvania | 42057 | 15 | 1 |
192871 | 192871 | 2020-05-30 | Fulton | Pennsylvania | 42057 | 15 | 1 |
195940 | 195940 | 2020-05-31 | Fulton | Pennsylvania | 42057 | 15 | 1 |
199013 | 199013 | 2020-06-01 | Fulton | Pennsylvania | 42057 | 15 | 1 |
202088 | 202088 | 2020-06-02 | Fulton | Pennsylvania | 42057 | 15 | 1 |
205165 | 205165 | 2020-06-03 | Fulton | Pennsylvania | 42057 | 15 | 1 |
208246 | 208246 | 2020-06-04 | Fulton | Pennsylvania | 42057 | 16 | 1 |
211328 | 211328 | 2020-06-05 | Fulton | Pennsylvania | 42057 | 16 | 1 |
214414 | 214414 | 2020-06-06 | Fulton | Pennsylvania | 42057 | 16 | 1 |
217504 | 217504 | 2020-06-07 | Fulton | Pennsylvania | 42057 | 16 | 1 |
220596 | 220596 | 2020-06-08 | Fulton | Pennsylvania | 42057 | 16 | 1 |
223691 | 223691 | 2020-06-09 | Fulton | Pennsylvania | 42057 | 16 | 1 |
226791 | 226791 | 2020-06-10 | Fulton | Pennsylvania | 42057 | 16 | 1 |
229895 | 229895 | 2020-06-11 | Fulton | Pennsylvania | 42057 | 16 | 1 |
233000 | 233000 | 2020-06-12 | Fulton | Pennsylvania | 42057 | 16 | 1 |
236105 | 236105 | 2020-06-13 | Fulton | Pennsylvania | 42057 | 16 | 1 |
239213 | 239213 | 2020-06-14 | Fulton | Pennsylvania | 42057 | 16 | 1 |
242322 | 242322 | 2020-06-15 | Fulton | Pennsylvania | 42057 | 16 | 1 |
245434 | 245434 | 2020-06-16 | Fulton | Pennsylvania | 42057 | 17 | 1 |
248547 | 248547 | 2020-06-17 | Fulton | Pennsylvania | 42057 | 17 | 1 |
251662 | 251662 | 2020-06-18 | Fulton | Pennsylvania | 42057 | 17 | 1 |
254777 | 254777 | 2020-06-19 | Fulton | Pennsylvania | 42057 | 17 | 1 |
257903 | 257903 | 2020-06-20 | Fulton | Pennsylvania | 42057 | 18 | 1 |
261030 | 261030 | 2020-06-21 | Fulton | Pennsylvania | 42057 | 18 | 1 |
264158 | 264158 | 2020-06-22 | Fulton | Pennsylvania | 42057 | 18 | 1 |
267286 | 267286 | 2020-06-23 | Fulton | Pennsylvania | 42057 | 18 | 1 |
270420 | 270420 | 2020-06-24 | Fulton | Pennsylvania | 42057 | 18 | 1 |
273559 | 273559 | 2020-06-25 | Fulton | Pennsylvania | 42057 | 18 | 1 |
276706 | 276706 | 2020-06-26 | Fulton | Pennsylvania | 42057 | 18 | 1 |
279854 | 279854 | 2020-06-27 | Fulton | Pennsylvania | 42057 | 18 | 1 |
283000 | 283000 | 2020-06-28 | Fulton | Pennsylvania | 42057 | 18 | 1 |
286145 | 286145 | 2020-06-29 | Fulton | Pennsylvania | 42057 | 18 | 1 |
289296 | 289296 | 2020-06-30 | Fulton | Pennsylvania | 42057 | 18 | 1 |
292448 | 292448 | 2020-07-01 | Fulton | Pennsylvania | 42057 | 18 | 1 |
295604 | 295604 | 2020-07-02 | Fulton | Pennsylvania | 42057 | 18 | 1 |
298763 | 298763 | 2020-07-03 | Fulton | Pennsylvania | 42057 | 18 | 1 |
301927 | 301927 | 2020-07-04 | Fulton | Pennsylvania | 42057 | 18 | 1 |
305090 | 305090 | 2020-07-05 | Fulton | Pennsylvania | 42057 | 18 | 1 |
308257 | 308257 | 2020-07-06 | Fulton | Pennsylvania | 42057 | 18 | 1 |
311426 | 311426 | 2020-07-07 | Fulton | Pennsylvania | 42057 | 18 | 1 |
314598 | 314598 | 2020-07-08 | Fulton | Pennsylvania | 42057 | 18 | 1 |
317771 | 317771 | 2020-07-09 | Fulton | Pennsylvania | 42057 | 19 | 1 |
320949 | 320949 | 2020-07-10 | Fulton | Pennsylvania | 42057 | 19 | 1 |
324129 | 324129 | 2020-07-11 | Fulton | Pennsylvania | 42057 | 19 | 1 |
327314 | 327314 | 2020-07-12 | Fulton | Pennsylvania | 42057 | 19 | 1 |
330500 | 330500 | 2020-07-13 | Fulton | Pennsylvania | 42057 | 19 | 1 |
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);