ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42133 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388243 | 388243 | 2020-07-31 | York | Pennsylvania | 42133 | 2269 | 86 |
385026 | 385026 | 2020-07-30 | York | Pennsylvania | 42133 | 2243 | 85 |
381808 | 381808 | 2020-07-29 | York | Pennsylvania | 42133 | 2223 | 84 |
378591 | 378591 | 2020-07-28 | York | Pennsylvania | 42133 | 2196 | 84 |
375375 | 375375 | 2020-07-27 | York | Pennsylvania | 42133 | 2182 | 81 |
372162 | 372162 | 2020-07-26 | York | Pennsylvania | 42133 | 2161 | 80 |
368950 | 368950 | 2020-07-25 | York | Pennsylvania | 42133 | 2152 | 80 |
365741 | 365741 | 2020-07-24 | York | Pennsylvania | 42133 | 2119 | 79 |
362535 | 362535 | 2020-07-23 | York | Pennsylvania | 42133 | 2098 | 78 |
359329 | 359329 | 2020-07-22 | York | Pennsylvania | 42133 | 2067 | 76 |
356125 | 356125 | 2020-07-21 | York | Pennsylvania | 42133 | 2052 | 74 |
352922 | 352922 | 2020-07-20 | York | Pennsylvania | 42133 | 2006 | 72 |
349719 | 349719 | 2020-07-19 | York | Pennsylvania | 42133 | 1985 | 72 |
346519 | 346519 | 2020-07-18 | York | Pennsylvania | 42133 | 1975 | 72 |
343319 | 343319 | 2020-07-17 | York | Pennsylvania | 42133 | 1963 | 70 |
340121 | 340121 | 2020-07-16 | York | Pennsylvania | 42133 | 1942 | 67 |
336924 | 336924 | 2020-07-15 | York | Pennsylvania | 42133 | 1908 | 66 |
333730 | 333730 | 2020-07-14 | York | Pennsylvania | 42133 | 1872 | 63 |
330538 | 330538 | 2020-07-13 | York | Pennsylvania | 42133 | 1858 | 63 |
327352 | 327352 | 2020-07-12 | York | Pennsylvania | 42133 | 1850 | 63 |
324167 | 324167 | 2020-07-11 | York | Pennsylvania | 42133 | 1830 | 62 |
320987 | 320987 | 2020-07-10 | York | Pennsylvania | 42133 | 1791 | 61 |
317809 | 317809 | 2020-07-09 | York | Pennsylvania | 42133 | 1714 | 57 |
314636 | 314636 | 2020-07-08 | York | Pennsylvania | 42133 | 1692 | 57 |
311464 | 311464 | 2020-07-07 | York | Pennsylvania | 42133 | 1654 | 55 |
308295 | 308295 | 2020-07-06 | York | Pennsylvania | 42133 | 1613 | 54 |
305128 | 305128 | 2020-07-05 | York | Pennsylvania | 42133 | 1609 | 54 |
301965 | 301965 | 2020-07-04 | York | Pennsylvania | 42133 | 1595 | 54 |
298801 | 298801 | 2020-07-03 | York | Pennsylvania | 42133 | 1577 | 54 |
295642 | 295642 | 2020-07-02 | York | Pennsylvania | 42133 | 1555 | 52 |
292486 | 292486 | 2020-07-01 | York | Pennsylvania | 42133 | 1531 | 48 |
289334 | 289334 | 2020-06-30 | York | Pennsylvania | 42133 | 1515 | 48 |
286183 | 286183 | 2020-06-29 | York | Pennsylvania | 42133 | 1477 | 45 |
283038 | 283038 | 2020-06-28 | York | Pennsylvania | 42133 | 1456 | 44 |
279892 | 279892 | 2020-06-27 | York | Pennsylvania | 42133 | 1443 | 44 |
276744 | 276744 | 2020-06-26 | York | Pennsylvania | 42133 | 1428 | 43 |
273597 | 273597 | 2020-06-25 | York | Pennsylvania | 42133 | 1418 | 41 |
270458 | 270458 | 2020-06-24 | York | Pennsylvania | 42133 | 1400 | 40 |
267324 | 267324 | 2020-06-23 | York | Pennsylvania | 42133 | 1381 | 39 |
264196 | 264196 | 2020-06-22 | York | Pennsylvania | 42133 | 1351 | 36 |
261068 | 261068 | 2020-06-21 | York | Pennsylvania | 42133 | 1296 | 36 |
257941 | 257941 | 2020-06-20 | York | Pennsylvania | 42133 | 1255 | 36 |
254815 | 254815 | 2020-06-19 | York | Pennsylvania | 42133 | 1229 | 35 |
251700 | 251700 | 2020-06-18 | York | Pennsylvania | 42133 | 1209 | 35 |
248585 | 248585 | 2020-06-17 | York | Pennsylvania | 42133 | 1195 | 34 |
245472 | 245472 | 2020-06-16 | York | Pennsylvania | 42133 | 1183 | 32 |
242360 | 242360 | 2020-06-15 | York | Pennsylvania | 42133 | 1169 | 32 |
239251 | 239251 | 2020-06-14 | York | Pennsylvania | 42133 | 1162 | 31 |
236143 | 236143 | 2020-06-13 | York | Pennsylvania | 42133 | 1157 | 31 |
233038 | 233038 | 2020-06-12 | York | Pennsylvania | 42133 | 1141 | 31 |
229933 | 229933 | 2020-06-11 | York | Pennsylvania | 42133 | 1117 | 31 |
226829 | 226829 | 2020-06-10 | York | Pennsylvania | 42133 | 1102 | 30 |
223729 | 223729 | 2020-06-09 | York | Pennsylvania | 42133 | 1094 | 30 |
220634 | 220634 | 2020-06-08 | York | Pennsylvania | 42133 | 1086 | 29 |
217542 | 217542 | 2020-06-07 | York | Pennsylvania | 42133 | 1082 | 29 |
214452 | 214452 | 2020-06-06 | York | Pennsylvania | 42133 | 1049 | 29 |
211366 | 211366 | 2020-06-05 | York | Pennsylvania | 42133 | 1040 | 28 |
208284 | 208284 | 2020-06-04 | York | Pennsylvania | 42133 | 1038 | 28 |
205203 | 205203 | 2020-06-03 | York | Pennsylvania | 42133 | 1037 | 27 |
202126 | 202126 | 2020-06-02 | York | Pennsylvania | 42133 | 1028 | 26 |
199051 | 199051 | 2020-06-01 | York | Pennsylvania | 42133 | 1013 | 26 |
195978 | 195978 | 2020-05-31 | York | Pennsylvania | 42133 | 1007 | 26 |
192909 | 192909 | 2020-05-30 | York | Pennsylvania | 42133 | 1000 | 26 |
189844 | 189844 | 2020-05-29 | York | Pennsylvania | 42133 | 991 | 26 |
186783 | 186783 | 2020-05-28 | York | Pennsylvania | 42133 | 970 | 25 |
183726 | 183726 | 2020-05-27 | York | Pennsylvania | 42133 | 956 | 22 |
180676 | 180676 | 2020-05-26 | York | Pennsylvania | 42133 | 943 | 22 |
177633 | 177633 | 2020-05-25 | York | Pennsylvania | 42133 | 930 | 22 |
174589 | 174589 | 2020-05-24 | York | Pennsylvania | 42133 | 924 | 22 |
171547 | 171547 | 2020-05-23 | York | Pennsylvania | 42133 | 904 | 22 |
168508 | 168508 | 2020-05-22 | York | Pennsylvania | 42133 | 895 | 22 |
165472 | 165472 | 2020-05-21 | York | Pennsylvania | 42133 | 883 | 21 |
162443 | 162443 | 2020-05-20 | York | Pennsylvania | 42133 | 872 | 19 |
159416 | 159416 | 2020-05-19 | York | Pennsylvania | 42133 | 866 | 18 |
156395 | 156395 | 2020-05-18 | York | Pennsylvania | 42133 | 857 | 18 |
153378 | 153378 | 2020-05-17 | York | Pennsylvania | 42133 | 851 | 16 |
150367 | 150367 | 2020-05-16 | York | Pennsylvania | 42133 | 835 | 15 |
147360 | 147360 | 2020-05-15 | York | Pennsylvania | 42133 | 828 | 16 |
144359 | 144359 | 2020-05-14 | York | Pennsylvania | 42133 | 817 | 15 |
141363 | 141363 | 2020-05-13 | York | Pennsylvania | 42133 | 803 | 14 |
138367 | 138367 | 2020-05-12 | York | Pennsylvania | 42133 | 793 | 14 |
135377 | 135377 | 2020-05-11 | York | Pennsylvania | 42133 | 784 | 13 |
132386 | 132386 | 2020-05-10 | York | Pennsylvania | 42133 | 773 | 13 |
129397 | 129397 | 2020-05-09 | York | Pennsylvania | 42133 | 767 | 13 |
126408 | 126408 | 2020-05-08 | York | Pennsylvania | 42133 | 753 | 13 |
123425 | 123425 | 2020-05-07 | York | Pennsylvania | 42133 | 740 | 13 |
120448 | 120448 | 2020-05-06 | York | Pennsylvania | 42133 | 722 | 13 |
117486 | 117486 | 2020-05-05 | York | Pennsylvania | 42133 | 716 | 13 |
114605 | 114605 | 2020-05-04 | York | Pennsylvania | 42133 | 702 | 13 |
111723 | 111723 | 2020-05-03 | York | Pennsylvania | 42133 | 679 | 13 |
108849 | 108849 | 2020-05-02 | York | Pennsylvania | 42133 | 664 | 13 |
105982 | 105982 | 2020-05-01 | York | Pennsylvania | 42133 | 651 | 13 |
103119 | 103119 | 2020-04-30 | York | Pennsylvania | 42133 | 641 | 13 |
100266 | 100266 | 2020-04-29 | York | Pennsylvania | 42133 | 624 | 13 |
97417 | 97417 | 2020-04-28 | York | Pennsylvania | 42133 | 614 | 13 |
94578 | 94578 | 2020-04-27 | York | Pennsylvania | 42133 | 606 | 13 |
91751 | 91751 | 2020-04-26 | York | Pennsylvania | 42133 | 593 | 13 |
88935 | 88935 | 2020-04-25 | York | Pennsylvania | 42133 | 578 | 13 |
86121 | 86121 | 2020-04-24 | York | Pennsylvania | 42133 | 563 | 13 |
83317 | 83317 | 2020-04-23 | York | Pennsylvania | 42133 | 546 | 13 |
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);