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

13,972 rows where county = "Union" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 18

county 1

  • Union · 13,972 ✖
Link rowid date ▲ county state fips cases deaths
2499755 2499755 2022-05-13 Union Arkansas 5139 9268 176
2499960 2499960 2022-05-13 Union Florida 12125 4321 116
2500109 2500109 2022-05-13 Union Georgia 13291 4888 159
2500267 2500267 2022-05-13 Union Illinois 17181 5415 68
2500360 2500360 2022-05-13 Union Indiana 18161 2027 21
2500460 2500460 2022-05-13 Union Iowa 19175 2720 51
2500691 2500691 2022-05-13 Union Kentucky 21225 4341 57
2500754 2500754 2022-05-13 Union Louisiana 22111 6928 135
2501065 2501065 2022-05-13 Union Mississippi 28145 9487 122
2501391 2501391 2022-05-13 Union New Jersey 34039 151057 2355
2501425 2501425 2022-05-13 Union New Mexico 35059 1007 16
2501575 2501575 2022-05-13 Union North Carolina 37179 62697 490
2501723 2501723 2022-05-13 Union Ohio 39159 15952 102
2501841 2501841 2022-05-13 Union Oregon 41061 5068 80
2501906 2501906 2022-05-13 Union Pennsylvania 42119 11842 154
2502042 2502042 2022-05-13 Union South Carolina 45087 7750 150
2502107 2502107 2022-05-13 Union South Dakota 46127 4026 52
2502197 2502197 2022-05-13 Union Tennessee 47173 5409 75
2496497 2496497 2022-05-12 Union Arkansas 5139 9267 176
2496702 2496702 2022-05-12 Union Florida 12125 4321 116
2496851 2496851 2022-05-12 Union Georgia 13291 4888 159
2497009 2497009 2022-05-12 Union Illinois 17181 5411 68
2497102 2497102 2022-05-12 Union Indiana 18161 2025 21
2497202 2497202 2022-05-12 Union Iowa 19175 2720 51
2497433 2497433 2022-05-12 Union Kentucky 21225 4341 57
2497496 2497496 2022-05-12 Union Louisiana 22111 6928 135
2497807 2497807 2022-05-12 Union Mississippi 28145 9487 122
2498133 2498133 2022-05-12 Union New Jersey 34039 150590 2355
2498167 2498167 2022-05-12 Union New Mexico 35059 1007 16
2498317 2498317 2022-05-12 Union North Carolina 37179 62697 490
2498465 2498465 2022-05-12 Union Ohio 39159 15952 102
2498583 2498583 2022-05-12 Union Oregon 41061 5063 80
2498648 2498648 2022-05-12 Union Pennsylvania 42119 11842 154
2498784 2498784 2022-05-12 Union South Carolina 45087 7750 150
2498849 2498849 2022-05-12 Union South Dakota 46127 4026 52
2498939 2498939 2022-05-12 Union Tennessee 47173 5409 75
2493239 2493239 2022-05-11 Union Arkansas 5139 9267 176
2493444 2493444 2022-05-11 Union Florida 12125 4321 116
2493593 2493593 2022-05-11 Union Georgia 13291 4888 159
2493751 2493751 2022-05-11 Union Illinois 17181 5410 68
2493844 2493844 2022-05-11 Union Indiana 18161 2025 21
2493944 2493944 2022-05-11 Union Iowa 19175 2720 51
2494175 2494175 2022-05-11 Union Kentucky 21225 4341 57
2494238 2494238 2022-05-11 Union Louisiana 22111 6925 135
2494549 2494549 2022-05-11 Union Mississippi 28145 9487 122
2494875 2494875 2022-05-11 Union New Jersey 34039 150301 2354
2494909 2494909 2022-05-11 Union New Mexico 35059 1008 16
2495059 2495059 2022-05-11 Union North Carolina 37179 62697 490
2495207 2495207 2022-05-11 Union Ohio 39159 15823 102
2495325 2495325 2022-05-11 Union Oregon 41061 5063 80
2495390 2495390 2022-05-11 Union Pennsylvania 42119 11842 154
2495526 2495526 2022-05-11 Union South Carolina 45087 7750 150
2495591 2495591 2022-05-11 Union South Dakota 46127 4026 52
2495681 2495681 2022-05-11 Union Tennessee 47173 5409 75
2489981 2489981 2022-05-10 Union Arkansas 5139 9264 176
2490186 2490186 2022-05-10 Union Florida 12125 4321 115
2490335 2490335 2022-05-10 Union Georgia 13291 4885 159
2490493 2490493 2022-05-10 Union Illinois 17181 5408 68
2490586 2490586 2022-05-10 Union Indiana 18161 2023 21
2490686 2490686 2022-05-10 Union Iowa 19175 2717 51
2490917 2490917 2022-05-10 Union Kentucky 21225 4341 57
2490980 2490980 2022-05-10 Union Louisiana 22111 6925 135
2491291 2491291 2022-05-10 Union Mississippi 28145 9487 122
2491617 2491617 2022-05-10 Union New Jersey 34039 150022 2353
2491651 2491651 2022-05-10 Union New Mexico 35059 1007 16
2491801 2491801 2022-05-10 Union North Carolina 37179 62328 489
2491949 2491949 2022-05-10 Union Ohio 39159 15823 102
2492067 2492067 2022-05-10 Union Oregon 41061 5060 80
2492132 2492132 2022-05-10 Union Pennsylvania 42119 11797 154
2492268 2492268 2022-05-10 Union South Carolina 45087 7742 150
2492333 2492333 2022-05-10 Union South Dakota 46127 4012 52
2492423 2492423 2022-05-10 Union Tennessee 47173 5405 75
2486724 2486724 2022-05-09 Union Arkansas 5139 9264 176
2486929 2486929 2022-05-09 Union Florida 12125 4321 115
2487078 2487078 2022-05-09 Union Georgia 13291 4885 159
2487236 2487236 2022-05-09 Union Illinois 17181 5404 68
2487329 2487329 2022-05-09 Union Indiana 18161 2023 21
2487429 2487429 2022-05-09 Union Iowa 19175 2717 51
2487660 2487660 2022-05-09 Union Kentucky 21225 4341 57
2487723 2487723 2022-05-09 Union Louisiana 22111 6925 135
2488034 2488034 2022-05-09 Union Mississippi 28145 9487 122
2488359 2488359 2022-05-09 Union New Jersey 34039 149770 2352
2488393 2488393 2022-05-09 Union New Mexico 35059 1007 16
2488543 2488543 2022-05-09 Union North Carolina 37179 62328 489
2488691 2488691 2022-05-09 Union Ohio 39159 15823 102
2488809 2488809 2022-05-09 Union Oregon 41061 5043 79
2488874 2488874 2022-05-09 Union Pennsylvania 42119 11797 154
2489010 2489010 2022-05-09 Union South Carolina 45087 7742 150
2489075 2489075 2022-05-09 Union South Dakota 46127 4012 52
2489165 2489165 2022-05-09 Union Tennessee 47173 5405 75
2483466 2483466 2022-05-08 Union Arkansas 5139 9264 176
2483671 2483671 2022-05-08 Union Florida 12125 4321 115
2483820 2483820 2022-05-08 Union Georgia 13291 4885 159
2483978 2483978 2022-05-08 Union Illinois 17181 5392 68
2484071 2484071 2022-05-08 Union Indiana 18161 2022 21
2484171 2484171 2022-05-08 Union Iowa 19175 2717 51
2484402 2484402 2022-05-08 Union Kentucky 21225 4341 57
2484465 2484465 2022-05-08 Union Louisiana 22111 6924 135
2484776 2484776 2022-05-08 Union Mississippi 28145 9480 122
2485102 2485102 2022-05-08 Union New Jersey 34039 149624 2352

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