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

789 rows where fips = 28045 and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 789 ✖

fips 1

  • 28045 · 789 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501015 2501015 2022-05-13 Hancock Mississippi 28045 12277 152
2497757 2497757 2022-05-12 Hancock Mississippi 28045 12277 152
2494499 2494499 2022-05-11 Hancock Mississippi 28045 12277 152
2491241 2491241 2022-05-10 Hancock Mississippi 28045 12277 152
2487984 2487984 2022-05-09 Hancock Mississippi 28045 12277 152
2484726 2484726 2022-05-08 Hancock Mississippi 28045 12235 152
2481468 2481468 2022-05-07 Hancock Mississippi 28045 12235 152
2478210 2478210 2022-05-06 Hancock Mississippi 28045 12235 152
2474952 2474952 2022-05-05 Hancock Mississippi 28045 12235 152
2471695 2471695 2022-05-04 Hancock Mississippi 28045 12235 152
2468439 2468439 2022-05-03 Hancock Mississippi 28045 12235 152
2465184 2465184 2022-05-02 Hancock Mississippi 28045 12235 152
2461928 2461928 2022-05-01 Hancock Mississippi 28045 12230 152
2458672 2458672 2022-04-30 Hancock Mississippi 28045 12230 152
2455416 2455416 2022-04-29 Hancock Mississippi 28045 12230 152
2452160 2452160 2022-04-28 Hancock Mississippi 28045 12230 152
2448904 2448904 2022-04-27 Hancock Mississippi 28045 12230 152
2445648 2445648 2022-04-26 Hancock Mississippi 28045 12230 152
2442392 2442392 2022-04-25 Hancock Mississippi 28045 12226 152
2439136 2439136 2022-04-24 Hancock Mississippi 28045 12226 152
2435880 2435880 2022-04-23 Hancock Mississippi 28045 12226 152
2432624 2432624 2022-04-22 Hancock Mississippi 28045 12226 152
2429368 2429368 2022-04-21 Hancock Mississippi 28045 12226 152
2426112 2426112 2022-04-20 Hancock Mississippi 28045 12226 152
2422856 2422856 2022-04-19 Hancock Mississippi 28045 12226 152
2419600 2419600 2022-04-18 Hancock Mississippi 28045 12226 152
2416344 2416344 2022-04-17 Hancock Mississippi 28045 12220 152
2413088 2413088 2022-04-16 Hancock Mississippi 28045 12220 152
2409832 2409832 2022-04-15 Hancock Mississippi 28045 12220 152
2406576 2406576 2022-04-14 Hancock Mississippi 28045 12220 152
2403320 2403320 2022-04-13 Hancock Mississippi 28045 12220 152
2400066 2400066 2022-04-12 Hancock Mississippi 28045 12220 152
2396810 2396810 2022-04-11 Hancock Mississippi 28045 12210 151
2393555 2393555 2022-04-10 Hancock Mississippi 28045 12210 151
2390299 2390299 2022-04-09 Hancock Mississippi 28045 12210 151
2387043 2387043 2022-04-08 Hancock Mississippi 28045 12210 151
2383788 2383788 2022-04-07 Hancock Mississippi 28045 12210 151
2380533 2380533 2022-04-06 Hancock Mississippi 28045 12210 151
2377278 2377278 2022-04-05 Hancock Mississippi 28045 12210 151
2374026 2374026 2022-04-04 Hancock Mississippi 28045 12210 151
2370773 2370773 2022-04-03 Hancock Mississippi 28045 12194 150
2367520 2367520 2022-04-02 Hancock Mississippi 28045 12194 150
2364267 2364267 2022-04-01 Hancock Mississippi 28045 12194 150
2361013 2361013 2022-03-31 Hancock Mississippi 28045 12194 150
2357759 2357759 2022-03-30 Hancock Mississippi 28045 12194 150
2354506 2354506 2022-03-29 Hancock Mississippi 28045 12194 150
2351254 2351254 2022-03-28 Hancock Mississippi 28045 12194 150
2348001 2348001 2022-03-27 Hancock Mississippi 28045 12185 150
2344748 2344748 2022-03-26 Hancock Mississippi 28045 12185 150
2341495 2341495 2022-03-25 Hancock Mississippi 28045 12185 150
2338242 2338242 2022-03-24 Hancock Mississippi 28045 12185 150
2334988 2334988 2022-03-23 Hancock Mississippi 28045 12185 150
2331734 2331734 2022-03-22 Hancock Mississippi 28045 12185 150
2328482 2328482 2022-03-21 Hancock Mississippi 28045 12185 150
2325229 2325229 2022-03-20 Hancock Mississippi 28045 12174 150
2321975 2321975 2022-03-19 Hancock Mississippi 28045 12174 150
2318721 2318721 2022-03-18 Hancock Mississippi 28045 12174 150
2315468 2315468 2022-03-17 Hancock Mississippi 28045 12174 150
2312215 2312215 2022-03-16 Hancock Mississippi 28045 12174 150
2308962 2308962 2022-03-15 Hancock Mississippi 28045 12174 150
2305711 2305711 2022-03-14 Hancock Mississippi 28045 12174 150
2302459 2302459 2022-03-13 Hancock Mississippi 28045 12154 150
2299207 2299207 2022-03-12 Hancock Mississippi 28045 12154 150
2295955 2295955 2022-03-11 Hancock Mississippi 28045 12154 150
2292703 2292703 2022-03-10 Hancock Mississippi 28045 12154 150
2289451 2289451 2022-03-09 Hancock Mississippi 28045 12154 150
2286200 2286200 2022-03-08 Hancock Mississippi 28045 12154 150
2282948 2282948 2022-03-07 Hancock Mississippi 28045 12151 150
2279695 2279695 2022-03-06 Hancock Mississippi 28045 12146 150
2276442 2276442 2022-03-05 Hancock Mississippi 28045 12146 150
2273189 2273189 2022-03-04 Hancock Mississippi 28045 12146 150
2269937 2269937 2022-03-03 Hancock Mississippi 28045 12141 149
2266684 2266684 2022-03-02 Hancock Mississippi 28045 12139 149
2263433 2263433 2022-03-01 Hancock Mississippi 28045 12131 148
2260182 2260182 2022-02-28 Hancock Mississippi 28045 12125 146
2256931 2256931 2022-02-27 Hancock Mississippi 28045 12116 146
2253680 2253680 2022-02-26 Hancock Mississippi 28045 12116 146
2250429 2250429 2022-02-25 Hancock Mississippi 28045 12116 146
2247178 2247178 2022-02-24 Hancock Mississippi 28045 12113 146
2243927 2243927 2022-02-23 Hancock Mississippi 28045 12109 147
2240676 2240676 2022-02-22 Hancock Mississippi 28045 12103 146
2237425 2237425 2022-02-21 Hancock Mississippi 28045 12070 146
2234174 2234174 2022-02-20 Hancock Mississippi 28045 12070 146
2230923 2230923 2022-02-19 Hancock Mississippi 28045 12070 146
2227672 2227672 2022-02-18 Hancock Mississippi 28045 12070 146
2224421 2224421 2022-02-17 Hancock Mississippi 28045 12058 146
2221170 2221170 2022-02-16 Hancock Mississippi 28045 12044 146
2217919 2217919 2022-02-15 Hancock Mississippi 28045 12039 146
2214668 2214668 2022-02-14 Hancock Mississippi 28045 12019 146
2211416 2211416 2022-02-13 Hancock Mississippi 28045 11947 146
2208163 2208163 2022-02-12 Hancock Mississippi 28045 11947 146
2204910 2204910 2022-02-11 Hancock Mississippi 28045 11947 146
2201657 2201657 2022-02-10 Hancock Mississippi 28045 11939 146
2198403 2198403 2022-02-09 Hancock Mississippi 28045 11903 145
2195149 2195149 2022-02-08 Hancock Mississippi 28045 11871 145
2191895 2191895 2022-02-07 Hancock Mississippi 28045 11828 145
2188642 2188642 2022-02-06 Hancock Mississippi 28045 11339 145
2185389 2185389 2022-02-05 Hancock Mississippi 28045 11339 145
2182137 2182137 2022-02-04 Hancock Mississippi 28045 11339 145
2178885 2178885 2022-02-03 Hancock Mississippi 28045 11235 145

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