ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,902 rows where county = "Warren" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- New Jersey 183
- Kentucky 182
- New York 182
- Ohio 180
- Iowa 176
- Pennsylvania 175
- Indiana 174
- Virginia 174
- Missouri 172
- Mississippi 171
- Georgia 170
- Tennessee 170
- North Carolina 165
- Illinois 158
fips 14
county 1
- Warren · 2,432 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534961 | 534961 | 2020-09-15 | Warren | Georgia | 13301 | 127 | 5 |
535115 | 535115 | 2020-09-15 | Warren | Illinois | 17187 | 288 | 1 |
535209 | 535209 | 2020-09-15 | Warren | Indiana | 18171 | 39 | 1 |
535307 | 535307 | 2020-09-15 | Warren | Iowa | 19181 | 911 | 6 |
535534 | 535534 | 2020-09-15 | Warren | Kentucky | 21227 | 3991 | 40 |
535908 | 535908 | 2020-09-15 | Warren | Mississippi | 28149 | 1360 | 48 |
536027 | 536027 | 2020-09-15 | Warren | Missouri | 29219 | 438 | 0 |
536226 | 536226 | 2020-09-15 | Warren | New Jersey | 34041 | 1438 | 171 |
536313 | 536313 | 2020-09-15 | Warren | New York | 36113 | 348 | 30 |
536411 | 536411 | 2020-09-15 | Warren | North Carolina | 37185 | 302 | 7 |
536558 | 536558 | 2020-09-15 | Warren | Ohio | 39165 | 2795 | 46 |
536738 | 536738 | 2020-09-15 | Warren | Pennsylvania | 42123 | 43 | 1 |
537030 | 537030 | 2020-09-15 | Warren | Tennessee | 47177 | 970 | 8 |
537460 | 537460 | 2020-09-15 | Warren | Virginia | 51187 | 407 | 6 |
531726 | 531726 | 2020-09-14 | Warren | Georgia | 13301 | 126 | 5 |
531880 | 531880 | 2020-09-14 | Warren | Illinois | 17187 | 282 | 1 |
531974 | 531974 | 2020-09-14 | Warren | Indiana | 18171 | 39 | 1 |
532072 | 532072 | 2020-09-14 | Warren | Iowa | 19181 | 906 | 6 |
532299 | 532299 | 2020-09-14 | Warren | Kentucky | 21227 | 3944 | 38 |
532673 | 532673 | 2020-09-14 | Warren | Mississippi | 28149 | 1354 | 48 |
532792 | 532792 | 2020-09-14 | Warren | Missouri | 29219 | 430 | 0 |
532991 | 532991 | 2020-09-14 | Warren | New Jersey | 34041 | 1437 | 171 |
533077 | 533077 | 2020-09-14 | Warren | New York | 36113 | 348 | 30 |
533175 | 533175 | 2020-09-14 | Warren | North Carolina | 37185 | 301 | 7 |
533322 | 533322 | 2020-09-14 | Warren | Ohio | 39165 | 2748 | 46 |
533502 | 533502 | 2020-09-14 | Warren | Pennsylvania | 42123 | 41 | 1 |
533794 | 533794 | 2020-09-14 | Warren | Tennessee | 47177 | 965 | 8 |
534224 | 534224 | 2020-09-14 | Warren | Virginia | 51187 | 405 | 6 |
528489 | 528489 | 2020-09-13 | Warren | Georgia | 13301 | 125 | 5 |
528643 | 528643 | 2020-09-13 | Warren | Illinois | 17187 | 282 | 1 |
528737 | 528737 | 2020-09-13 | Warren | Indiana | 18171 | 39 | 1 |
528835 | 528835 | 2020-09-13 | Warren | Iowa | 19181 | 903 | 6 |
529062 | 529062 | 2020-09-13 | Warren | Kentucky | 21227 | 3942 | 38 |
529437 | 529437 | 2020-09-13 | Warren | Mississippi | 28149 | 1354 | 47 |
529556 | 529556 | 2020-09-13 | Warren | Missouri | 29219 | 419 | 0 |
529755 | 529755 | 2020-09-13 | Warren | New Jersey | 34041 | 1431 | 171 |
529842 | 529842 | 2020-09-13 | Warren | New York | 36113 | 348 | 30 |
529940 | 529940 | 2020-09-13 | Warren | North Carolina | 37185 | 300 | 7 |
530087 | 530087 | 2020-09-13 | Warren | Ohio | 39165 | 2717 | 46 |
530267 | 530267 | 2020-09-13 | Warren | Pennsylvania | 42123 | 40 | 1 |
530559 | 530559 | 2020-09-13 | Warren | Tennessee | 47177 | 953 | 8 |
530989 | 530989 | 2020-09-13 | Warren | Virginia | 51187 | 404 | 6 |
525253 | 525253 | 2020-09-12 | Warren | Georgia | 13301 | 124 | 5 |
525407 | 525407 | 2020-09-12 | Warren | Illinois | 17187 | 282 | 1 |
525501 | 525501 | 2020-09-12 | Warren | Indiana | 18171 | 39 | 1 |
525599 | 525599 | 2020-09-12 | Warren | Iowa | 19181 | 902 | 6 |
525826 | 525826 | 2020-09-12 | Warren | Kentucky | 21227 | 3928 | 37 |
526201 | 526201 | 2020-09-12 | Warren | Mississippi | 28149 | 1352 | 47 |
526320 | 526320 | 2020-09-12 | Warren | Missouri | 29219 | 414 | 0 |
526519 | 526519 | 2020-09-12 | Warren | New Jersey | 34041 | 1431 | 171 |
526605 | 526605 | 2020-09-12 | Warren | New York | 36113 | 348 | 30 |
526703 | 526703 | 2020-09-12 | Warren | North Carolina | 37185 | 298 | 7 |
526850 | 526850 | 2020-09-12 | Warren | Ohio | 39165 | 2692 | 46 |
527030 | 527030 | 2020-09-12 | Warren | Pennsylvania | 42123 | 40 | 1 |
527322 | 527322 | 2020-09-12 | Warren | Tennessee | 47177 | 947 | 8 |
527752 | 527752 | 2020-09-12 | Warren | Virginia | 51187 | 402 | 6 |
522017 | 522017 | 2020-09-11 | Warren | Georgia | 13301 | 124 | 5 |
522171 | 522171 | 2020-09-11 | Warren | Illinois | 17187 | 279 | 1 |
522265 | 522265 | 2020-09-11 | Warren | Indiana | 18171 | 39 | 1 |
522363 | 522363 | 2020-09-11 | Warren | Iowa | 19181 | 891 | 6 |
522590 | 522590 | 2020-09-11 | Warren | Kentucky | 21227 | 3870 | 37 |
522965 | 522965 | 2020-09-11 | Warren | Mississippi | 28149 | 1348 | 47 |
523084 | 523084 | 2020-09-11 | Warren | Missouri | 29219 | 406 | 0 |
523283 | 523283 | 2020-09-11 | Warren | New Jersey | 34041 | 1428 | 171 |
523369 | 523369 | 2020-09-11 | Warren | New York | 36113 | 341 | 30 |
523467 | 523467 | 2020-09-11 | Warren | North Carolina | 37185 | 298 | 7 |
523614 | 523614 | 2020-09-11 | Warren | Ohio | 39165 | 2649 | 46 |
523794 | 523794 | 2020-09-11 | Warren | Pennsylvania | 42123 | 40 | 1 |
524086 | 524086 | 2020-09-11 | Warren | Tennessee | 47177 | 942 | 7 |
524516 | 524516 | 2020-09-11 | Warren | Virginia | 51187 | 400 | 6 |
518780 | 518780 | 2020-09-10 | Warren | Georgia | 13301 | 124 | 5 |
518934 | 518934 | 2020-09-10 | Warren | Illinois | 17187 | 279 | 1 |
519028 | 519028 | 2020-09-10 | Warren | Indiana | 18171 | 39 | 1 |
519126 | 519126 | 2020-09-10 | Warren | Iowa | 19181 | 880 | 6 |
519353 | 519353 | 2020-09-10 | Warren | Kentucky | 21227 | 3819 | 33 |
519728 | 519728 | 2020-09-10 | Warren | Mississippi | 28149 | 1347 | 46 |
519847 | 519847 | 2020-09-10 | Warren | Missouri | 29219 | 395 | 0 |
520046 | 520046 | 2020-09-10 | Warren | New Jersey | 34041 | 1425 | 171 |
520133 | 520133 | 2020-09-10 | Warren | New York | 36113 | 332 | 30 |
520231 | 520231 | 2020-09-10 | Warren | North Carolina | 37185 | 298 | 7 |
520378 | 520378 | 2020-09-10 | Warren | Ohio | 39165 | 2603 | 45 |
520558 | 520558 | 2020-09-10 | Warren | Pennsylvania | 42123 | 40 | 1 |
520850 | 520850 | 2020-09-10 | Warren | Tennessee | 47177 | 930 | 7 |
521280 | 521280 | 2020-09-10 | Warren | Virginia | 51187 | 398 | 6 |
515545 | 515545 | 2020-09-09 | Warren | Georgia | 13301 | 124 | 5 |
515699 | 515699 | 2020-09-09 | Warren | Illinois | 17187 | 277 | 1 |
515793 | 515793 | 2020-09-09 | Warren | Indiana | 18171 | 39 | 1 |
515891 | 515891 | 2020-09-09 | Warren | Iowa | 19181 | 869 | 6 |
516118 | 516118 | 2020-09-09 | Warren | Kentucky | 21227 | 3733 | 33 |
516493 | 516493 | 2020-09-09 | Warren | Mississippi | 28149 | 1342 | 46 |
516612 | 516612 | 2020-09-09 | Warren | Missouri | 29219 | 389 | 0 |
516811 | 516811 | 2020-09-09 | Warren | New Jersey | 34041 | 1423 | 171 |
516897 | 516897 | 2020-09-09 | Warren | New York | 36113 | 331 | 30 |
516995 | 516995 | 2020-09-09 | Warren | North Carolina | 37185 | 298 | 7 |
517142 | 517142 | 2020-09-09 | Warren | Ohio | 39165 | 2555 | 44 |
517322 | 517322 | 2020-09-09 | Warren | Pennsylvania | 42123 | 40 | 1 |
517614 | 517614 | 2020-09-09 | Warren | Tennessee | 47177 | 914 | 7 |
518043 | 518043 | 2020-09-09 | Warren | Virginia | 51187 | 396 | 6 |
512312 | 512312 | 2020-09-08 | Warren | Georgia | 13301 | 124 | 5 |
512466 | 512466 | 2020-09-08 | Warren | Illinois | 17187 | 276 | 1 |
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);