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 207
- Kentucky 206
- New York 206
- Ohio 204
- Iowa 200
- Pennsylvania 199
- Indiana 198
- Virginia 198
- Missouri 196
- Mississippi 195
- Tennessee 194
- Georgia 193
- North Carolina 189
- Illinois 181
fips 14
county 1
- Warren · 2,766 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
612970 | 612970 | 2020-10-09 | Warren | Indiana | 18171 | 51 | 1 |
613068 | 613068 | 2020-10-09 | Warren | Iowa | 19181 | 1033 | 6 |
613295 | 613295 | 2020-10-09 | Warren | Kentucky | 21227 | 4635 | 56 |
613670 | 613670 | 2020-10-09 | Warren | Mississippi | 28149 | 1459 | 53 |
613789 | 613789 | 2020-10-09 | Warren | Missouri | 29219 | 584 | 1 |
613992 | 613992 | 2020-10-09 | Warren | New Jersey | 34041 | 1485 | 171 |
614078 | 614078 | 2020-10-09 | Warren | New York | 36113 | 429 | 30 |
614176 | 614176 | 2020-10-09 | Warren | North Carolina | 37185 | 373 | 7 |
614322 | 614322 | 2020-10-09 | Warren | Ohio | 39165 | 3468 | 59 |
614502 | 614502 | 2020-10-09 | Warren | Pennsylvania | 42123 | 50 | 1 |
614794 | 614794 | 2020-10-09 | Warren | Tennessee | 47177 | 1184 | 9 |
615225 | 615225 | 2020-10-09 | Warren | Virginia | 51187 | 473 | 13 |
609480 | 609480 | 2020-10-08 | Warren | Georgia | 13301 | 176 | 5 |
609634 | 609634 | 2020-10-08 | Warren | Illinois | 17187 | 373 | 3 |
609728 | 609728 | 2020-10-08 | Warren | Indiana | 18171 | 49 | 1 |
609826 | 609826 | 2020-10-08 | Warren | Iowa | 19181 | 1023 | 6 |
610053 | 610053 | 2020-10-08 | Warren | Kentucky | 21227 | 4608 | 56 |
610428 | 610428 | 2020-10-08 | Warren | Mississippi | 28149 | 1452 | 53 |
610547 | 610547 | 2020-10-08 | Warren | Missouri | 29219 | 566 | 1 |
610751 | 610751 | 2020-10-08 | Warren | New Jersey | 34041 | 1484 | 171 |
610837 | 610837 | 2020-10-08 | Warren | New York | 36113 | 427 | 30 |
610935 | 610935 | 2020-10-08 | Warren | North Carolina | 37185 | 370 | 7 |
611081 | 611081 | 2020-10-08 | Warren | Ohio | 39165 | 3414 | 59 |
611261 | 611261 | 2020-10-08 | Warren | Pennsylvania | 42123 | 46 | 1 |
611553 | 611553 | 2020-10-08 | Warren | Tennessee | 47177 | 1180 | 9 |
611984 | 611984 | 2020-10-08 | Warren | Virginia | 51187 | 467 | 12 |
606237 | 606237 | 2020-10-07 | Warren | Georgia | 13301 | 175 | 5 |
606391 | 606391 | 2020-10-07 | Warren | Illinois | 17187 | 369 | 3 |
606485 | 606485 | 2020-10-07 | Warren | Indiana | 18171 | 48 | 1 |
606583 | 606583 | 2020-10-07 | Warren | Iowa | 19181 | 1012 | 6 |
606811 | 606811 | 2020-10-07 | Warren | Kentucky | 21227 | 4589 | 55 |
607186 | 607186 | 2020-10-07 | Warren | Mississippi | 28149 | 1443 | 52 |
607305 | 607305 | 2020-10-07 | Warren | Missouri | 29219 | 558 | 1 |
607509 | 607509 | 2020-10-07 | Warren | New Jersey | 34041 | 1478 | 171 |
607595 | 607595 | 2020-10-07 | Warren | New York | 36113 | 425 | 30 |
607693 | 607693 | 2020-10-07 | Warren | North Carolina | 37185 | 366 | 7 |
607839 | 607839 | 2020-10-07 | Warren | Ohio | 39165 | 3365 | 59 |
608019 | 608019 | 2020-10-07 | Warren | Pennsylvania | 42123 | 46 | 1 |
608311 | 608311 | 2020-10-07 | Warren | Tennessee | 47177 | 1162 | 9 |
608742 | 608742 | 2020-10-07 | Warren | Virginia | 51187 | 460 | 12 |
602995 | 602995 | 2020-10-06 | Warren | Georgia | 13301 | 175 | 5 |
603149 | 603149 | 2020-10-06 | Warren | Illinois | 17187 | 363 | 3 |
603243 | 603243 | 2020-10-06 | Warren | Indiana | 18171 | 44 | 1 |
603341 | 603341 | 2020-10-06 | Warren | Iowa | 19181 | 1004 | 6 |
603569 | 603569 | 2020-10-06 | Warren | Kentucky | 21227 | 4561 | 55 |
603943 | 603943 | 2020-10-06 | Warren | Mississippi | 28149 | 1438 | 52 |
604062 | 604062 | 2020-10-06 | Warren | Missouri | 29219 | 556 | 1 |
604266 | 604266 | 2020-10-06 | Warren | New Jersey | 34041 | 1476 | 171 |
604352 | 604352 | 2020-10-06 | Warren | New York | 36113 | 419 | 30 |
604450 | 604450 | 2020-10-06 | Warren | North Carolina | 37185 | 365 | 7 |
604596 | 604596 | 2020-10-06 | Warren | Ohio | 39165 | 3324 | 58 |
604776 | 604776 | 2020-10-06 | Warren | Pennsylvania | 42123 | 46 | 1 |
605068 | 605068 | 2020-10-06 | Warren | Tennessee | 47177 | 1140 | 8 |
605499 | 605499 | 2020-10-06 | Warren | Virginia | 51187 | 460 | 11 |
599752 | 599752 | 2020-10-05 | Warren | Georgia | 13301 | 174 | 5 |
599906 | 599906 | 2020-10-05 | Warren | Illinois | 17187 | 357 | 3 |
600000 | 600000 | 2020-10-05 | Warren | Indiana | 18171 | 44 | 1 |
600098 | 600098 | 2020-10-05 | Warren | Iowa | 19181 | 997 | 6 |
600326 | 600326 | 2020-10-05 | Warren | Kentucky | 21227 | 4534 | 55 |
600701 | 600701 | 2020-10-05 | Warren | Mississippi | 28149 | 1431 | 51 |
600820 | 600820 | 2020-10-05 | Warren | Missouri | 29219 | 548 | 1 |
601024 | 601024 | 2020-10-05 | Warren | New Jersey | 34041 | 1474 | 171 |
601110 | 601110 | 2020-10-05 | Warren | New York | 36113 | 416 | 30 |
601208 | 601208 | 2020-10-05 | Warren | North Carolina | 37185 | 363 | 7 |
601354 | 601354 | 2020-10-05 | Warren | Ohio | 39165 | 3271 | 58 |
601534 | 601534 | 2020-10-05 | Warren | Pennsylvania | 42123 | 45 | 1 |
601826 | 601826 | 2020-10-05 | Warren | Tennessee | 47177 | 1135 | 8 |
602257 | 602257 | 2020-10-05 | Warren | Virginia | 51187 | 453 | 10 |
596509 | 596509 | 2020-10-04 | Warren | Georgia | 13301 | 158 | 5 |
596664 | 596664 | 2020-10-04 | Warren | Illinois | 17187 | 354 | 3 |
596758 | 596758 | 2020-10-04 | Warren | Indiana | 18171 | 44 | 1 |
596856 | 596856 | 2020-10-04 | Warren | Iowa | 19181 | 998 | 6 |
597084 | 597084 | 2020-10-04 | Warren | Kentucky | 21227 | 4490 | 55 |
597458 | 597458 | 2020-10-04 | Warren | Mississippi | 28149 | 1429 | 51 |
597577 | 597577 | 2020-10-04 | Warren | Missouri | 29219 | 543 | 1 |
597780 | 597780 | 2020-10-04 | Warren | New Jersey | 34041 | 1471 | 171 |
597867 | 597867 | 2020-10-04 | Warren | New York | 36113 | 413 | 30 |
597965 | 597965 | 2020-10-04 | Warren | North Carolina | 37185 | 363 | 7 |
598111 | 598111 | 2020-10-04 | Warren | Ohio | 39165 | 3265 | 58 |
598291 | 598291 | 2020-10-04 | Warren | Pennsylvania | 42123 | 45 | 1 |
598583 | 598583 | 2020-10-04 | Warren | Tennessee | 47177 | 1120 | 8 |
599014 | 599014 | 2020-10-04 | Warren | Virginia | 51187 | 449 | 10 |
593267 | 593267 | 2020-10-03 | Warren | Georgia | 13301 | 156 | 5 |
593422 | 593422 | 2020-10-03 | Warren | Illinois | 17187 | 351 | 3 |
593516 | 593516 | 2020-10-03 | Warren | Indiana | 18171 | 44 | 1 |
593614 | 593614 | 2020-10-03 | Warren | Iowa | 19181 | 995 | 6 |
593842 | 593842 | 2020-10-03 | Warren | Kentucky | 21227 | 4488 | 54 |
594217 | 594217 | 2020-10-03 | Warren | Mississippi | 28149 | 1428 | 50 |
594336 | 594336 | 2020-10-03 | Warren | Missouri | 29219 | 543 | 1 |
594538 | 594538 | 2020-10-03 | Warren | New Jersey | 34041 | 1469 | 171 |
594624 | 594624 | 2020-10-03 | Warren | New York | 36113 | 407 | 30 |
594722 | 594722 | 2020-10-03 | Warren | North Carolina | 37185 | 361 | 7 |
594868 | 594868 | 2020-10-03 | Warren | Ohio | 39165 | 3241 | 58 |
595048 | 595048 | 2020-10-03 | Warren | Pennsylvania | 42123 | 44 | 1 |
595340 | 595340 | 2020-10-03 | Warren | Tennessee | 47177 | 1113 | 8 |
595771 | 595771 | 2020-10-03 | Warren | Virginia | 51187 | 448 | 10 |
590027 | 590027 | 2020-10-02 | Warren | Georgia | 13301 | 156 | 5 |
590181 | 590181 | 2020-10-02 | Warren | Illinois | 17187 | 343 | 3 |
590275 | 590275 | 2020-10-02 | Warren | Indiana | 18171 | 43 | 1 |
590373 | 590373 | 2020-10-02 | Warren | Iowa | 19181 | 994 | 6 |
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);