ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,972 rows where county = "Union" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 18
- New Jersey 139
- Ohio 129
- Oregon 129
- Mississippi 127
- North Carolina 127
- Arkansas 124
- South Carolina 124
- Louisiana 123
- Kentucky 122
- South Dakota 122
- Tennessee 121
- Pennsylvania 119
- Florida 117
- Georgia 116
- Indiana 113
- Iowa 107
- Illinois 102
- New Mexico 93
fips 18
county 1
- Union · 2,154 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
371681 | 371681 | 2020-07-26 | Union | New Mexico | 35059 | 24 | 0 |
371830 | 371830 | 2020-07-26 | Union | North Carolina | 37179 | 2503 | 35 |
371975 | 371975 | 2020-07-26 | Union | Ohio | 39159 | 178 | 1 |
372091 | 372091 | 2020-07-26 | Union | Oregon | 41061 | 385 | 2 |
372155 | 372155 | 2020-07-26 | Union | Pennsylvania | 42119 | 123 | 2 |
372291 | 372291 | 2020-07-26 | Union | South Carolina | 45087 | 270 | 1 |
372355 | 372355 | 2020-07-26 | Union | South Dakota | 46127 | 175 | 2 |
372445 | 372445 | 2020-07-26 | Union | Tennessee | 47173 | 77 | 0 |
366831 | 366831 | 2020-07-25 | Union | Arkansas | 5139 | 361 | 15 |
367034 | 367034 | 2020-07-25 | Union | Florida | 12125 | 183 | 4 |
367183 | 367183 | 2020-07-25 | Union | Georgia | 13291 | 167 | 6 |
367336 | 367336 | 2020-07-25 | Union | Illinois | 17181 | 266 | 21 |
367429 | 367429 | 2020-07-25 | Union | Indiana | 18161 | 44 | 0 |
367528 | 367528 | 2020-07-25 | Union | Iowa | 19175 | 64 | 1 |
367756 | 367756 | 2020-07-25 | Union | Kentucky | 21225 | 45 | 0 |
367819 | 367819 | 2020-07-25 | Union | Louisiana | 22111 | 533 | 31 |
368130 | 368130 | 2020-07-25 | Union | Mississippi | 28145 | 402 | 12 |
368436 | 368436 | 2020-07-25 | Union | New Jersey | 34039 | 16510 | 1345 |
368469 | 368469 | 2020-07-25 | Union | New Mexico | 35059 | 22 | 0 |
368618 | 368618 | 2020-07-25 | Union | North Carolina | 37179 | 2470 | 35 |
368763 | 368763 | 2020-07-25 | Union | Ohio | 39159 | 169 | 1 |
368879 | 368879 | 2020-07-25 | Union | Oregon | 41061 | 385 | 2 |
368943 | 368943 | 2020-07-25 | Union | Pennsylvania | 42119 | 119 | 2 |
369079 | 369079 | 2020-07-25 | Union | South Carolina | 45087 | 262 | 1 |
369143 | 369143 | 2020-07-25 | Union | South Dakota | 46127 | 172 | 2 |
369233 | 369233 | 2020-07-25 | Union | Tennessee | 47173 | 76 | 0 |
363624 | 363624 | 2020-07-24 | Union | Arkansas | 5139 | 350 | 15 |
363827 | 363827 | 2020-07-24 | Union | Florida | 12125 | 178 | 3 |
363976 | 363976 | 2020-07-24 | Union | Georgia | 13291 | 162 | 5 |
364129 | 364129 | 2020-07-24 | Union | Illinois | 17181 | 262 | 21 |
364222 | 364222 | 2020-07-24 | Union | Indiana | 18161 | 43 | 0 |
364321 | 364321 | 2020-07-24 | Union | Iowa | 19175 | 61 | 1 |
364549 | 364549 | 2020-07-24 | Union | Kentucky | 21225 | 44 | 0 |
364612 | 364612 | 2020-07-24 | Union | Louisiana | 22111 | 533 | 31 |
364922 | 364922 | 2020-07-24 | Union | Mississippi | 28145 | 391 | 12 |
365227 | 365227 | 2020-07-24 | Union | New Jersey | 34039 | 16496 | 1345 |
365260 | 365260 | 2020-07-24 | Union | New Mexico | 35059 | 22 | 0 |
365409 | 365409 | 2020-07-24 | Union | North Carolina | 37179 | 2416 | 35 |
365554 | 365554 | 2020-07-24 | Union | Ohio | 39159 | 168 | 1 |
365670 | 365670 | 2020-07-24 | Union | Oregon | 41061 | 385 | 2 |
365734 | 365734 | 2020-07-24 | Union | Pennsylvania | 42119 | 116 | 2 |
365870 | 365870 | 2020-07-24 | Union | South Carolina | 45087 | 255 | 1 |
365934 | 365934 | 2020-07-24 | Union | South Dakota | 46127 | 171 | 2 |
366024 | 366024 | 2020-07-24 | Union | Tennessee | 47173 | 73 | 0 |
360417 | 360417 | 2020-07-23 | Union | Arkansas | 5139 | 345 | 15 |
360620 | 360620 | 2020-07-23 | Union | Florida | 12125 | 169 | 3 |
360769 | 360769 | 2020-07-23 | Union | Georgia | 13291 | 151 | 4 |
360922 | 360922 | 2020-07-23 | Union | Illinois | 17181 | 256 | 21 |
361015 | 361015 | 2020-07-23 | Union | Indiana | 18161 | 41 | 0 |
361114 | 361114 | 2020-07-23 | Union | Iowa | 19175 | 59 | 1 |
361342 | 361342 | 2020-07-23 | Union | Kentucky | 21225 | 42 | 0 |
361405 | 361405 | 2020-07-23 | Union | Louisiana | 22111 | 525 | 31 |
361715 | 361715 | 2020-07-23 | Union | Mississippi | 28145 | 374 | 11 |
362021 | 362021 | 2020-07-23 | Union | New Jersey | 34039 | 16472 | 1343 |
362054 | 362054 | 2020-07-23 | Union | New Mexico | 35059 | 17 | 0 |
362203 | 362203 | 2020-07-23 | Union | North Carolina | 37179 | 2356 | 34 |
362348 | 362348 | 2020-07-23 | Union | Ohio | 39159 | 163 | 1 |
362464 | 362464 | 2020-07-23 | Union | Oregon | 41061 | 385 | 2 |
362528 | 362528 | 2020-07-23 | Union | Pennsylvania | 42119 | 115 | 2 |
362664 | 362664 | 2020-07-23 | Union | South Carolina | 45087 | 249 | 1 |
362728 | 362728 | 2020-07-23 | Union | South Dakota | 46127 | 168 | 2 |
362818 | 362818 | 2020-07-23 | Union | Tennessee | 47173 | 61 | 0 |
357212 | 357212 | 2020-07-22 | Union | Arkansas | 5139 | 335 | 14 |
357415 | 357415 | 2020-07-22 | Union | Florida | 12125 | 161 | 3 |
357564 | 357564 | 2020-07-22 | Union | Georgia | 13291 | 147 | 4 |
357717 | 357717 | 2020-07-22 | Union | Illinois | 17181 | 255 | 21 |
357810 | 357810 | 2020-07-22 | Union | Indiana | 18161 | 41 | 0 |
357909 | 357909 | 2020-07-22 | Union | Iowa | 19175 | 59 | 1 |
358137 | 358137 | 2020-07-22 | Union | Kentucky | 21225 | 40 | 0 |
358200 | 358200 | 2020-07-22 | Union | Louisiana | 22111 | 519 | 30 |
358510 | 358510 | 2020-07-22 | Union | Mississippi | 28145 | 353 | 11 |
358815 | 358815 | 2020-07-22 | Union | New Jersey | 34039 | 16526 | 1342 |
358848 | 358848 | 2020-07-22 | Union | New Mexico | 35059 | 14 | 0 |
358997 | 358997 | 2020-07-22 | Union | North Carolina | 37179 | 2287 | 33 |
359142 | 359142 | 2020-07-22 | Union | Ohio | 39159 | 162 | 1 |
359258 | 359258 | 2020-07-22 | Union | Oregon | 41061 | 385 | 2 |
359322 | 359322 | 2020-07-22 | Union | Pennsylvania | 42119 | 113 | 2 |
359458 | 359458 | 2020-07-22 | Union | South Carolina | 45087 | 238 | 0 |
359521 | 359521 | 2020-07-22 | Union | South Dakota | 46127 | 166 | 2 |
359611 | 359611 | 2020-07-22 | Union | Tennessee | 47173 | 59 | 0 |
354009 | 354009 | 2020-07-21 | Union | Arkansas | 5139 | 333 | 14 |
354212 | 354212 | 2020-07-21 | Union | Florida | 12125 | 145 | 3 |
354361 | 354361 | 2020-07-21 | Union | Georgia | 13291 | 144 | 5 |
354515 | 354515 | 2020-07-21 | Union | Illinois | 17181 | 241 | 21 |
354608 | 354608 | 2020-07-21 | Union | Indiana | 18161 | 39 | 0 |
354707 | 354707 | 2020-07-21 | Union | Iowa | 19175 | 56 | 1 |
354934 | 354934 | 2020-07-21 | Union | Kentucky | 21225 | 40 | 0 |
354997 | 354997 | 2020-07-21 | Union | Louisiana | 22111 | 511 | 30 |
355307 | 355307 | 2020-07-21 | Union | Mississippi | 28145 | 338 | 11 |
355611 | 355611 | 2020-07-21 | Union | New Jersey | 34039 | 16694 | 1346 |
355644 | 355644 | 2020-07-21 | Union | New Mexico | 35059 | 14 | 0 |
355793 | 355793 | 2020-07-21 | Union | North Carolina | 37179 | 2251 | 33 |
355938 | 355938 | 2020-07-21 | Union | Ohio | 39159 | 152 | 1 |
356054 | 356054 | 2020-07-21 | Union | Oregon | 41061 | 385 | 2 |
356118 | 356118 | 2020-07-21 | Union | Pennsylvania | 42119 | 113 | 2 |
356254 | 356254 | 2020-07-21 | Union | South Carolina | 45087 | 224 | 0 |
356317 | 356317 | 2020-07-21 | Union | South Dakota | 46127 | 166 | 2 |
356407 | 356407 | 2020-07-21 | Union | Tennessee | 47173 | 56 | 0 |
350807 | 350807 | 2020-07-20 | Union | Arkansas | 5139 | 313 | 14 |
351010 | 351010 | 2020-07-20 | Union | Florida | 12125 | 142 | 3 |
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);