ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where county = "Greene", deaths = 34 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1472335 | 1472335 | 2021-07-01 | Greene | Alabama | 1063 | 937 | 34 |
1469090 | 1469090 | 2021-06-30 | Greene | Alabama | 1063 | 937 | 34 |
1465845 | 1465845 | 2021-06-29 | Greene | Alabama | 1063 | 937 | 34 |
1462600 | 1462600 | 2021-06-28 | Greene | Alabama | 1063 | 937 | 34 |
1459355 | 1459355 | 2021-06-27 | Greene | Alabama | 1063 | 937 | 34 |
1456110 | 1456110 | 2021-06-26 | Greene | Alabama | 1063 | 937 | 34 |
1452865 | 1452865 | 2021-06-25 | Greene | Alabama | 1063 | 937 | 34 |
1449619 | 1449619 | 2021-06-24 | Greene | Alabama | 1063 | 937 | 34 |
1446374 | 1446374 | 2021-06-23 | Greene | Alabama | 1063 | 937 | 34 |
1443129 | 1443129 | 2021-06-22 | Greene | Alabama | 1063 | 936 | 34 |
1439884 | 1439884 | 2021-06-21 | Greene | Alabama | 1063 | 936 | 34 |
1436637 | 1436637 | 2021-06-20 | Greene | Alabama | 1063 | 936 | 34 |
1433390 | 1433390 | 2021-06-19 | Greene | Alabama | 1063 | 936 | 34 |
1430144 | 1430144 | 2021-06-18 | Greene | Alabama | 1063 | 936 | 34 |
1426899 | 1426899 | 2021-06-17 | Greene | Alabama | 1063 | 935 | 34 |
1423653 | 1423653 | 2021-06-16 | Greene | Alabama | 1063 | 935 | 34 |
1420406 | 1420406 | 2021-06-15 | Greene | Alabama | 1063 | 934 | 34 |
1417161 | 1417161 | 2021-06-14 | Greene | Alabama | 1063 | 934 | 34 |
1413915 | 1413915 | 2021-06-13 | Greene | Alabama | 1063 | 934 | 34 |
1410670 | 1410670 | 2021-06-12 | Greene | Alabama | 1063 | 934 | 34 |
1407425 | 1407425 | 2021-06-11 | Greene | Alabama | 1063 | 934 | 34 |
1404179 | 1404179 | 2021-06-10 | Greene | Alabama | 1063 | 934 | 34 |
1400934 | 1400934 | 2021-06-09 | Greene | Alabama | 1063 | 934 | 34 |
1397689 | 1397689 | 2021-06-08 | Greene | Alabama | 1063 | 933 | 34 |
1394442 | 1394442 | 2021-06-07 | Greene | Alabama | 1063 | 932 | 34 |
1391197 | 1391197 | 2021-06-06 | Greene | Alabama | 1063 | 932 | 34 |
1387952 | 1387952 | 2021-06-05 | Greene | Alabama | 1063 | 932 | 34 |
1384707 | 1384707 | 2021-06-04 | Greene | Alabama | 1063 | 932 | 34 |
1381461 | 1381461 | 2021-06-03 | Greene | Alabama | 1063 | 931 | 34 |
1378216 | 1378216 | 2021-06-02 | Greene | Alabama | 1063 | 931 | 34 |
1374970 | 1374970 | 2021-06-01 | Greene | Alabama | 1063 | 930 | 34 |
1371725 | 1371725 | 2021-05-31 | Greene | Alabama | 1063 | 928 | 34 |
1368479 | 1368479 | 2021-05-30 | Greene | Alabama | 1063 | 928 | 34 |
1365233 | 1365233 | 2021-05-29 | Greene | Alabama | 1063 | 928 | 34 |
1361987 | 1361987 | 2021-05-28 | Greene | Alabama | 1063 | 928 | 34 |
1358741 | 1358741 | 2021-05-27 | Greene | Alabama | 1063 | 928 | 34 |
1355495 | 1355495 | 2021-05-26 | Greene | Alabama | 1063 | 928 | 34 |
1352249 | 1352249 | 2021-05-25 | Greene | Alabama | 1063 | 927 | 34 |
1349003 | 1349003 | 2021-05-24 | Greene | Alabama | 1063 | 927 | 34 |
1345755 | 1345755 | 2021-05-23 | Greene | Alabama | 1063 | 927 | 34 |
1342507 | 1342507 | 2021-05-22 | Greene | Alabama | 1063 | 927 | 34 |
1339259 | 1339259 | 2021-05-21 | Greene | Alabama | 1063 | 926 | 34 |
1336012 | 1336012 | 2021-05-20 | Greene | Alabama | 1063 | 926 | 34 |
1332765 | 1332765 | 2021-05-19 | Greene | Alabama | 1063 | 926 | 34 |
1329518 | 1329518 | 2021-05-18 | Greene | Alabama | 1063 | 926 | 34 |
1326272 | 1326272 | 2021-05-17 | Greene | Alabama | 1063 | 926 | 34 |
1323026 | 1323026 | 2021-05-16 | Greene | Alabama | 1063 | 926 | 34 |
1319780 | 1319780 | 2021-05-15 | Greene | Alabama | 1063 | 926 | 34 |
1316532 | 1316532 | 2021-05-14 | Greene | Alabama | 1063 | 926 | 34 |
1313286 | 1313286 | 2021-05-13 | Greene | Alabama | 1063 | 925 | 34 |
1310039 | 1310039 | 2021-05-12 | Greene | Alabama | 1063 | 925 | 34 |
1306793 | 1306793 | 2021-05-11 | Greene | Alabama | 1063 | 925 | 34 |
1303547 | 1303547 | 2021-05-10 | Greene | Alabama | 1063 | 923 | 34 |
1300300 | 1300300 | 2021-05-09 | Greene | Alabama | 1063 | 923 | 34 |
1297053 | 1297053 | 2021-05-08 | Greene | Alabama | 1063 | 923 | 34 |
1293807 | 1293807 | 2021-05-07 | Greene | Alabama | 1063 | 923 | 34 |
1290561 | 1290561 | 2021-05-06 | Greene | Alabama | 1063 | 923 | 34 |
1287315 | 1287315 | 2021-05-05 | Greene | Alabama | 1063 | 923 | 34 |
1284069 | 1284069 | 2021-05-04 | Greene | Alabama | 1063 | 922 | 34 |
1280822 | 1280822 | 2021-05-03 | Greene | Alabama | 1063 | 922 | 34 |
1277575 | 1277575 | 2021-05-02 | Greene | Alabama | 1063 | 922 | 34 |
1274328 | 1274328 | 2021-05-01 | Greene | Alabama | 1063 | 922 | 34 |
1271081 | 1271081 | 2021-04-30 | Greene | Alabama | 1063 | 921 | 34 |
1267834 | 1267834 | 2021-04-29 | Greene | Alabama | 1063 | 921 | 34 |
1264587 | 1264587 | 2021-04-28 | Greene | Alabama | 1063 | 921 | 34 |
1261340 | 1261340 | 2021-04-27 | Greene | Alabama | 1063 | 920 | 34 |
1258093 | 1258093 | 2021-04-26 | Greene | Alabama | 1063 | 920 | 34 |
1254846 | 1254846 | 2021-04-25 | Greene | Alabama | 1063 | 920 | 34 |
1251599 | 1251599 | 2021-04-24 | Greene | Alabama | 1063 | 920 | 34 |
1248352 | 1248352 | 2021-04-23 | Greene | Alabama | 1063 | 916 | 34 |
1245105 | 1245105 | 2021-04-22 | Greene | Alabama | 1063 | 915 | 34 |
1241858 | 1241858 | 2021-04-21 | Greene | Alabama | 1063 | 915 | 34 |
1238611 | 1238611 | 2021-04-20 | Greene | Alabama | 1063 | 914 | 34 |
1235364 | 1235364 | 2021-04-19 | Greene | Alabama | 1063 | 914 | 34 |
1232116 | 1232116 | 2021-04-18 | Greene | Alabama | 1063 | 914 | 34 |
1228868 | 1228868 | 2021-04-17 | Greene | Alabama | 1063 | 914 | 34 |
1225620 | 1225620 | 2021-04-16 | Greene | Alabama | 1063 | 914 | 34 |
1222373 | 1222373 | 2021-04-15 | Greene | Alabama | 1063 | 913 | 34 |
1219125 | 1219125 | 2021-04-14 | Greene | Alabama | 1063 | 910 | 34 |
1215877 | 1215877 | 2021-04-13 | Greene | Alabama | 1063 | 910 | 34 |
1212630 | 1212630 | 2021-04-12 | Greene | Alabama | 1063 | 907 | 34 |
1209381 | 1209381 | 2021-04-11 | Greene | Alabama | 1063 | 907 | 34 |
1206133 | 1206133 | 2021-04-10 | Greene | Alabama | 1063 | 907 | 34 |
1202885 | 1202885 | 2021-04-09 | Greene | Alabama | 1063 | 908 | 34 |
1199637 | 1199637 | 2021-04-08 | Greene | Alabama | 1063 | 906 | 34 |
1196388 | 1196388 | 2021-04-07 | Greene | Alabama | 1063 | 906 | 34 |
1193140 | 1193140 | 2021-04-06 | Greene | Alabama | 1063 | 906 | 34 |
1189890 | 1189890 | 2021-04-05 | Greene | Alabama | 1063 | 906 | 34 |
1186643 | 1186643 | 2021-04-04 | Greene | Alabama | 1063 | 906 | 34 |
1183396 | 1183396 | 2021-04-03 | Greene | Alabama | 1063 | 906 | 34 |
1180149 | 1180149 | 2021-04-02 | Greene | Alabama | 1063 | 904 | 34 |
1176902 | 1176902 | 2021-04-01 | Greene | Alabama | 1063 | 903 | 34 |
1173655 | 1173655 | 2021-03-31 | Greene | Alabama | 1063 | 904 | 34 |
1170408 | 1170408 | 2021-03-30 | Greene | Alabama | 1063 | 904 | 34 |
1167160 | 1167160 | 2021-03-29 | Greene | Alabama | 1063 | 903 | 34 |
1163912 | 1163912 | 2021-03-28 | Greene | Alabama | 1063 | 903 | 34 |
1160664 | 1160664 | 2021-03-27 | Greene | Alabama | 1063 | 903 | 34 |
1157416 | 1157416 | 2021-03-26 | Greene | Alabama | 1063 | 903 | 34 |
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);