ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Union" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501065 | 2501065 | 2022-05-13 | Union | Mississippi | 28145 | 9487 | 122 |
2497807 | 2497807 | 2022-05-12 | Union | Mississippi | 28145 | 9487 | 122 |
2494549 | 2494549 | 2022-05-11 | Union | Mississippi | 28145 | 9487 | 122 |
2491291 | 2491291 | 2022-05-10 | Union | Mississippi | 28145 | 9487 | 122 |
2488034 | 2488034 | 2022-05-09 | Union | Mississippi | 28145 | 9487 | 122 |
2484776 | 2484776 | 2022-05-08 | Union | Mississippi | 28145 | 9480 | 122 |
2481518 | 2481518 | 2022-05-07 | Union | Mississippi | 28145 | 9480 | 122 |
2478260 | 2478260 | 2022-05-06 | Union | Mississippi | 28145 | 9480 | 122 |
2475002 | 2475002 | 2022-05-05 | Union | Mississippi | 28145 | 9480 | 122 |
2471745 | 2471745 | 2022-05-04 | Union | Mississippi | 28145 | 9480 | 122 |
2468489 | 2468489 | 2022-05-03 | Union | Mississippi | 28145 | 9480 | 122 |
2465234 | 2465234 | 2022-05-02 | Union | Mississippi | 28145 | 9480 | 122 |
2461978 | 2461978 | 2022-05-01 | Union | Mississippi | 28145 | 9474 | 122 |
2458722 | 2458722 | 2022-04-30 | Union | Mississippi | 28145 | 9474 | 122 |
2455466 | 2455466 | 2022-04-29 | Union | Mississippi | 28145 | 9474 | 122 |
2452210 | 2452210 | 2022-04-28 | Union | Mississippi | 28145 | 9474 | 122 |
2448954 | 2448954 | 2022-04-27 | Union | Mississippi | 28145 | 9474 | 122 |
2445698 | 2445698 | 2022-04-26 | Union | Mississippi | 28145 | 9474 | 122 |
2442442 | 2442442 | 2022-04-25 | Union | Mississippi | 28145 | 9471 | 122 |
2439186 | 2439186 | 2022-04-24 | Union | Mississippi | 28145 | 9471 | 122 |
2435930 | 2435930 | 2022-04-23 | Union | Mississippi | 28145 | 9471 | 122 |
2432674 | 2432674 | 2022-04-22 | Union | Mississippi | 28145 | 9471 | 122 |
2429418 | 2429418 | 2022-04-21 | Union | Mississippi | 28145 | 9471 | 122 |
2426162 | 2426162 | 2022-04-20 | Union | Mississippi | 28145 | 9471 | 122 |
2422906 | 2422906 | 2022-04-19 | Union | Mississippi | 28145 | 9471 | 122 |
2419650 | 2419650 | 2022-04-18 | Union | Mississippi | 28145 | 9471 | 122 |
2416394 | 2416394 | 2022-04-17 | Union | Mississippi | 28145 | 9471 | 122 |
2413138 | 2413138 | 2022-04-16 | Union | Mississippi | 28145 | 9471 | 122 |
2409882 | 2409882 | 2022-04-15 | Union | Mississippi | 28145 | 9471 | 122 |
2406626 | 2406626 | 2022-04-14 | Union | Mississippi | 28145 | 9471 | 122 |
2403370 | 2403370 | 2022-04-13 | Union | Mississippi | 28145 | 9471 | 122 |
2400116 | 2400116 | 2022-04-12 | Union | Mississippi | 28145 | 9471 | 122 |
2396860 | 2396860 | 2022-04-11 | Union | Mississippi | 28145 | 9466 | 122 |
2393605 | 2393605 | 2022-04-10 | Union | Mississippi | 28145 | 9466 | 122 |
2390349 | 2390349 | 2022-04-09 | Union | Mississippi | 28145 | 9466 | 122 |
2387093 | 2387093 | 2022-04-08 | Union | Mississippi | 28145 | 9466 | 122 |
2383838 | 2383838 | 2022-04-07 | Union | Mississippi | 28145 | 9466 | 122 |
2380583 | 2380583 | 2022-04-06 | Union | Mississippi | 28145 | 9466 | 122 |
2377328 | 2377328 | 2022-04-05 | Union | Mississippi | 28145 | 9466 | 122 |
2374076 | 2374076 | 2022-04-04 | Union | Mississippi | 28145 | 9466 | 122 |
2370823 | 2370823 | 2022-04-03 | Union | Mississippi | 28145 | 9460 | 121 |
2367570 | 2367570 | 2022-04-02 | Union | Mississippi | 28145 | 9460 | 121 |
2364317 | 2364317 | 2022-04-01 | Union | Mississippi | 28145 | 9460 | 121 |
2361063 | 2361063 | 2022-03-31 | Union | Mississippi | 28145 | 9460 | 121 |
2357809 | 2357809 | 2022-03-30 | Union | Mississippi | 28145 | 9460 | 121 |
2354556 | 2354556 | 2022-03-29 | Union | Mississippi | 28145 | 9460 | 121 |
2351304 | 2351304 | 2022-03-28 | Union | Mississippi | 28145 | 9460 | 121 |
2348051 | 2348051 | 2022-03-27 | Union | Mississippi | 28145 | 9457 | 121 |
2344798 | 2344798 | 2022-03-26 | Union | Mississippi | 28145 | 9457 | 121 |
2341545 | 2341545 | 2022-03-25 | Union | Mississippi | 28145 | 9457 | 121 |
2338292 | 2338292 | 2022-03-24 | Union | Mississippi | 28145 | 9457 | 121 |
2335038 | 2335038 | 2022-03-23 | Union | Mississippi | 28145 | 9457 | 121 |
2331784 | 2331784 | 2022-03-22 | Union | Mississippi | 28145 | 9457 | 121 |
2328532 | 2328532 | 2022-03-21 | Union | Mississippi | 28145 | 9457 | 121 |
2325279 | 2325279 | 2022-03-20 | Union | Mississippi | 28145 | 9454 | 119 |
2322025 | 2322025 | 2022-03-19 | Union | Mississippi | 28145 | 9454 | 119 |
2318771 | 2318771 | 2022-03-18 | Union | Mississippi | 28145 | 9454 | 119 |
2315518 | 2315518 | 2022-03-17 | Union | Mississippi | 28145 | 9454 | 119 |
2312265 | 2312265 | 2022-03-16 | Union | Mississippi | 28145 | 9454 | 119 |
2309012 | 2309012 | 2022-03-15 | Union | Mississippi | 28145 | 9454 | 119 |
2305761 | 2305761 | 2022-03-14 | Union | Mississippi | 28145 | 9454 | 119 |
2302509 | 2302509 | 2022-03-13 | Union | Mississippi | 28145 | 9452 | 118 |
2299257 | 2299257 | 2022-03-12 | Union | Mississippi | 28145 | 9452 | 118 |
2296005 | 2296005 | 2022-03-11 | Union | Mississippi | 28145 | 9452 | 118 |
2292753 | 2292753 | 2022-03-10 | Union | Mississippi | 28145 | 9452 | 118 |
2289501 | 2289501 | 2022-03-09 | Union | Mississippi | 28145 | 9452 | 118 |
2286250 | 2286250 | 2022-03-08 | Union | Mississippi | 28145 | 9452 | 118 |
2282998 | 2282998 | 2022-03-07 | Union | Mississippi | 28145 | 9450 | 118 |
2279745 | 2279745 | 2022-03-06 | Union | Mississippi | 28145 | 9447 | 118 |
2276492 | 2276492 | 2022-03-05 | Union | Mississippi | 28145 | 9447 | 118 |
2273239 | 2273239 | 2022-03-04 | Union | Mississippi | 28145 | 9447 | 118 |
2269987 | 2269987 | 2022-03-03 | Union | Mississippi | 28145 | 9446 | 117 |
2266734 | 2266734 | 2022-03-02 | Union | Mississippi | 28145 | 9441 | 116 |
2263483 | 2263483 | 2022-03-01 | Union | Mississippi | 28145 | 9438 | 116 |
2260232 | 2260232 | 2022-02-28 | Union | Mississippi | 28145 | 9435 | 115 |
2256981 | 2256981 | 2022-02-27 | Union | Mississippi | 28145 | 9427 | 115 |
2253730 | 2253730 | 2022-02-26 | Union | Mississippi | 28145 | 9427 | 115 |
2250479 | 2250479 | 2022-02-25 | Union | Mississippi | 28145 | 9427 | 115 |
2247228 | 2247228 | 2022-02-24 | Union | Mississippi | 28145 | 9426 | 115 |
2243977 | 2243977 | 2022-02-23 | Union | Mississippi | 28145 | 9421 | 115 |
2240726 | 2240726 | 2022-02-22 | Union | Mississippi | 28145 | 9416 | 115 |
2237475 | 2237475 | 2022-02-21 | Union | Mississippi | 28145 | 9377 | 115 |
2234224 | 2234224 | 2022-02-20 | Union | Mississippi | 28145 | 9377 | 115 |
2230973 | 2230973 | 2022-02-19 | Union | Mississippi | 28145 | 9377 | 115 |
2227722 | 2227722 | 2022-02-18 | Union | Mississippi | 28145 | 9377 | 115 |
2224471 | 2224471 | 2022-02-17 | Union | Mississippi | 28145 | 9369 | 113 |
2221220 | 2221220 | 2022-02-16 | Union | Mississippi | 28145 | 9364 | 113 |
2217969 | 2217969 | 2022-02-15 | Union | Mississippi | 28145 | 9356 | 111 |
2214718 | 2214718 | 2022-02-14 | Union | Mississippi | 28145 | 9346 | 111 |
2211466 | 2211466 | 2022-02-13 | Union | Mississippi | 28145 | 9305 | 111 |
2208213 | 2208213 | 2022-02-12 | Union | Mississippi | 28145 | 9305 | 111 |
2204960 | 2204960 | 2022-02-11 | Union | Mississippi | 28145 | 9305 | 111 |
2201707 | 2201707 | 2022-02-10 | Union | Mississippi | 28145 | 9298 | 110 |
2198453 | 2198453 | 2022-02-09 | Union | Mississippi | 28145 | 9275 | 109 |
2195199 | 2195199 | 2022-02-08 | Union | Mississippi | 28145 | 9261 | 109 |
2191945 | 2191945 | 2022-02-07 | Union | Mississippi | 28145 | 9230 | 109 |
2188692 | 2188692 | 2022-02-06 | Union | Mississippi | 28145 | 8985 | 109 |
2185439 | 2185439 | 2022-02-05 | Union | Mississippi | 28145 | 8985 | 109 |
2182187 | 2182187 | 2022-02-04 | Union | Mississippi | 28145 | 8985 | 109 |
2178935 | 2178935 | 2022-02-03 | Union | Mississippi | 28145 | 8897 | 109 |
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);