ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
177 rows where county = "Crawford" and deaths = 40 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Crawford · 177 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500292 | 2500292 | 2022-05-13 | Crawford | Indiana | 18025 | 2560 | 40 |
2497034 | 2497034 | 2022-05-12 | Crawford | Indiana | 18025 | 2560 | 40 |
2493776 | 2493776 | 2022-05-11 | Crawford | Indiana | 18025 | 2560 | 40 |
2490518 | 2490518 | 2022-05-10 | Crawford | Indiana | 18025 | 2559 | 40 |
2487261 | 2487261 | 2022-05-09 | Crawford | Indiana | 18025 | 2559 | 40 |
2484003 | 2484003 | 2022-05-08 | Crawford | Indiana | 18025 | 2558 | 40 |
2480745 | 2480745 | 2022-05-07 | Crawford | Indiana | 18025 | 2558 | 40 |
2477487 | 2477487 | 2022-05-06 | Crawford | Indiana | 18025 | 2558 | 40 |
2474229 | 2474229 | 2022-05-05 | Crawford | Indiana | 18025 | 2558 | 40 |
2470972 | 2470972 | 2022-05-04 | Crawford | Indiana | 18025 | 2558 | 40 |
2467716 | 2467716 | 2022-05-03 | Crawford | Indiana | 18025 | 2554 | 40 |
2464461 | 2464461 | 2022-05-02 | Crawford | Indiana | 18025 | 2554 | 40 |
2461205 | 2461205 | 2022-05-01 | Crawford | Indiana | 18025 | 2554 | 40 |
2457949 | 2457949 | 2022-04-30 | Crawford | Indiana | 18025 | 2554 | 40 |
2454693 | 2454693 | 2022-04-29 | Crawford | Indiana | 18025 | 2554 | 40 |
2451437 | 2451437 | 2022-04-28 | Crawford | Indiana | 18025 | 2552 | 40 |
2448181 | 2448181 | 2022-04-27 | Crawford | Indiana | 18025 | 2552 | 40 |
2444925 | 2444925 | 2022-04-26 | Crawford | Indiana | 18025 | 2552 | 40 |
2441669 | 2441669 | 2022-04-25 | Crawford | Indiana | 18025 | 2552 | 40 |
2438413 | 2438413 | 2022-04-24 | Crawford | Indiana | 18025 | 2551 | 40 |
2435157 | 2435157 | 2022-04-23 | Crawford | Indiana | 18025 | 2551 | 40 |
2431901 | 2431901 | 2022-04-22 | Crawford | Indiana | 18025 | 2551 | 40 |
2428645 | 2428645 | 2022-04-21 | Crawford | Indiana | 18025 | 2551 | 40 |
2425389 | 2425389 | 2022-04-20 | Crawford | Indiana | 18025 | 2551 | 40 |
2422133 | 2422133 | 2022-04-19 | Crawford | Indiana | 18025 | 2551 | 40 |
2418877 | 2418877 | 2022-04-18 | Crawford | Indiana | 18025 | 2551 | 40 |
2415621 | 2415621 | 2022-04-17 | Crawford | Indiana | 18025 | 2548 | 40 |
2412365 | 2412365 | 2022-04-16 | Crawford | Indiana | 18025 | 2548 | 40 |
2409109 | 2409109 | 2022-04-15 | Crawford | Indiana | 18025 | 2548 | 40 |
2405853 | 2405853 | 2022-04-14 | Crawford | Indiana | 18025 | 2548 | 40 |
2402598 | 2402598 | 2022-04-13 | Crawford | Indiana | 18025 | 2548 | 40 |
2399343 | 2399343 | 2022-04-12 | Crawford | Indiana | 18025 | 2547 | 40 |
2396088 | 2396088 | 2022-04-11 | Crawford | Indiana | 18025 | 2547 | 40 |
2392832 | 2392832 | 2022-04-10 | Crawford | Indiana | 18025 | 2546 | 40 |
2389576 | 2389576 | 2022-04-09 | Crawford | Indiana | 18025 | 2546 | 40 |
2386321 | 2386321 | 2022-04-08 | Crawford | Indiana | 18025 | 2546 | 40 |
2383066 | 2383066 | 2022-04-07 | Crawford | Indiana | 18025 | 2546 | 40 |
2379811 | 2379811 | 2022-04-06 | Crawford | Indiana | 18025 | 2546 | 40 |
1813795 | 1813795 | 2021-10-14 | Crawford | Georgia | 13079 | 1121 | 40 |
1810546 | 1810546 | 2021-10-13 | Crawford | Georgia | 13079 | 1117 | 40 |
1807297 | 1807297 | 2021-10-12 | Crawford | Georgia | 13079 | 1115 | 40 |
1532267 | 1532267 | 2021-07-19 | Crawford | Missouri | 29055 | 2749 | 40 |
1529020 | 1529020 | 2021-07-18 | Crawford | Missouri | 29055 | 2743 | 40 |
1525773 | 1525773 | 2021-07-17 | Crawford | Missouri | 29055 | 2740 | 40 |
1522526 | 1522526 | 2021-07-16 | Crawford | Missouri | 29055 | 2728 | 40 |
1519277 | 1519277 | 2021-07-15 | Crawford | Missouri | 29055 | 2723 | 40 |
1516030 | 1516030 | 2021-07-14 | Crawford | Missouri | 29055 | 2718 | 40 |
1512784 | 1512784 | 2021-07-13 | Crawford | Missouri | 29055 | 2711 | 40 |
1509537 | 1509537 | 2021-07-12 | Crawford | Missouri | 29055 | 2705 | 40 |
1506291 | 1506291 | 2021-07-11 | Crawford | Missouri | 29055 | 2704 | 40 |
1503045 | 1503045 | 2021-07-10 | Crawford | Missouri | 29055 | 2700 | 40 |
1499799 | 1499799 | 2021-07-09 | Crawford | Missouri | 29055 | 2694 | 40 |
1496553 | 1496553 | 2021-07-08 | Crawford | Missouri | 29055 | 2690 | 40 |
1493306 | 1493306 | 2021-07-07 | Crawford | Missouri | 29055 | 2684 | 40 |
1490059 | 1490059 | 2021-07-06 | Crawford | Missouri | 29055 | 2683 | 40 |
1486812 | 1486812 | 2021-07-05 | Crawford | Missouri | 29055 | 2683 | 40 |
1483566 | 1483566 | 2021-07-04 | Crawford | Missouri | 29055 | 2679 | 40 |
1480320 | 1480320 | 2021-07-03 | Crawford | Missouri | 29055 | 2677 | 40 |
1477073 | 1477073 | 2021-07-02 | Crawford | Missouri | 29055 | 2676 | 40 |
1473827 | 1473827 | 2021-07-01 | Crawford | Missouri | 29055 | 2675 | 40 |
1470581 | 1470581 | 2021-06-30 | Crawford | Missouri | 29055 | 2671 | 40 |
1467336 | 1467336 | 2021-06-29 | Crawford | Missouri | 29055 | 2668 | 40 |
1464091 | 1464091 | 2021-06-28 | Crawford | Missouri | 29055 | 2665 | 40 |
1460846 | 1460846 | 2021-06-27 | Crawford | Missouri | 29055 | 2665 | 40 |
1457601 | 1457601 | 2021-06-26 | Crawford | Missouri | 29055 | 2661 | 40 |
1454356 | 1454356 | 2021-06-25 | Crawford | Missouri | 29055 | 2661 | 40 |
1451111 | 1451111 | 2021-06-24 | Crawford | Missouri | 29055 | 2660 | 40 |
1447161 | 1447161 | 2021-06-23 | Crawford | Iowa | 19047 | 2683 | 40 |
1447865 | 1447865 | 2021-06-23 | Crawford | Missouri | 29055 | 2654 | 40 |
1443916 | 1443916 | 2021-06-22 | Crawford | Iowa | 19047 | 2683 | 40 |
1444620 | 1444620 | 2021-06-22 | Crawford | Missouri | 29055 | 2646 | 40 |
1440671 | 1440671 | 2021-06-21 | Crawford | Iowa | 19047 | 2684 | 40 |
1437424 | 1437424 | 2021-06-20 | Crawford | Iowa | 19047 | 2686 | 40 |
1434177 | 1434177 | 2021-06-19 | Crawford | Iowa | 19047 | 2684 | 40 |
1430931 | 1430931 | 2021-06-18 | Crawford | Iowa | 19047 | 2685 | 40 |
1427686 | 1427686 | 2021-06-17 | Crawford | Iowa | 19047 | 2683 | 40 |
1424441 | 1424441 | 2021-06-16 | Crawford | Iowa | 19047 | 2682 | 40 |
1421193 | 1421193 | 2021-06-15 | Crawford | Iowa | 19047 | 2684 | 40 |
1417948 | 1417948 | 2021-06-14 | Crawford | Iowa | 19047 | 2679 | 40 |
1414702 | 1414702 | 2021-06-13 | Crawford | Iowa | 19047 | 2679 | 40 |
1411457 | 1411457 | 2021-06-12 | Crawford | Iowa | 19047 | 2679 | 40 |
1408212 | 1408212 | 2021-06-11 | Crawford | Iowa | 19047 | 2679 | 40 |
1404966 | 1404966 | 2021-06-10 | Crawford | Iowa | 19047 | 2678 | 40 |
1401721 | 1401721 | 2021-06-09 | Crawford | Iowa | 19047 | 2678 | 40 |
1398476 | 1398476 | 2021-06-08 | Crawford | Iowa | 19047 | 2680 | 40 |
1395229 | 1395229 | 2021-06-07 | Crawford | Iowa | 19047 | 2680 | 40 |
1391984 | 1391984 | 2021-06-06 | Crawford | Iowa | 19047 | 2680 | 40 |
1388739 | 1388739 | 2021-06-05 | Crawford | Iowa | 19047 | 2679 | 40 |
1385494 | 1385494 | 2021-06-04 | Crawford | Iowa | 19047 | 2679 | 40 |
1382248 | 1382248 | 2021-06-03 | Crawford | Iowa | 19047 | 2679 | 40 |
1379003 | 1379003 | 2021-06-02 | Crawford | Iowa | 19047 | 2679 | 40 |
1375757 | 1375757 | 2021-06-01 | Crawford | Iowa | 19047 | 2677 | 40 |
1372512 | 1372512 | 2021-05-31 | Crawford | Iowa | 19047 | 2677 | 40 |
1369267 | 1369267 | 2021-05-30 | Crawford | Iowa | 19047 | 2677 | 40 |
1366021 | 1366021 | 2021-05-29 | Crawford | Iowa | 19047 | 2678 | 40 |
1362775 | 1362775 | 2021-05-28 | Crawford | Iowa | 19047 | 2677 | 40 |
1359528 | 1359528 | 2021-05-27 | Crawford | Iowa | 19047 | 2677 | 40 |
1356282 | 1356282 | 2021-05-26 | Crawford | Iowa | 19047 | 2677 | 40 |
1353036 | 1353036 | 2021-05-25 | Crawford | Iowa | 19047 | 2675 | 40 |
1349790 | 1349790 | 2021-05-24 | Crawford | Iowa | 19047 | 2674 | 40 |
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);