ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23,678 rows where fips = "" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 54
- Missouri 1,511
- New York 814
- Rhode Island 804
- New Jersey 793
- Puerto Rico 792
- Guam 790
- Massachusetts 789
- Louisiana 786
- Arkansas 785
- Georgia 784
- Vermont 782
- Minnesota 779
- Michigan 778
- Connecticut 775
- Utah 775
- Florida 772
- Delaware 762
- Maryland 761
- Iowa 743
- New Hampshire 735
- North Dakota 717
- Tennessee 711
- Alaska 703
- Illinois 667
- Oklahoma 640
- Maine 599
- Nebraska 519
- Ohio 439
- Northern Mariana Islands 380
- Hawaii 294
- Kansas 246
- American Samoa 239
- Virgin Islands 188
- Washington 180
- New Mexico 164
- Wisconsin 135
- Nevada 117
- Arizona 99
- Mississippi 68
- Colorado 64
- Kentucky 42
- Indiana 40
- Virginia 39
- Texas 21
- California 17
- Idaho 12
- Oregon 7
- South Dakota 5
- West Virginia 4
- Wyoming 4
- South Carolina 3
- Montana 2
- Pennsylvania 2
- North Carolina 1
county 4
- Unknown 21,401
- New York City 804
- Kansas City 785
- Joplin 688
fips 1
- - · 23,678 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
417 | 417 | 2020-03-01 | New York City | New York | 1 | 0 | |
419 | 419 | 2020-03-01 | Unknown | Rhode Island | 2 | 0 | |
449 | 449 | 2020-03-02 | New York City | New York | 1 | 0 | |
451 | 451 | 2020-03-02 | Unknown | Rhode Island | 2 | 0 | |
483 | 483 | 2020-03-03 | New York City | New York | 2 | 0 | |
486 | 486 | 2020-03-03 | Unknown | Rhode Island | 2 | 0 | |
519 | 519 | 2020-03-04 | New York City | New York | 2 | 0 | |
523 | 523 | 2020-03-04 | Unknown | Rhode Island | 2 | 0 | |
566 | 566 | 2020-03-05 | New York City | New York | 4 | 0 | |
570 | 570 | 2020-03-05 | Unknown | Rhode Island | 2 | 0 | |
628 | 628 | 2020-03-06 | New York City | New York | 5 | 0 | |
637 | 637 | 2020-03-06 | Unknown | Rhode Island | 3 | 0 | |
716 | 716 | 2020-03-07 | New York City | New York | 12 | 0 | |
729 | 729 | 2020-03-07 | Unknown | Rhode Island | 3 | 0 | |
821 | 821 | 2020-03-08 | New York City | New York | 14 | 0 | |
838 | 838 | 2020-03-08 | Unknown | Rhode Island | 3 | 0 | |
948 | 948 | 2020-03-09 | New York City | New York | 20 | 0 | |
967 | 967 | 2020-03-09 | Unknown | Rhode Island | 3 | 0 | |
1099 | 1099 | 2020-03-10 | New York City | New York | 37 | 0 | |
1120 | 1120 | 2020-03-10 | Unknown | Rhode Island | 5 | 0 | |
1286 | 1286 | 2020-03-11 | New York City | New York | 52 | 0 | |
1314 | 1314 | 2020-03-11 | Unknown | Rhode Island | 5 | 0 | |
1512 | 1512 | 2020-03-12 | Unknown | New Jersey | 1 | 0 | |
1522 | 1522 | 2020-03-12 | New York City | New York | 96 | 0 | |
1560 | 1560 | 2020-03-12 | Unknown | Rhode Island | 5 | 0 | |
1805 | 1805 | 2020-03-13 | Unknown | New Jersey | 1 | 0 | |
1815 | 1815 | 2020-03-13 | New York City | New York | 155 | 0 | |
1859 | 1859 | 2020-03-13 | Unknown | Puerto Rico | 3 | 0 | |
1860 | 1860 | 2020-03-13 | Unknown | Rhode Island | 20 | 0 | |
2152 | 2152 | 2020-03-14 | Unknown | New Jersey | 1 | 0 | |
2164 | 2164 | 2020-03-14 | New York City | New York | 269 | 1 | |
2221 | 2221 | 2020-03-14 | Unknown | Puerto Rico | 4 | 0 | |
2222 | 2222 | 2020-03-14 | Unknown | Rhode Island | 20 | 0 | |
2268 | 2268 | 2020-03-14 | Unknown | Virgin Islands | 1 | 0 | |
2423 | 2423 | 2020-03-15 | Unknown | Guam | 3 | 0 | |
2560 | 2560 | 2020-03-15 | Unknown | New Jersey | 1 | 0 | |
2575 | 2575 | 2020-03-15 | New York City | New York | 330 | 5 | |
2643 | 2643 | 2020-03-15 | Unknown | Puerto Rico | 5 | 0 | |
2644 | 2644 | 2020-03-15 | Unknown | Rhode Island | 20 | 0 | |
2695 | 2695 | 2020-03-15 | Unknown | Virgin Islands | 1 | 0 | |
2864 | 2864 | 2020-03-16 | Unknown | Guam | 3 | 0 | |
2930 | 2930 | 2020-03-16 | Unknown | Maine | 1 | 0 | |
2951 | 2951 | 2020-03-16 | Unknown | Massachusetts | 1 | 0 | |
3018 | 3018 | 2020-03-16 | Unknown | New Jersey | 1 | 0 | |
3034 | 3034 | 2020-03-16 | New York City | New York | 464 | 7 | |
3108 | 3108 | 2020-03-16 | Unknown | Puerto Rico | 5 | 0 | |
3109 | 3109 | 2020-03-16 | Unknown | Rhode Island | 21 | 0 | |
3167 | 3167 | 2020-03-16 | Unknown | Virgin Islands | 2 | 0 | |
3351 | 3351 | 2020-03-17 | Unknown | Guam | 3 | 0 | |
3430 | 3430 | 2020-03-17 | Unknown | Maine | 3 | 0 | |
3452 | 3452 | 2020-03-17 | Unknown | Massachusetts | 1 | 0 | |
3531 | 3531 | 2020-03-17 | Unknown | New Jersey | 1 | 0 | |
3550 | 3550 | 2020-03-17 | New York City | New York | 646 | 11 | |
3638 | 3638 | 2020-03-17 | Unknown | Puerto Rico | 5 | 0 | |
3639 | 3639 | 2020-03-17 | Unknown | Rhode Island | 23 | 0 | |
3703 | 3703 | 2020-03-17 | Unknown | Virgin Islands | 2 | 0 | |
3913 | 3913 | 2020-03-18 | Unknown | Guam | 8 | 0 | |
4004 | 4004 | 2020-03-18 | Unknown | Louisiana | 2 | 0 | |
4012 | 4012 | 2020-03-18 | Unknown | Maine | 3 | 0 | |
4035 | 4035 | 2020-03-18 | Unknown | Massachusetts | 4 | 0 | |
4127 | 4127 | 2020-03-18 | Unknown | New Jersey | 1 | 0 | |
4151 | 4151 | 2020-03-18 | New York City | New York | 1344 | 25 | |
4257 | 4257 | 2020-03-18 | Unknown | Puerto Rico | 5 | 0 | |
4258 | 4258 | 2020-03-18 | Unknown | Rhode Island | 33 | 0 | |
4335 | 4335 | 2020-03-18 | Unknown | Virgin Islands | 3 | 0 | |
4589 | 4589 | 2020-03-19 | Unknown | Guam | 12 | 0 | |
4681 | 4681 | 2020-03-19 | Unknown | Kentucky | 1 | 0 | |
4704 | 4704 | 2020-03-19 | Unknown | Louisiana | 3 | 0 | |
4714 | 4714 | 2020-03-19 | Unknown | Maine | 3 | 0 | |
4740 | 4740 | 2020-03-19 | Unknown | Massachusetts | 13 | 0 | |
4829 | 4829 | 2020-03-19 | Unknown | Nevada | 4 | 0 | |
4855 | 4855 | 2020-03-19 | Unknown | New Jersey | 1 | 0 | |
4880 | 4880 | 2020-03-19 | New York City | New York | 2477 | 31 | |
4999 | 4999 | 2020-03-19 | Unknown | Puerto Rico | 6 | 0 | |
5000 | 5000 | 2020-03-19 | Unknown | Rhode Island | 44 | 0 | |
5039 | 5039 | 2020-03-19 | Unknown | Tennessee | 2 | 0 | |
5091 | 5091 | 2020-03-19 | Unknown | Virgin Islands | 3 | 0 | |
5224 | 5224 | 2020-03-20 | Unknown | Arkansas | 19 | 0 | |
5386 | 5386 | 2020-03-20 | Unknown | Georgia | 6 | 0 | |
5389 | 5389 | 2020-03-20 | Unknown | Guam | 14 | 0 | |
5495 | 5495 | 2020-03-20 | Unknown | Kentucky | 1 | 0 | |
5522 | 5522 | 2020-03-20 | Unknown | Louisiana | 5 | 0 | |
5532 | 5532 | 2020-03-20 | Unknown | Maine | 3 | 0 | |
5559 | 5559 | 2020-03-20 | Unknown | Massachusetts | 18 | 0 | |
5642 | 5642 | 2020-03-20 | Kansas City | Missouri | 12 | 0 | |
5648 | 5648 | 2020-03-20 | Unknown | Missouri | 1 | 0 | |
5671 | 5671 | 2020-03-20 | Unknown | Nevada | 11 | 0 | |
5699 | 5699 | 2020-03-20 | Unknown | New Jersey | 3 | 0 | |
5729 | 5729 | 2020-03-20 | New York City | New York | 4419 | 54 | |
5872 | 5872 | 2020-03-20 | Unknown | Puerto Rico | 14 | 0 | |
5873 | 5873 | 2020-03-20 | Unknown | Rhode Island | 44 | 0 | |
5928 | 5928 | 2020-03-20 | Unknown | Tennessee | 2 | 0 | |
5987 | 5987 | 2020-03-20 | Unknown | Virgin Islands | 6 | 0 | |
6143 | 6143 | 2020-03-21 | Unknown | Arkansas | 21 | 0 | |
6320 | 6320 | 2020-03-21 | Unknown | Georgia | 27 | 0 | |
6323 | 6323 | 2020-03-21 | Unknown | Guam | 15 | 0 | |
6443 | 6443 | 2020-03-21 | Unknown | Kentucky | 5 | 0 | |
6477 | 6477 | 2020-03-21 | Unknown | Louisiana | 9 | 0 | |
6488 | 6488 | 2020-03-21 | Unknown | Maine | 3 | 0 | |
6519 | 6519 | 2020-03-21 | Unknown | Massachusetts | 26 | 0 |
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);