ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Jones" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417977 | 1417977 | 2021-06-14 | Jones | Iowa | 19105 | 3008 | 57 |
1414731 | 1414731 | 2021-06-13 | Jones | Iowa | 19105 | 3008 | 57 |
1411486 | 1411486 | 2021-06-12 | Jones | Iowa | 19105 | 3008 | 57 |
1408241 | 1408241 | 2021-06-11 | Jones | Iowa | 19105 | 3008 | 57 |
1404995 | 1404995 | 2021-06-10 | Jones | Iowa | 19105 | 3008 | 57 |
1401750 | 1401750 | 2021-06-09 | Jones | Iowa | 19105 | 3008 | 57 |
1398505 | 1398505 | 2021-06-08 | Jones | Iowa | 19105 | 3008 | 57 |
1395258 | 1395258 | 2021-06-07 | Jones | Iowa | 19105 | 3008 | 57 |
1392013 | 1392013 | 2021-06-06 | Jones | Iowa | 19105 | 3008 | 57 |
1388768 | 1388768 | 2021-06-05 | Jones | Iowa | 19105 | 3008 | 57 |
1385523 | 1385523 | 2021-06-04 | Jones | Iowa | 19105 | 3008 | 57 |
1382277 | 1382277 | 2021-06-03 | Jones | Iowa | 19105 | 3008 | 57 |
1379032 | 1379032 | 2021-06-02 | Jones | Iowa | 19105 | 3008 | 57 |
1375786 | 1375786 | 2021-06-01 | Jones | Iowa | 19105 | 3008 | 57 |
1372541 | 1372541 | 2021-05-31 | Jones | Iowa | 19105 | 3008 | 57 |
1369296 | 1369296 | 2021-05-30 | Jones | Iowa | 19105 | 3008 | 57 |
1366050 | 1366050 | 2021-05-29 | Jones | Iowa | 19105 | 3006 | 57 |
1362804 | 1362804 | 2021-05-28 | Jones | Iowa | 19105 | 3003 | 57 |
1359557 | 1359557 | 2021-05-27 | Jones | Iowa | 19105 | 3002 | 57 |
1356311 | 1356311 | 2021-05-26 | Jones | Iowa | 19105 | 3002 | 57 |
1353065 | 1353065 | 2021-05-25 | Jones | Iowa | 19105 | 3001 | 57 |
1349819 | 1349819 | 2021-05-24 | Jones | Iowa | 19105 | 2996 | 57 |
1346572 | 1346572 | 2021-05-23 | Jones | Iowa | 19105 | 2996 | 57 |
1343324 | 1343324 | 2021-05-22 | Jones | Iowa | 19105 | 2995 | 57 |
1340076 | 1340076 | 2021-05-21 | Jones | Iowa | 19105 | 2994 | 57 |
1336829 | 1336829 | 2021-05-20 | Jones | Iowa | 19105 | 2993 | 57 |
1333582 | 1333582 | 2021-05-19 | Jones | Iowa | 19105 | 2993 | 57 |
1330335 | 1330335 | 2021-05-18 | Jones | Iowa | 19105 | 2992 | 57 |
1327088 | 1327088 | 2021-05-17 | Jones | Iowa | 19105 | 2992 | 57 |
1323842 | 1323842 | 2021-05-16 | Jones | Iowa | 19105 | 2991 | 57 |
1320596 | 1320596 | 2021-05-15 | Jones | Iowa | 19105 | 2990 | 57 |
1317349 | 1317349 | 2021-05-14 | Jones | Iowa | 19105 | 2989 | 57 |
1314102 | 1314102 | 2021-05-13 | Jones | Iowa | 19105 | 2989 | 57 |
1310855 | 1310855 | 2021-05-12 | Jones | Iowa | 19105 | 2988 | 57 |
1307609 | 1307609 | 2021-05-11 | Jones | Iowa | 19105 | 2981 | 57 |
1304363 | 1304363 | 2021-05-10 | Jones | Iowa | 19105 | 2975 | 57 |
1301116 | 1301116 | 2021-05-09 | Jones | Iowa | 19105 | 2973 | 57 |
1297869 | 1297869 | 2021-05-08 | Jones | Iowa | 19105 | 2973 | 57 |
1294623 | 1294623 | 2021-05-07 | Jones | Iowa | 19105 | 2972 | 57 |
1291377 | 1291377 | 2021-05-06 | Jones | Iowa | 19105 | 2969 | 57 |
1288131 | 1288131 | 2021-05-05 | Jones | Iowa | 19105 | 2968 | 57 |
1284885 | 1284885 | 2021-05-04 | Jones | Iowa | 19105 | 2964 | 57 |
1281638 | 1281638 | 2021-05-03 | Jones | Iowa | 19105 | 2960 | 57 |
1278391 | 1278391 | 2021-05-02 | Jones | Iowa | 19105 | 2958 | 57 |
1275144 | 1275144 | 2021-05-01 | Jones | Iowa | 19105 | 2955 | 57 |
1271897 | 1271897 | 2021-04-30 | Jones | Iowa | 19105 | 2952 | 57 |
1268650 | 1268650 | 2021-04-29 | Jones | Iowa | 19105 | 2951 | 56 |
1265403 | 1265403 | 2021-04-28 | Jones | Iowa | 19105 | 2951 | 56 |
1262156 | 1262156 | 2021-04-27 | Jones | Iowa | 19105 | 2948 | 56 |
1258909 | 1258909 | 2021-04-26 | Jones | Iowa | 19105 | 2945 | 56 |
1255662 | 1255662 | 2021-04-25 | Jones | Iowa | 19105 | 2944 | 56 |
1252415 | 1252415 | 2021-04-24 | Jones | Iowa | 19105 | 2944 | 56 |
1249168 | 1249168 | 2021-04-23 | Jones | Iowa | 19105 | 2942 | 56 |
1245921 | 1245921 | 2021-04-22 | Jones | Iowa | 19105 | 2939 | 55 |
1242674 | 1242674 | 2021-04-21 | Jones | Iowa | 19105 | 2934 | 55 |
1239427 | 1239427 | 2021-04-20 | Jones | Iowa | 19105 | 2933 | 55 |
1236180 | 1236180 | 2021-04-19 | Jones | Iowa | 19105 | 2932 | 55 |
1232933 | 1232933 | 2021-04-18 | Jones | Iowa | 19105 | 2931 | 55 |
1229684 | 1229684 | 2021-04-17 | Jones | Iowa | 19105 | 2930 | 55 |
1226436 | 1226436 | 2021-04-16 | Jones | Iowa | 19105 | 2930 | 55 |
1223189 | 1223189 | 2021-04-15 | Jones | Iowa | 19105 | 2929 | 55 |
1219941 | 1219941 | 2021-04-14 | Jones | Iowa | 19105 | 2927 | 55 |
1216693 | 1216693 | 2021-04-13 | Jones | Iowa | 19105 | 2924 | 55 |
1213446 | 1213446 | 2021-04-12 | Jones | Iowa | 19105 | 2923 | 55 |
1210198 | 1210198 | 2021-04-11 | Jones | Iowa | 19105 | 2920 | 55 |
1206949 | 1206949 | 2021-04-10 | Jones | Iowa | 19105 | 2918 | 55 |
1203701 | 1203701 | 2021-04-09 | Jones | Iowa | 19105 | 2916 | 55 |
1200453 | 1200453 | 2021-04-08 | Jones | Iowa | 19105 | 2916 | 55 |
1197204 | 1197204 | 2021-04-07 | Jones | Iowa | 19105 | 2915 | 55 |
1193956 | 1193956 | 2021-04-06 | Jones | Iowa | 19105 | 2915 | 55 |
1190706 | 1190706 | 2021-04-05 | Jones | Iowa | 19105 | 2912 | 55 |
1187459 | 1187459 | 2021-04-04 | Jones | Iowa | 19105 | 2906 | 55 |
1184212 | 1184212 | 2021-04-03 | Jones | Iowa | 19105 | 2905 | 55 |
1180965 | 1180965 | 2021-04-02 | Jones | Iowa | 19105 | 2904 | 55 |
1177718 | 1177718 | 2021-04-01 | Jones | Iowa | 19105 | 2899 | 55 |
1174471 | 1174471 | 2021-03-31 | Jones | Iowa | 19105 | 2897 | 55 |
1171224 | 1171224 | 2021-03-30 | Jones | Iowa | 19105 | 2897 | 55 |
1167976 | 1167976 | 2021-03-29 | Jones | Iowa | 19105 | 2893 | 55 |
1164728 | 1164728 | 2021-03-28 | Jones | Iowa | 19105 | 2892 | 55 |
1161480 | 1161480 | 2021-03-27 | Jones | Iowa | 19105 | 2890 | 55 |
1158232 | 1158232 | 2021-03-26 | Jones | Iowa | 19105 | 2889 | 55 |
1154985 | 1154985 | 2021-03-25 | Jones | Iowa | 19105 | 2887 | 55 |
1151738 | 1151738 | 2021-03-24 | Jones | Iowa | 19105 | 2885 | 55 |
1148491 | 1148491 | 2021-03-23 | Jones | Iowa | 19105 | 2882 | 55 |
1145244 | 1145244 | 2021-03-22 | Jones | Iowa | 19105 | 2880 | 55 |
1141997 | 1141997 | 2021-03-21 | Jones | Iowa | 19105 | 2880 | 55 |
1138751 | 1138751 | 2021-03-20 | Jones | Iowa | 19105 | 2878 | 55 |
1135505 | 1135505 | 2021-03-19 | Jones | Iowa | 19105 | 2877 | 55 |
1132258 | 1132258 | 2021-03-18 | Jones | Iowa | 19105 | 2876 | 55 |
1129010 | 1129010 | 2021-03-17 | Jones | Iowa | 19105 | 2868 | 55 |
1125764 | 1125764 | 2021-03-16 | Jones | Iowa | 19105 | 2868 | 55 |
1122518 | 1122518 | 2021-03-15 | Jones | Iowa | 19105 | 2866 | 55 |
1119271 | 1119271 | 2021-03-14 | Jones | Iowa | 19105 | 2865 | 55 |
1116024 | 1116024 | 2021-03-13 | Jones | Iowa | 19105 | 2865 | 55 |
1112778 | 1112778 | 2021-03-12 | Jones | Iowa | 19105 | 2865 | 55 |
1109532 | 1109532 | 2021-03-11 | Jones | Iowa | 19105 | 2860 | 55 |
1106286 | 1106286 | 2021-03-10 | Jones | Iowa | 19105 | 2859 | 55 |
1103040 | 1103040 | 2021-03-09 | Jones | Iowa | 19105 | 2855 | 55 |
1099794 | 1099794 | 2021-03-08 | Jones | Iowa | 19105 | 2853 | 55 |
1096546 | 1096546 | 2021-03-07 | Jones | Iowa | 19105 | 2850 | 55 |
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);