ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Monroe" and fips = 42089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
368928 | 368928 | 2020-07-25 | Monroe | Pennsylvania | 42089 | 1551 | 120 |
365719 | 365719 | 2020-07-24 | Monroe | Pennsylvania | 42089 | 1539 | 120 |
362513 | 362513 | 2020-07-23 | Monroe | Pennsylvania | 42089 | 1536 | 120 |
359307 | 359307 | 2020-07-22 | Monroe | Pennsylvania | 42089 | 1534 | 120 |
356103 | 356103 | 2020-07-21 | Monroe | Pennsylvania | 42089 | 1530 | 119 |
352900 | 352900 | 2020-07-20 | Monroe | Pennsylvania | 42089 | 1503 | 117 |
349697 | 349697 | 2020-07-19 | Monroe | Pennsylvania | 42089 | 1499 | 117 |
346497 | 346497 | 2020-07-18 | Monroe | Pennsylvania | 42089 | 1494 | 116 |
343297 | 343297 | 2020-07-17 | Monroe | Pennsylvania | 42089 | 1488 | 115 |
340099 | 340099 | 2020-07-16 | Monroe | Pennsylvania | 42089 | 1487 | 114 |
336902 | 336902 | 2020-07-15 | Monroe | Pennsylvania | 42089 | 1482 | 113 |
333708 | 333708 | 2020-07-14 | Monroe | Pennsylvania | 42089 | 1474 | 111 |
330516 | 330516 | 2020-07-13 | Monroe | Pennsylvania | 42089 | 1473 | 111 |
327330 | 327330 | 2020-07-12 | Monroe | Pennsylvania | 42089 | 1471 | 111 |
324145 | 324145 | 2020-07-11 | Monroe | Pennsylvania | 42089 | 1470 | 111 |
320965 | 320965 | 2020-07-10 | Monroe | Pennsylvania | 42089 | 1462 | 111 |
317787 | 317787 | 2020-07-09 | Monroe | Pennsylvania | 42089 | 1456 | 111 |
314614 | 314614 | 2020-07-08 | Monroe | Pennsylvania | 42089 | 1451 | 111 |
311442 | 311442 | 2020-07-07 | Monroe | Pennsylvania | 42089 | 1444 | 111 |
308273 | 308273 | 2020-07-06 | Monroe | Pennsylvania | 42089 | 1439 | 109 |
305106 | 305106 | 2020-07-05 | Monroe | Pennsylvania | 42089 | 1436 | 109 |
301943 | 301943 | 2020-07-04 | Monroe | Pennsylvania | 42089 | 1434 | 109 |
298779 | 298779 | 2020-07-03 | Monroe | Pennsylvania | 42089 | 1430 | 109 |
295620 | 295620 | 2020-07-02 | Monroe | Pennsylvania | 42089 | 1428 | 108 |
292464 | 292464 | 2020-07-01 | Monroe | Pennsylvania | 42089 | 1423 | 108 |
289312 | 289312 | 2020-06-30 | Monroe | Pennsylvania | 42089 | 1421 | 108 |
286161 | 286161 | 2020-06-29 | Monroe | Pennsylvania | 42089 | 1409 | 108 |
283016 | 283016 | 2020-06-28 | Monroe | Pennsylvania | 42089 | 1405 | 108 |
279870 | 279870 | 2020-06-27 | Monroe | Pennsylvania | 42089 | 1401 | 108 |
276722 | 276722 | 2020-06-26 | Monroe | Pennsylvania | 42089 | 1391 | 108 |
273575 | 273575 | 2020-06-25 | Monroe | Pennsylvania | 42089 | 1388 | 109 |
270436 | 270436 | 2020-06-24 | Monroe | Pennsylvania | 42089 | 1384 | 108 |
267302 | 267302 | 2020-06-23 | Monroe | Pennsylvania | 42089 | 1379 | 108 |
264174 | 264174 | 2020-06-22 | Monroe | Pennsylvania | 42089 | 1378 | 107 |
261046 | 261046 | 2020-06-21 | Monroe | Pennsylvania | 42089 | 1376 | 107 |
257919 | 257919 | 2020-06-20 | Monroe | Pennsylvania | 42089 | 1370 | 107 |
254793 | 254793 | 2020-06-19 | Monroe | Pennsylvania | 42089 | 1366 | 106 |
251678 | 251678 | 2020-06-18 | Monroe | Pennsylvania | 42089 | 1363 | 105 |
248563 | 248563 | 2020-06-17 | Monroe | Pennsylvania | 42089 | 1357 | 105 |
245450 | 245450 | 2020-06-16 | Monroe | Pennsylvania | 42089 | 1356 | 105 |
242338 | 242338 | 2020-06-15 | Monroe | Pennsylvania | 42089 | 1350 | 105 |
239229 | 239229 | 2020-06-14 | Monroe | Pennsylvania | 42089 | 1347 | 104 |
236121 | 236121 | 2020-06-13 | Monroe | Pennsylvania | 42089 | 1347 | 104 |
233016 | 233016 | 2020-06-12 | Monroe | Pennsylvania | 42089 | 1347 | 103 |
229911 | 229911 | 2020-06-11 | Monroe | Pennsylvania | 42089 | 1346 | 103 |
226807 | 226807 | 2020-06-10 | Monroe | Pennsylvania | 42089 | 1344 | 102 |
223707 | 223707 | 2020-06-09 | Monroe | Pennsylvania | 42089 | 1342 | 102 |
220612 | 220612 | 2020-06-08 | Monroe | Pennsylvania | 42089 | 1341 | 102 |
217520 | 217520 | 2020-06-07 | Monroe | Pennsylvania | 42089 | 1338 | 102 |
214430 | 214430 | 2020-06-06 | Monroe | Pennsylvania | 42089 | 1338 | 102 |
211344 | 211344 | 2020-06-05 | Monroe | Pennsylvania | 42089 | 1335 | 102 |
208262 | 208262 | 2020-06-04 | Monroe | Pennsylvania | 42089 | 1333 | 102 |
205181 | 205181 | 2020-06-03 | Monroe | Pennsylvania | 42089 | 1326 | 102 |
202104 | 202104 | 2020-06-02 | Monroe | Pennsylvania | 42089 | 1325 | 101 |
199029 | 199029 | 2020-06-01 | Monroe | Pennsylvania | 42089 | 1320 | 101 |
195956 | 195956 | 2020-05-31 | Monroe | Pennsylvania | 42089 | 1319 | 101 |
192887 | 192887 | 2020-05-30 | Monroe | Pennsylvania | 42089 | 1318 | 101 |
189822 | 189822 | 2020-05-29 | Monroe | Pennsylvania | 42089 | 1315 | 101 |
186761 | 186761 | 2020-05-28 | Monroe | Pennsylvania | 42089 | 1311 | 101 |
183704 | 183704 | 2020-05-27 | Monroe | Pennsylvania | 42089 | 1310 | 100 |
180654 | 180654 | 2020-05-26 | Monroe | Pennsylvania | 42089 | 1305 | 99 |
177611 | 177611 | 2020-05-25 | Monroe | Pennsylvania | 42089 | 1305 | 99 |
174567 | 174567 | 2020-05-24 | Monroe | Pennsylvania | 42089 | 1304 | 99 |
171525 | 171525 | 2020-05-23 | Monroe | Pennsylvania | 42089 | 1302 | 99 |
168486 | 168486 | 2020-05-22 | Monroe | Pennsylvania | 42089 | 1295 | 97 |
165450 | 165450 | 2020-05-21 | Monroe | Pennsylvania | 42089 | 1291 | 95 |
162421 | 162421 | 2020-05-20 | Monroe | Pennsylvania | 42089 | 1278 | 93 |
159394 | 159394 | 2020-05-19 | Monroe | Pennsylvania | 42089 | 1267 | 89 |
156373 | 156373 | 2020-05-18 | Monroe | Pennsylvania | 42089 | 1259 | 88 |
153356 | 153356 | 2020-05-17 | Monroe | Pennsylvania | 42089 | 1254 | 70 |
150345 | 150345 | 2020-05-16 | Monroe | Pennsylvania | 42089 | 1248 | 70 |
147338 | 147338 | 2020-05-15 | Monroe | Pennsylvania | 42089 | 1242 | 70 |
144337 | 144337 | 2020-05-14 | Monroe | Pennsylvania | 42089 | 1240 | 69 |
141341 | 141341 | 2020-05-13 | Monroe | Pennsylvania | 42089 | 1228 | 65 |
138345 | 138345 | 2020-05-12 | Monroe | Pennsylvania | 42089 | 1229 | 64 |
135355 | 135355 | 2020-05-11 | Monroe | Pennsylvania | 42089 | 1224 | 64 |
132364 | 132364 | 2020-05-10 | Monroe | Pennsylvania | 42089 | 1218 | 64 |
129375 | 129375 | 2020-05-09 | Monroe | Pennsylvania | 42089 | 1206 | 63 |
126386 | 126386 | 2020-05-08 | Monroe | Pennsylvania | 42089 | 1198 | 63 |
123403 | 123403 | 2020-05-07 | Monroe | Pennsylvania | 42089 | 1194 | 63 |
120426 | 120426 | 2020-05-06 | Monroe | Pennsylvania | 42089 | 1190 | 60 |
117464 | 117464 | 2020-05-05 | Monroe | Pennsylvania | 42089 | 1186 | 60 |
114583 | 114583 | 2020-05-04 | Monroe | Pennsylvania | 42089 | 1173 | 55 |
111701 | 111701 | 2020-05-03 | Monroe | Pennsylvania | 42089 | 1172 | 55 |
108827 | 108827 | 2020-05-02 | Monroe | Pennsylvania | 42089 | 1165 | 55 |
105960 | 105960 | 2020-05-01 | Monroe | Pennsylvania | 42089 | 1147 | 54 |
103097 | 103097 | 2020-04-30 | Monroe | Pennsylvania | 42089 | 1127 | 54 |
100244 | 100244 | 2020-04-29 | Monroe | Pennsylvania | 42089 | 1111 | 54 |
97395 | 97395 | 2020-04-28 | Monroe | Pennsylvania | 42089 | 1097 | 48 |
94556 | 94556 | 2020-04-27 | Monroe | Pennsylvania | 42089 | 1083 | 46 |
91729 | 91729 | 2020-04-26 | Monroe | Pennsylvania | 42089 | 1065 | 46 |
88913 | 88913 | 2020-04-25 | Monroe | Pennsylvania | 42089 | 1054 | 46 |
86099 | 86099 | 2020-04-24 | Monroe | Pennsylvania | 42089 | 1037 | 46 |
83295 | 83295 | 2020-04-23 | Monroe | Pennsylvania | 42089 | 1024 | 46 |
80496 | 80496 | 2020-04-22 | Monroe | Pennsylvania | 42089 | 1015 | 48 |
77706 | 77706 | 2020-04-21 | Monroe | Pennsylvania | 42089 | 995 | 46 |
74924 | 74924 | 2020-04-20 | Monroe | Pennsylvania | 42089 | 970 | 39 |
72149 | 72149 | 2020-04-19 | Monroe | Pennsylvania | 42089 | 963 | 38 |
69382 | 69382 | 2020-04-18 | Monroe | Pennsylvania | 42089 | 943 | 34 |
66624 | 66624 | 2020-04-17 | Monroe | Pennsylvania | 42089 | 929 | 29 |
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);