ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Wayne" and fips = 42127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388240 | 388240 | 2020-07-31 | Wayne | Pennsylvania | 42127 | 158 | 8 |
385023 | 385023 | 2020-07-30 | Wayne | Pennsylvania | 42127 | 157 | 8 |
381805 | 381805 | 2020-07-29 | Wayne | Pennsylvania | 42127 | 156 | 8 |
378588 | 378588 | 2020-07-28 | Wayne | Pennsylvania | 42127 | 154 | 8 |
375372 | 375372 | 2020-07-27 | Wayne | Pennsylvania | 42127 | 154 | 8 |
372159 | 372159 | 2020-07-26 | Wayne | Pennsylvania | 42127 | 153 | 8 |
368947 | 368947 | 2020-07-25 | Wayne | Pennsylvania | 42127 | 152 | 8 |
365738 | 365738 | 2020-07-24 | Wayne | Pennsylvania | 42127 | 151 | 8 |
362532 | 362532 | 2020-07-23 | Wayne | Pennsylvania | 42127 | 151 | 8 |
359326 | 359326 | 2020-07-22 | Wayne | Pennsylvania | 42127 | 148 | 8 |
356122 | 356122 | 2020-07-21 | Wayne | Pennsylvania | 42127 | 149 | 8 |
352919 | 352919 | 2020-07-20 | Wayne | Pennsylvania | 42127 | 149 | 8 |
349716 | 349716 | 2020-07-19 | Wayne | Pennsylvania | 42127 | 148 | 8 |
346516 | 346516 | 2020-07-18 | Wayne | Pennsylvania | 42127 | 148 | 8 |
343316 | 343316 | 2020-07-17 | Wayne | Pennsylvania | 42127 | 148 | 8 |
340118 | 340118 | 2020-07-16 | Wayne | Pennsylvania | 42127 | 144 | 8 |
336921 | 336921 | 2020-07-15 | Wayne | Pennsylvania | 42127 | 143 | 8 |
333727 | 333727 | 2020-07-14 | Wayne | Pennsylvania | 42127 | 141 | 8 |
330535 | 330535 | 2020-07-13 | Wayne | Pennsylvania | 42127 | 141 | 8 |
327349 | 327349 | 2020-07-12 | Wayne | Pennsylvania | 42127 | 141 | 8 |
324164 | 324164 | 2020-07-11 | Wayne | Pennsylvania | 42127 | 141 | 8 |
320984 | 320984 | 2020-07-10 | Wayne | Pennsylvania | 42127 | 141 | 8 |
317806 | 317806 | 2020-07-09 | Wayne | Pennsylvania | 42127 | 141 | 8 |
314633 | 314633 | 2020-07-08 | Wayne | Pennsylvania | 42127 | 141 | 8 |
311461 | 311461 | 2020-07-07 | Wayne | Pennsylvania | 42127 | 141 | 9 |
308292 | 308292 | 2020-07-06 | Wayne | Pennsylvania | 42127 | 141 | 9 |
305125 | 305125 | 2020-07-05 | Wayne | Pennsylvania | 42127 | 141 | 9 |
301962 | 301962 | 2020-07-04 | Wayne | Pennsylvania | 42127 | 141 | 9 |
298798 | 298798 | 2020-07-03 | Wayne | Pennsylvania | 42127 | 142 | 9 |
295639 | 295639 | 2020-07-02 | Wayne | Pennsylvania | 42127 | 140 | 9 |
292483 | 292483 | 2020-07-01 | Wayne | Pennsylvania | 42127 | 140 | 9 |
289331 | 289331 | 2020-06-30 | Wayne | Pennsylvania | 42127 | 140 | 9 |
286180 | 286180 | 2020-06-29 | Wayne | Pennsylvania | 42127 | 139 | 9 |
283035 | 283035 | 2020-06-28 | Wayne | Pennsylvania | 42127 | 139 | 9 |
279889 | 279889 | 2020-06-27 | Wayne | Pennsylvania | 42127 | 138 | 9 |
276741 | 276741 | 2020-06-26 | Wayne | Pennsylvania | 42127 | 138 | 9 |
273594 | 273594 | 2020-06-25 | Wayne | Pennsylvania | 42127 | 133 | 9 |
270455 | 270455 | 2020-06-24 | Wayne | Pennsylvania | 42127 | 131 | 9 |
267321 | 267321 | 2020-06-23 | Wayne | Pennsylvania | 42127 | 131 | 9 |
264193 | 264193 | 2020-06-22 | Wayne | Pennsylvania | 42127 | 130 | 9 |
261065 | 261065 | 2020-06-21 | Wayne | Pennsylvania | 42127 | 130 | 9 |
257938 | 257938 | 2020-06-20 | Wayne | Pennsylvania | 42127 | 130 | 9 |
254812 | 254812 | 2020-06-19 | Wayne | Pennsylvania | 42127 | 129 | 9 |
251697 | 251697 | 2020-06-18 | Wayne | Pennsylvania | 42127 | 128 | 9 |
248582 | 248582 | 2020-06-17 | Wayne | Pennsylvania | 42127 | 126 | 9 |
245469 | 245469 | 2020-06-16 | Wayne | Pennsylvania | 42127 | 126 | 9 |
242357 | 242357 | 2020-06-15 | Wayne | Pennsylvania | 42127 | 126 | 9 |
239248 | 239248 | 2020-06-14 | Wayne | Pennsylvania | 42127 | 126 | 9 |
236140 | 236140 | 2020-06-13 | Wayne | Pennsylvania | 42127 | 126 | 9 |
233035 | 233035 | 2020-06-12 | Wayne | Pennsylvania | 42127 | 125 | 9 |
229930 | 229930 | 2020-06-11 | Wayne | Pennsylvania | 42127 | 125 | 9 |
226826 | 226826 | 2020-06-10 | Wayne | Pennsylvania | 42127 | 123 | 9 |
223726 | 223726 | 2020-06-09 | Wayne | Pennsylvania | 42127 | 124 | 9 |
220631 | 220631 | 2020-06-08 | Wayne | Pennsylvania | 42127 | 124 | 9 |
217539 | 217539 | 2020-06-07 | Wayne | Pennsylvania | 42127 | 126 | 9 |
214449 | 214449 | 2020-06-06 | Wayne | Pennsylvania | 42127 | 123 | 9 |
211363 | 211363 | 2020-06-05 | Wayne | Pennsylvania | 42127 | 123 | 9 |
208281 | 208281 | 2020-06-04 | Wayne | Pennsylvania | 42127 | 121 | 8 |
205200 | 205200 | 2020-06-03 | Wayne | Pennsylvania | 42127 | 120 | 8 |
202123 | 202123 | 2020-06-02 | Wayne | Pennsylvania | 42127 | 120 | 8 |
199048 | 199048 | 2020-06-01 | Wayne | Pennsylvania | 42127 | 120 | 8 |
195975 | 195975 | 2020-05-31 | Wayne | Pennsylvania | 42127 | 119 | 8 |
192906 | 192906 | 2020-05-30 | Wayne | Pennsylvania | 42127 | 119 | 8 |
189841 | 189841 | 2020-05-29 | Wayne | Pennsylvania | 42127 | 119 | 7 |
186780 | 186780 | 2020-05-28 | Wayne | Pennsylvania | 42127 | 118 | 7 |
183723 | 183723 | 2020-05-27 | Wayne | Pennsylvania | 42127 | 118 | 7 |
180673 | 180673 | 2020-05-26 | Wayne | Pennsylvania | 42127 | 118 | 7 |
177630 | 177630 | 2020-05-25 | Wayne | Pennsylvania | 42127 | 118 | 7 |
174586 | 174586 | 2020-05-24 | Wayne | Pennsylvania | 42127 | 117 | 7 |
171544 | 171544 | 2020-05-23 | Wayne | Pennsylvania | 42127 | 117 | 7 |
168505 | 168505 | 2020-05-22 | Wayne | Pennsylvania | 42127 | 115 | 6 |
165469 | 165469 | 2020-05-21 | Wayne | Pennsylvania | 42127 | 112 | 7 |
162440 | 162440 | 2020-05-20 | Wayne | Pennsylvania | 42127 | 110 | 7 |
159413 | 159413 | 2020-05-19 | Wayne | Pennsylvania | 42127 | 110 | 7 |
156392 | 156392 | 2020-05-18 | Wayne | Pennsylvania | 42127 | 108 | 7 |
153375 | 153375 | 2020-05-17 | Wayne | Pennsylvania | 42127 | 108 | 7 |
150364 | 150364 | 2020-05-16 | Wayne | Pennsylvania | 42127 | 108 | 7 |
147357 | 147357 | 2020-05-15 | Wayne | Pennsylvania | 42127 | 107 | 7 |
144356 | 144356 | 2020-05-14 | Wayne | Pennsylvania | 42127 | 107 | 5 |
141360 | 141360 | 2020-05-13 | Wayne | Pennsylvania | 42127 | 107 | 5 |
138364 | 138364 | 2020-05-12 | Wayne | Pennsylvania | 42127 | 117 | 5 |
135374 | 135374 | 2020-05-11 | Wayne | Pennsylvania | 42127 | 117 | 5 |
132383 | 132383 | 2020-05-10 | Wayne | Pennsylvania | 42127 | 117 | 5 |
129394 | 129394 | 2020-05-09 | Wayne | Pennsylvania | 42127 | 116 | 5 |
126405 | 126405 | 2020-05-08 | Wayne | Pennsylvania | 42127 | 113 | 5 |
123422 | 123422 | 2020-05-07 | Wayne | Pennsylvania | 42127 | 113 | 5 |
120445 | 120445 | 2020-05-06 | Wayne | Pennsylvania | 42127 | 110 | 5 |
117483 | 117483 | 2020-05-05 | Wayne | Pennsylvania | 42127 | 109 | 5 |
114602 | 114602 | 2020-05-04 | Wayne | Pennsylvania | 42127 | 109 | 5 |
111720 | 111720 | 2020-05-03 | Wayne | Pennsylvania | 42127 | 109 | 5 |
108846 | 108846 | 2020-05-02 | Wayne | Pennsylvania | 42127 | 104 | 5 |
105979 | 105979 | 2020-05-01 | Wayne | Pennsylvania | 42127 | 102 | 5 |
103116 | 103116 | 2020-04-30 | Wayne | Pennsylvania | 42127 | 100 | 5 |
100263 | 100263 | 2020-04-29 | Wayne | Pennsylvania | 42127 | 95 | 5 |
97414 | 97414 | 2020-04-28 | Wayne | Pennsylvania | 42127 | 93 | 3 |
94575 | 94575 | 2020-04-27 | Wayne | Pennsylvania | 42127 | 93 | 3 |
91748 | 91748 | 2020-04-26 | Wayne | Pennsylvania | 42127 | 92 | 3 |
88932 | 88932 | 2020-04-25 | Wayne | Pennsylvania | 42127 | 92 | 3 |
86118 | 86118 | 2020-04-24 | Wayne | Pennsylvania | 42127 | 88 | 3 |
83314 | 83314 | 2020-04-23 | Wayne | Pennsylvania | 42127 | 87 | 3 |
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);