ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Oneida" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420323 | 1420323 | 2021-06-14 | Oneida | Wisconsin | 55085 | 3815 | 77 |
1417078 | 1417078 | 2021-06-13 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1413832 | 1413832 | 2021-06-12 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1410587 | 1410587 | 2021-06-11 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1407342 | 1407342 | 2021-06-10 | Oneida | Wisconsin | 55085 | 3815 | 77 |
1404096 | 1404096 | 2021-06-09 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1400851 | 1400851 | 2021-06-08 | Oneida | Wisconsin | 55085 | 3815 | 77 |
1397606 | 1397606 | 2021-06-07 | Oneida | Wisconsin | 55085 | 3812 | 77 |
1394359 | 1394359 | 2021-06-06 | Oneida | Wisconsin | 55085 | 3812 | 77 |
1391114 | 1391114 | 2021-06-05 | Oneida | Wisconsin | 55085 | 3812 | 77 |
1387869 | 1387869 | 2021-06-04 | Oneida | Wisconsin | 55085 | 3812 | 77 |
1384624 | 1384624 | 2021-06-03 | Oneida | Wisconsin | 55085 | 3811 | 77 |
1381378 | 1381378 | 2021-06-02 | Oneida | Wisconsin | 55085 | 3812 | 77 |
1378133 | 1378133 | 2021-06-01 | Oneida | Wisconsin | 55085 | 3812 | 77 |
1374887 | 1374887 | 2021-05-31 | Oneida | Wisconsin | 55085 | 3812 | 77 |
1371642 | 1371642 | 2021-05-30 | Oneida | Wisconsin | 55085 | 3813 | 77 |
1368396 | 1368396 | 2021-05-29 | Oneida | Wisconsin | 55085 | 3813 | 77 |
1365150 | 1365150 | 2021-05-28 | Oneida | Wisconsin | 55085 | 3813 | 77 |
1361904 | 1361904 | 2021-05-27 | Oneida | Wisconsin | 55085 | 3811 | 77 |
1358658 | 1358658 | 2021-05-26 | Oneida | Wisconsin | 55085 | 3811 | 77 |
1355412 | 1355412 | 2021-05-25 | Oneida | Wisconsin | 55085 | 3810 | 77 |
1352166 | 1352166 | 2021-05-24 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1348920 | 1348920 | 2021-05-23 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1345672 | 1345672 | 2021-05-22 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1342424 | 1342424 | 2021-05-21 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1339176 | 1339176 | 2021-05-20 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1335929 | 1335929 | 2021-05-19 | Oneida | Wisconsin | 55085 | 3806 | 77 |
1332682 | 1332682 | 2021-05-18 | Oneida | Wisconsin | 55085 | 3804 | 77 |
1329435 | 1329435 | 2021-05-17 | Oneida | Wisconsin | 55085 | 3803 | 77 |
1326189 | 1326189 | 2021-05-16 | Oneida | Wisconsin | 55085 | 3798 | 77 |
1322943 | 1322943 | 2021-05-15 | Oneida | Wisconsin | 55085 | 3798 | 77 |
1319697 | 1319697 | 2021-05-14 | Oneida | Wisconsin | 55085 | 3797 | 77 |
1316449 | 1316449 | 2021-05-13 | Oneida | Wisconsin | 55085 | 3795 | 77 |
1313203 | 1313203 | 2021-05-12 | Oneida | Wisconsin | 55085 | 3791 | 77 |
1309956 | 1309956 | 2021-05-11 | Oneida | Wisconsin | 55085 | 3791 | 77 |
1306710 | 1306710 | 2021-05-10 | Oneida | Wisconsin | 55085 | 3790 | 77 |
1303464 | 1303464 | 2021-05-09 | Oneida | Wisconsin | 55085 | 3790 | 77 |
1300217 | 1300217 | 2021-05-08 | Oneida | Wisconsin | 55085 | 3789 | 77 |
1296970 | 1296970 | 2021-05-07 | Oneida | Wisconsin | 55085 | 3789 | 77 |
1293724 | 1293724 | 2021-05-06 | Oneida | Wisconsin | 55085 | 3786 | 75 |
1290478 | 1290478 | 2021-05-05 | Oneida | Wisconsin | 55085 | 3784 | 75 |
1287232 | 1287232 | 2021-05-04 | Oneida | Wisconsin | 55085 | 3783 | 75 |
1283986 | 1283986 | 2021-05-03 | Oneida | Wisconsin | 55085 | 3781 | 75 |
1280739 | 1280739 | 2021-05-02 | Oneida | Wisconsin | 55085 | 3778 | 75 |
1277492 | 1277492 | 2021-05-01 | Oneida | Wisconsin | 55085 | 3781 | 75 |
1274245 | 1274245 | 2021-04-30 | Oneida | Wisconsin | 55085 | 3778 | 75 |
1270998 | 1270998 | 2021-04-29 | Oneida | Wisconsin | 55085 | 3774 | 75 |
1267751 | 1267751 | 2021-04-28 | Oneida | Wisconsin | 55085 | 3768 | 75 |
1264504 | 1264504 | 2021-04-27 | Oneida | Wisconsin | 55085 | 3765 | 75 |
1261257 | 1261257 | 2021-04-26 | Oneida | Wisconsin | 55085 | 3763 | 74 |
1258010 | 1258010 | 2021-04-25 | Oneida | Wisconsin | 55085 | 3762 | 74 |
1254763 | 1254763 | 2021-04-24 | Oneida | Wisconsin | 55085 | 3758 | 74 |
1251516 | 1251516 | 2021-04-23 | Oneida | Wisconsin | 55085 | 3753 | 74 |
1248269 | 1248269 | 2021-04-22 | Oneida | Wisconsin | 55085 | 3746 | 74 |
1245022 | 1245022 | 2021-04-21 | Oneida | Wisconsin | 55085 | 3743 | 74 |
1241775 | 1241775 | 2021-04-20 | Oneida | Wisconsin | 55085 | 3732 | 74 |
1238528 | 1238528 | 2021-04-19 | Oneida | Wisconsin | 55085 | 3730 | 74 |
1235281 | 1235281 | 2021-04-18 | Oneida | Wisconsin | 55085 | 3727 | 74 |
1232033 | 1232033 | 2021-04-17 | Oneida | Wisconsin | 55085 | 3726 | 74 |
1228785 | 1228785 | 2021-04-16 | Oneida | Wisconsin | 55085 | 3715 | 74 |
1225537 | 1225537 | 2021-04-15 | Oneida | Wisconsin | 55085 | 3707 | 74 |
1222290 | 1222290 | 2021-04-14 | Oneida | Wisconsin | 55085 | 3705 | 74 |
1219042 | 1219042 | 2021-04-13 | Oneida | Wisconsin | 55085 | 3697 | 74 |
1215794 | 1215794 | 2021-04-12 | Oneida | Wisconsin | 55085 | 3694 | 74 |
1212547 | 1212547 | 2021-04-11 | Oneida | Wisconsin | 55085 | 3690 | 74 |
1209298 | 1209298 | 2021-04-10 | Oneida | Wisconsin | 55085 | 3687 | 74 |
1206050 | 1206050 | 2021-04-09 | Oneida | Wisconsin | 55085 | 3683 | 74 |
1202802 | 1202802 | 2021-04-08 | Oneida | Wisconsin | 55085 | 3678 | 74 |
1199554 | 1199554 | 2021-04-07 | Oneida | Wisconsin | 55085 | 3674 | 74 |
1196305 | 1196305 | 2021-04-06 | Oneida | Wisconsin | 55085 | 3668 | 74 |
1193057 | 1193057 | 2021-04-05 | Oneida | Wisconsin | 55085 | 3665 | 74 |
1189807 | 1189807 | 2021-04-04 | Oneida | Wisconsin | 55085 | 3665 | 74 |
1186560 | 1186560 | 2021-04-03 | Oneida | Wisconsin | 55085 | 3662 | 74 |
1183313 | 1183313 | 2021-04-02 | Oneida | Wisconsin | 55085 | 3661 | 74 |
1180066 | 1180066 | 2021-04-01 | Oneida | Wisconsin | 55085 | 3652 | 74 |
1176819 | 1176819 | 2021-03-31 | Oneida | Wisconsin | 55085 | 3647 | 74 |
1173572 | 1173572 | 2021-03-30 | Oneida | Wisconsin | 55085 | 3644 | 74 |
1170325 | 1170325 | 2021-03-29 | Oneida | Wisconsin | 55085 | 3643 | 74 |
1167077 | 1167077 | 2021-03-28 | Oneida | Wisconsin | 55085 | 3641 | 74 |
1163829 | 1163829 | 2021-03-27 | Oneida | Wisconsin | 55085 | 3636 | 74 |
1160581 | 1160581 | 2021-03-26 | Oneida | Wisconsin | 55085 | 3633 | 73 |
1157333 | 1157333 | 2021-03-25 | Oneida | Wisconsin | 55085 | 3622 | 73 |
1154086 | 1154086 | 2021-03-24 | Oneida | Wisconsin | 55085 | 3617 | 73 |
1150839 | 1150839 | 2021-03-23 | Oneida | Wisconsin | 55085 | 3609 | 73 |
1147592 | 1147592 | 2021-03-22 | Oneida | Wisconsin | 55085 | 3609 | 73 |
1144345 | 1144345 | 2021-03-21 | Oneida | Wisconsin | 55085 | 3604 | 73 |
1141098 | 1141098 | 2021-03-20 | Oneida | Wisconsin | 55085 | 3599 | 73 |
1137852 | 1137852 | 2021-03-19 | Oneida | Wisconsin | 55085 | 3597 | 73 |
1134606 | 1134606 | 2021-03-18 | Oneida | Wisconsin | 55085 | 3589 | 73 |
1131358 | 1131358 | 2021-03-17 | Oneida | Wisconsin | 55085 | 3586 | 73 |
1128111 | 1128111 | 2021-03-16 | Oneida | Wisconsin | 55085 | 3581 | 73 |
1124865 | 1124865 | 2021-03-15 | Oneida | Wisconsin | 55085 | 3579 | 73 |
1121619 | 1121619 | 2021-03-14 | Oneida | Wisconsin | 55085 | 3577 | 73 |
1118372 | 1118372 | 2021-03-13 | Oneida | Wisconsin | 55085 | 3576 | 73 |
1115125 | 1115125 | 2021-03-12 | Oneida | Wisconsin | 55085 | 3576 | 73 |
1111879 | 1111879 | 2021-03-11 | Oneida | Wisconsin | 55085 | 3570 | 73 |
1108633 | 1108633 | 2021-03-10 | Oneida | Wisconsin | 55085 | 3568 | 73 |
1105387 | 1105387 | 2021-03-09 | Oneida | Wisconsin | 55085 | 3561 | 73 |
1102141 | 1102141 | 2021-03-08 | Oneida | Wisconsin | 55085 | 3559 | 73 |
1098895 | 1098895 | 2021-03-07 | Oneida | Wisconsin | 55085 | 3556 | 73 |
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);