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

784 rows where county = "Union" and fips = 28145 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 28145 · 784 ✖

county 1

  • Union · 784 ✖
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

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