ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

783 rows where county = "Montgomery" and state = "Mississippi" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Mississippi · 783 ✖

fips 1

county 1

  • Montgomery · 783 ✖
Link rowid date ▲ county state fips cases deaths
2501041 2501041 2022-05-13 Montgomery Mississippi 28097 2963 77
2497783 2497783 2022-05-12 Montgomery Mississippi 28097 2963 77
2494525 2494525 2022-05-11 Montgomery Mississippi 28097 2963 77
2491267 2491267 2022-05-10 Montgomery Mississippi 28097 2963 77
2488010 2488010 2022-05-09 Montgomery Mississippi 28097 2963 77
2484752 2484752 2022-05-08 Montgomery Mississippi 28097 2960 77
2481494 2481494 2022-05-07 Montgomery Mississippi 28097 2960 77
2478236 2478236 2022-05-06 Montgomery Mississippi 28097 2960 77
2474978 2474978 2022-05-05 Montgomery Mississippi 28097 2960 77
2471721 2471721 2022-05-04 Montgomery Mississippi 28097 2960 77
2468465 2468465 2022-05-03 Montgomery Mississippi 28097 2960 77
2465210 2465210 2022-05-02 Montgomery Mississippi 28097 2960 77
2461954 2461954 2022-05-01 Montgomery Mississippi 28097 2959 77
2458698 2458698 2022-04-30 Montgomery Mississippi 28097 2959 77
2455442 2455442 2022-04-29 Montgomery Mississippi 28097 2959 77
2452186 2452186 2022-04-28 Montgomery Mississippi 28097 2959 77
2448930 2448930 2022-04-27 Montgomery Mississippi 28097 2959 77
2445674 2445674 2022-04-26 Montgomery Mississippi 28097 2959 77
2442418 2442418 2022-04-25 Montgomery Mississippi 28097 2958 77
2439162 2439162 2022-04-24 Montgomery Mississippi 28097 2958 77
2435906 2435906 2022-04-23 Montgomery Mississippi 28097 2958 77
2432650 2432650 2022-04-22 Montgomery Mississippi 28097 2958 77
2429394 2429394 2022-04-21 Montgomery Mississippi 28097 2958 77
2426138 2426138 2022-04-20 Montgomery Mississippi 28097 2958 77
2422882 2422882 2022-04-19 Montgomery Mississippi 28097 2958 77
2419626 2419626 2022-04-18 Montgomery Mississippi 28097 2958 77
2416370 2416370 2022-04-17 Montgomery Mississippi 28097 2957 77
2413114 2413114 2022-04-16 Montgomery Mississippi 28097 2957 77
2409858 2409858 2022-04-15 Montgomery Mississippi 28097 2957 77
2406602 2406602 2022-04-14 Montgomery Mississippi 28097 2957 77
2403346 2403346 2022-04-13 Montgomery Mississippi 28097 2957 77
2400092 2400092 2022-04-12 Montgomery Mississippi 28097 2957 77
2396836 2396836 2022-04-11 Montgomery Mississippi 28097 2956 77
2393581 2393581 2022-04-10 Montgomery Mississippi 28097 2956 77
2390325 2390325 2022-04-09 Montgomery Mississippi 28097 2956 77
2387069 2387069 2022-04-08 Montgomery Mississippi 28097 2956 77
2383814 2383814 2022-04-07 Montgomery Mississippi 28097 2956 77
2380559 2380559 2022-04-06 Montgomery Mississippi 28097 2956 77
2377304 2377304 2022-04-05 Montgomery Mississippi 28097 2956 77
2374052 2374052 2022-04-04 Montgomery Mississippi 28097 2956 77
2370799 2370799 2022-04-03 Montgomery Mississippi 28097 2954 77
2367546 2367546 2022-04-02 Montgomery Mississippi 28097 2954 77
2364293 2364293 2022-04-01 Montgomery Mississippi 28097 2954 77
2361039 2361039 2022-03-31 Montgomery Mississippi 28097 2954 77
2357785 2357785 2022-03-30 Montgomery Mississippi 28097 2954 77
2354532 2354532 2022-03-29 Montgomery Mississippi 28097 2954 77
2351280 2351280 2022-03-28 Montgomery Mississippi 28097 2954 77
2348027 2348027 2022-03-27 Montgomery Mississippi 28097 2953 77
2344774 2344774 2022-03-26 Montgomery Mississippi 28097 2953 77
2341521 2341521 2022-03-25 Montgomery Mississippi 28097 2953 77
2338268 2338268 2022-03-24 Montgomery Mississippi 28097 2953 77
2335014 2335014 2022-03-23 Montgomery Mississippi 28097 2953 77
2331760 2331760 2022-03-22 Montgomery Mississippi 28097 2953 77
2328508 2328508 2022-03-21 Montgomery Mississippi 28097 2953 77
2325255 2325255 2022-03-20 Montgomery Mississippi 28097 2950 76
2322001 2322001 2022-03-19 Montgomery Mississippi 28097 2950 76
2318747 2318747 2022-03-18 Montgomery Mississippi 28097 2950 76
2315494 2315494 2022-03-17 Montgomery Mississippi 28097 2950 76
2312241 2312241 2022-03-16 Montgomery Mississippi 28097 2950 76
2308988 2308988 2022-03-15 Montgomery Mississippi 28097 2950 76
2305737 2305737 2022-03-14 Montgomery Mississippi 28097 2950 76
2302485 2302485 2022-03-13 Montgomery Mississippi 28097 2948 75
2299233 2299233 2022-03-12 Montgomery Mississippi 28097 2948 75
2295981 2295981 2022-03-11 Montgomery Mississippi 28097 2948 75
2292729 2292729 2022-03-10 Montgomery Mississippi 28097 2948 75
2289477 2289477 2022-03-09 Montgomery Mississippi 28097 2948 75
2286226 2286226 2022-03-08 Montgomery Mississippi 28097 2948 75
2282974 2282974 2022-03-07 Montgomery Mississippi 28097 2947 74
2279721 2279721 2022-03-06 Montgomery Mississippi 28097 2946 74
2276468 2276468 2022-03-05 Montgomery Mississippi 28097 2946 74
2273215 2273215 2022-03-04 Montgomery Mississippi 28097 2946 74
2269963 2269963 2022-03-03 Montgomery Mississippi 28097 2946 74
2266710 2266710 2022-03-02 Montgomery Mississippi 28097 2944 74
2263459 2263459 2022-03-01 Montgomery Mississippi 28097 2941 74
2260208 2260208 2022-02-28 Montgomery Mississippi 28097 2938 72
2256957 2256957 2022-02-27 Montgomery Mississippi 28097 2936 71
2253706 2253706 2022-02-26 Montgomery Mississippi 28097 2936 71
2250455 2250455 2022-02-25 Montgomery Mississippi 28097 2936 71
2247204 2247204 2022-02-24 Montgomery Mississippi 28097 2933 71
2243953 2243953 2022-02-23 Montgomery Mississippi 28097 2930 71
2240702 2240702 2022-02-22 Montgomery Mississippi 28097 2925 71
2237451 2237451 2022-02-21 Montgomery Mississippi 28097 2921 70
2234200 2234200 2022-02-20 Montgomery Mississippi 28097 2921 70
2230949 2230949 2022-02-19 Montgomery Mississippi 28097 2921 70
2227698 2227698 2022-02-18 Montgomery Mississippi 28097 2921 70
2224447 2224447 2022-02-17 Montgomery Mississippi 28097 2916 70
2221196 2221196 2022-02-16 Montgomery Mississippi 28097 2916 70
2217945 2217945 2022-02-15 Montgomery Mississippi 28097 2909 70
2214694 2214694 2022-02-14 Montgomery Mississippi 28097 2904 69
2211442 2211442 2022-02-13 Montgomery Mississippi 28097 2884 68
2208189 2208189 2022-02-12 Montgomery Mississippi 28097 2884 68
2204936 2204936 2022-02-11 Montgomery Mississippi 28097 2884 68
2201683 2201683 2022-02-10 Montgomery Mississippi 28097 2880 67
2198429 2198429 2022-02-09 Montgomery Mississippi 28097 2873 67
2195175 2195175 2022-02-08 Montgomery Mississippi 28097 2866 67
2191921 2191921 2022-02-07 Montgomery Mississippi 28097 2862 67
2188668 2188668 2022-02-06 Montgomery Mississippi 28097 2828 67
2185415 2185415 2022-02-05 Montgomery Mississippi 28097 2828 67
2182163 2182163 2022-02-04 Montgomery Mississippi 28097 2828 67
2178911 2178911 2022-02-03 Montgomery Mississippi 28097 2815 65

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);