ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Andrew" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418626 | 1418626 | 2021-06-14 | Andrew | Missouri | 29003 | 1901 | 20 |
1415381 | 1415381 | 2021-06-13 | Andrew | Missouri | 29003 | 1900 | 20 |
1412135 | 1412135 | 2021-06-12 | Andrew | Missouri | 29003 | 1899 | 20 |
1408890 | 1408890 | 2021-06-11 | Andrew | Missouri | 29003 | 1892 | 20 |
1405645 | 1405645 | 2021-06-10 | Andrew | Missouri | 29003 | 1886 | 20 |
1402399 | 1402399 | 2021-06-09 | Andrew | Missouri | 29003 | 1884 | 20 |
1399154 | 1399154 | 2021-06-08 | Andrew | Missouri | 29003 | 1883 | 20 |
1395908 | 1395908 | 2021-06-07 | Andrew | Missouri | 29003 | 1881 | 20 |
1392662 | 1392662 | 2021-06-06 | Andrew | Missouri | 29003 | 1881 | 20 |
1389417 | 1389417 | 2021-06-05 | Andrew | Missouri | 29003 | 1881 | 20 |
1386172 | 1386172 | 2021-06-04 | Andrew | Missouri | 29003 | 1880 | 20 |
1382927 | 1382927 | 2021-06-03 | Andrew | Missouri | 29003 | 1879 | 20 |
1379681 | 1379681 | 2021-06-02 | Andrew | Missouri | 29003 | 1878 | 20 |
1376436 | 1376436 | 2021-06-01 | Andrew | Missouri | 29003 | 1873 | 20 |
1373190 | 1373190 | 2021-05-31 | Andrew | Missouri | 29003 | 1873 | 20 |
1369945 | 1369945 | 2021-05-30 | Andrew | Missouri | 29003 | 1873 | 20 |
1366699 | 1366699 | 2021-05-29 | Andrew | Missouri | 29003 | 1873 | 20 |
1363453 | 1363453 | 2021-05-28 | Andrew | Missouri | 29003 | 1872 | 20 |
1360206 | 1360206 | 2021-05-27 | Andrew | Missouri | 29003 | 1872 | 20 |
1356960 | 1356960 | 2021-05-26 | Andrew | Missouri | 29003 | 1872 | 20 |
1353714 | 1353714 | 2021-05-25 | Andrew | Missouri | 29003 | 1871 | 20 |
1350468 | 1350468 | 2021-05-24 | Andrew | Missouri | 29003 | 1871 | 20 |
1347222 | 1347222 | 2021-05-23 | Andrew | Missouri | 29003 | 1871 | 20 |
1343974 | 1343974 | 2021-05-22 | Andrew | Missouri | 29003 | 1870 | 20 |
1340725 | 1340725 | 2021-05-21 | Andrew | Missouri | 29003 | 1870 | 20 |
1337478 | 1337478 | 2021-05-20 | Andrew | Missouri | 29003 | 1869 | 20 |
1334231 | 1334231 | 2021-05-19 | Andrew | Missouri | 29003 | 1869 | 20 |
1330984 | 1330984 | 2021-05-18 | Andrew | Missouri | 29003 | 1869 | 20 |
1327737 | 1327737 | 2021-05-17 | Andrew | Missouri | 29003 | 1868 | 20 |
1324491 | 1324491 | 2021-05-16 | Andrew | Missouri | 29003 | 1867 | 20 |
1321245 | 1321245 | 2021-05-15 | Andrew | Missouri | 29003 | 1867 | 20 |
1317999 | 1317999 | 2021-05-14 | Andrew | Missouri | 29003 | 1862 | 20 |
1314751 | 1314751 | 2021-05-13 | Andrew | Missouri | 29003 | 1861 | 20 |
1311505 | 1311505 | 2021-05-12 | Andrew | Missouri | 29003 | 1861 | 20 |
1308258 | 1308258 | 2021-05-11 | Andrew | Missouri | 29003 | 1861 | 20 |
1305012 | 1305012 | 2021-05-10 | Andrew | Missouri | 29003 | 1861 | 20 |
1301766 | 1301766 | 2021-05-09 | Andrew | Missouri | 29003 | 1861 | 20 |
1298518 | 1298518 | 2021-05-08 | Andrew | Missouri | 29003 | 1859 | 20 |
1295272 | 1295272 | 2021-05-07 | Andrew | Missouri | 29003 | 1857 | 20 |
1292026 | 1292026 | 2021-05-06 | Andrew | Missouri | 29003 | 1856 | 20 |
1288780 | 1288780 | 2021-05-05 | Andrew | Missouri | 29003 | 1855 | 20 |
1285534 | 1285534 | 2021-05-04 | Andrew | Missouri | 29003 | 1854 | 20 |
1282288 | 1282288 | 2021-05-03 | Andrew | Missouri | 29003 | 1853 | 20 |
1279041 | 1279041 | 2021-05-02 | Andrew | Missouri | 29003 | 1852 | 20 |
1275794 | 1275794 | 2021-05-01 | Andrew | Missouri | 29003 | 1852 | 20 |
1272547 | 1272547 | 2021-04-30 | Andrew | Missouri | 29003 | 1852 | 20 |
1269300 | 1269300 | 2021-04-29 | Andrew | Missouri | 29003 | 1851 | 20 |
1266053 | 1266053 | 2021-04-28 | Andrew | Missouri | 29003 | 1850 | 20 |
1262806 | 1262806 | 2021-04-27 | Andrew | Missouri | 29003 | 1848 | 20 |
1259559 | 1259559 | 2021-04-26 | Andrew | Missouri | 29003 | 1846 | 19 |
1256312 | 1256312 | 2021-04-25 | Andrew | Missouri | 29003 | 1846 | 19 |
1253065 | 1253065 | 2021-04-24 | Andrew | Missouri | 29003 | 1846 | 19 |
1249818 | 1249818 | 2021-04-23 | Andrew | Missouri | 29003 | 1846 | 19 |
1246571 | 1246571 | 2021-04-22 | Andrew | Missouri | 29003 | 1844 | 19 |
1243324 | 1243324 | 2021-04-21 | Andrew | Missouri | 29003 | 1843 | 19 |
1240077 | 1240077 | 2021-04-20 | Andrew | Missouri | 29003 | 1843 | 19 |
1236830 | 1236830 | 2021-04-19 | Andrew | Missouri | 29003 | 1842 | 19 |
1233583 | 1233583 | 2021-04-18 | Andrew | Missouri | 29003 | 1842 | 19 |
1230335 | 1230335 | 2021-04-17 | Andrew | Missouri | 29003 | 1842 | 19 |
1227087 | 1227087 | 2021-04-16 | Andrew | Missouri | 29003 | 1887 | 19 |
1223839 | 1223839 | 2021-04-15 | Andrew | Missouri | 29003 | 1887 | 18 |
1220592 | 1220592 | 2021-04-14 | Andrew | Missouri | 29003 | 1886 | 18 |
1217344 | 1217344 | 2021-04-13 | Andrew | Missouri | 29003 | 1885 | 18 |
1214097 | 1214097 | 2021-04-12 | Andrew | Missouri | 29003 | 1881 | 18 |
1210849 | 1210849 | 2021-04-11 | Andrew | Missouri | 29003 | 1881 | 18 |
1207600 | 1207600 | 2021-04-10 | Andrew | Missouri | 29003 | 1881 | 18 |
1204352 | 1204352 | 2021-04-09 | Andrew | Missouri | 29003 | 1878 | 18 |
1201104 | 1201104 | 2021-04-08 | Andrew | Missouri | 29003 | 1877 | 18 |
1197855 | 1197855 | 2021-04-07 | Andrew | Missouri | 29003 | 1874 | 18 |
1194606 | 1194606 | 2021-04-06 | Andrew | Missouri | 29003 | 1870 | 18 |
1191357 | 1191357 | 2021-04-05 | Andrew | Missouri | 29003 | 1870 | 18 |
1188109 | 1188109 | 2021-04-04 | Andrew | Missouri | 29003 | 1870 | 18 |
1184862 | 1184862 | 2021-04-03 | Andrew | Missouri | 29003 | 1870 | 18 |
1181616 | 1181616 | 2021-04-02 | Andrew | Missouri | 29003 | 1868 | 18 |
1178369 | 1178369 | 2021-04-01 | Andrew | Missouri | 29003 | 1868 | 18 |
1175122 | 1175122 | 2021-03-31 | Andrew | Missouri | 29003 | 1865 | 18 |
1171875 | 1171875 | 2021-03-30 | Andrew | Missouri | 29003 | 1863 | 18 |
1168627 | 1168627 | 2021-03-29 | Andrew | Missouri | 29003 | 1862 | 18 |
1165379 | 1165379 | 2021-03-28 | Andrew | Missouri | 29003 | 1862 | 18 |
1162131 | 1162131 | 2021-03-27 | Andrew | Missouri | 29003 | 1862 | 18 |
1158883 | 1158883 | 2021-03-26 | Andrew | Missouri | 29003 | 1862 | 18 |
1155636 | 1155636 | 2021-03-25 | Andrew | Missouri | 29003 | 1861 | 18 |
1152389 | 1152389 | 2021-03-24 | Andrew | Missouri | 29003 | 1859 | 18 |
1149142 | 1149142 | 2021-03-23 | Andrew | Missouri | 29003 | 1855 | 18 |
1145895 | 1145895 | 2021-03-22 | Andrew | Missouri | 29003 | 1853 | 18 |
1142648 | 1142648 | 2021-03-21 | Andrew | Missouri | 29003 | 1853 | 18 |
1139401 | 1139401 | 2021-03-20 | Andrew | Missouri | 29003 | 1853 | 18 |
1136155 | 1136155 | 2021-03-19 | Andrew | Missouri | 29003 | 1853 | 18 |
1132909 | 1132909 | 2021-03-18 | Andrew | Missouri | 29003 | 1852 | 18 |
1129661 | 1129661 | 2021-03-17 | Andrew | Missouri | 29003 | 1845 | 18 |
1126414 | 1126414 | 2021-03-16 | Andrew | Missouri | 29003 | 1845 | 18 |
1123168 | 1123168 | 2021-03-15 | Andrew | Missouri | 29003 | 1840 | 18 |
1119921 | 1119921 | 2021-03-14 | Andrew | Missouri | 29003 | 1840 | 18 |
1116674 | 1116674 | 2021-03-13 | Andrew | Missouri | 29003 | 1840 | 18 |
1113428 | 1113428 | 2021-03-12 | Andrew | Missouri | 29003 | 1839 | 18 |
1110182 | 1110182 | 2021-03-11 | Andrew | Missouri | 29003 | 1839 | 18 |
1106936 | 1106936 | 2021-03-10 | Andrew | Missouri | 29003 | 1837 | 18 |
1103690 | 1103690 | 2021-03-09 | Andrew | Missouri | 29003 | 1837 | 18 |
1100444 | 1100444 | 2021-03-08 | Andrew | Missouri | 29003 | 1836 | 18 |
1097197 | 1097197 | 2021-03-07 | Andrew | Missouri | 29003 | 1287 | 18 |
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);