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

773 rows where county = "Union" and fips = 13291 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

  • 13291 · 773 ✖

county 1

  • Union · 773 ✖
Link rowid date ▲ county state fips cases deaths
2500109 2500109 2022-05-13 Union Georgia 13291 4888 159
2496851 2496851 2022-05-12 Union Georgia 13291 4888 159
2493593 2493593 2022-05-11 Union Georgia 13291 4888 159
2490335 2490335 2022-05-10 Union Georgia 13291 4885 159
2487078 2487078 2022-05-09 Union Georgia 13291 4885 159
2483820 2483820 2022-05-08 Union Georgia 13291 4885 159
2480562 2480562 2022-05-07 Union Georgia 13291 4885 159
2477304 2477304 2022-05-06 Union Georgia 13291 4885 159
2474046 2474046 2022-05-05 Union Georgia 13291 4885 159
2470789 2470789 2022-05-04 Union Georgia 13291 4885 159
2467533 2467533 2022-05-03 Union Georgia 13291 4877 158
2464278 2464278 2022-05-02 Union Georgia 13291 4877 158
2461022 2461022 2022-05-01 Union Georgia 13291 4877 158
2457766 2457766 2022-04-30 Union Georgia 13291 4877 158
2454510 2454510 2022-04-29 Union Georgia 13291 4877 158
2451254 2451254 2022-04-28 Union Georgia 13291 4877 158
2447998 2447998 2022-04-27 Union Georgia 13291 4877 158
2444742 2444742 2022-04-26 Union Georgia 13291 4874 155
2441486 2441486 2022-04-25 Union Georgia 13291 4874 155
2438230 2438230 2022-04-24 Union Georgia 13291 4877 155
2434974 2434974 2022-04-23 Union Georgia 13291 4877 155
2431718 2431718 2022-04-22 Union Georgia 13291 4877 155
2428462 2428462 2022-04-21 Union Georgia 13291 4877 155
2425206 2425206 2022-04-20 Union Georgia 13291 4877 155
2421950 2421950 2022-04-19 Union Georgia 13291 4873 155
2418694 2418694 2022-04-18 Union Georgia 13291 4873 155
2415438 2415438 2022-04-17 Union Georgia 13291 4874 155
2412182 2412182 2022-04-16 Union Georgia 13291 4874 155
2408926 2408926 2022-04-15 Union Georgia 13291 4874 155
2405670 2405670 2022-04-14 Union Georgia 13291 4873 155
2402415 2402415 2022-04-13 Union Georgia 13291 4872 155
2399160 2399160 2022-04-12 Union Georgia 13291 4872 155
2395905 2395905 2022-04-11 Union Georgia 13291 4872 155
2392649 2392649 2022-04-10 Union Georgia 13291 4872 155
2389393 2389393 2022-04-09 Union Georgia 13291 4872 155
2386138 2386138 2022-04-08 Union Georgia 13291 4872 155
2382883 2382883 2022-04-07 Union Georgia 13291 4872 155
2379628 2379628 2022-04-06 Union Georgia 13291 4872 155
2376374 2376374 2022-04-05 Union Georgia 13291 4874 155
2373122 2373122 2022-04-04 Union Georgia 13291 4874 154
2369869 2369869 2022-04-03 Union Georgia 13291 4872 154
2366616 2366616 2022-04-02 Union Georgia 13291 4872 154
2363363 2363363 2022-04-01 Union Georgia 13291 4872 154
2360109 2360109 2022-03-31 Union Georgia 13291 4871 153
2356855 2356855 2022-03-30 Union Georgia 13291 4857 153
2353602 2353602 2022-03-29 Union Georgia 13291 4856 153
2350350 2350350 2022-03-28 Union Georgia 13291 4857 153
2347097 2347097 2022-03-27 Union Georgia 13291 4857 152
2343844 2343844 2022-03-26 Union Georgia 13291 4857 152
2340591 2340591 2022-03-25 Union Georgia 13291 4857 152
2337338 2337338 2022-03-24 Union Georgia 13291 4857 152
2334084 2334084 2022-03-23 Union Georgia 13291 4856 152
2330830 2330830 2022-03-22 Union Georgia 13291 4855 151
2327578 2327578 2022-03-21 Union Georgia 13291 4854 151
2324325 2324325 2022-03-20 Union Georgia 13291 4854 151
2321071 2321071 2022-03-19 Union Georgia 13291 4854 151
2317817 2317817 2022-03-18 Union Georgia 13291 4854 151
2314564 2314564 2022-03-17 Union Georgia 13291 4854 151
2311311 2311311 2022-03-16 Union Georgia 13291 4854 150
2308058 2308058 2022-03-15 Union Georgia 13291 4851 150
2304807 2304807 2022-03-14 Union Georgia 13291 4850 150
2301555 2301555 2022-03-13 Union Georgia 13291 4849 149
2298303 2298303 2022-03-12 Union Georgia 13291 4849 149
2295051 2295051 2022-03-11 Union Georgia 13291 4849 149
2291799 2291799 2022-03-10 Union Georgia 13291 4850 149
2288547 2288547 2022-03-09 Union Georgia 13291 4842 149
2285296 2285296 2022-03-08 Union Georgia 13291 4835 148
2282044 2282044 2022-03-07 Union Georgia 13291 4833 147
2278791 2278791 2022-03-06 Union Georgia 13291 4829 147
2275538 2275538 2022-03-05 Union Georgia 13291 4829 147
2272285 2272285 2022-03-04 Union Georgia 13291 4829 147
2269033 2269033 2022-03-03 Union Georgia 13291 4829 146
2265780 2265780 2022-03-02 Union Georgia 13291 4826 146
2262529 2262529 2022-03-01 Union Georgia 13291 4822 145
2259278 2259278 2022-02-28 Union Georgia 13291 4818 144
2256027 2256027 2022-02-27 Union Georgia 13291 4810 144
2252776 2252776 2022-02-26 Union Georgia 13291 4810 144
2249525 2249525 2022-02-25 Union Georgia 13291 4810 144
2246274 2246274 2022-02-24 Union Georgia 13291 4809 144
2243023 2243023 2022-02-23 Union Georgia 13291 4781 144
2239772 2239772 2022-02-22 Union Georgia 13291 4777 144
2236521 2236521 2022-02-21 Union Georgia 13291 4775 143
2233270 2233270 2022-02-20 Union Georgia 13291 4760 143
2230019 2230019 2022-02-19 Union Georgia 13291 4760 143
2226768 2226768 2022-02-18 Union Georgia 13291 4760 143
2223517 2223517 2022-02-17 Union Georgia 13291 4754 143
2220266 2220266 2022-02-16 Union Georgia 13291 4750 143
2217015 2217015 2022-02-15 Union Georgia 13291 4748 142
2213764 2213764 2022-02-14 Union Georgia 13291 4741 142
2210512 2210512 2022-02-13 Union Georgia 13291 4726 142
2207259 2207259 2022-02-12 Union Georgia 13291 4726 142
2204006 2204006 2022-02-11 Union Georgia 13291 4726 142
2200753 2200753 2022-02-10 Union Georgia 13291 4710 141
2197499 2197499 2022-02-09 Union Georgia 13291 4698 140
2194245 2194245 2022-02-08 Union Georgia 13291 4657 140
2190991 2190991 2022-02-07 Union Georgia 13291 4640 140
2187738 2187738 2022-02-06 Union Georgia 13291 4612 140
2184485 2184485 2022-02-05 Union Georgia 13291 4612 140
2181233 2181233 2022-02-04 Union Georgia 13291 4612 140
2177982 2177982 2022-02-03 Union Georgia 13291 4530 140

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