ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,547 rows where county = "Jones" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Mississippi 341
- Georgia 335
- Iowa 330
- Texas 321
- North Carolina 320
- South Dakota 230
county 1
- Jones · 1,877 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053979 | 1053979 | 2021-02-22 | Jones | Georgia | 13169 | 1874 | 40 |
1054353 | 1054353 | 2021-02-22 | Jones | Iowa | 19105 | 2835 | 54 |
1054954 | 1054954 | 2021-02-22 | Jones | Mississippi | 28067 | 7825 | 142 |
1055461 | 1055461 | 2021-02-22 | Jones | North Carolina | 37103 | 700 | 16 |
1056002 | 1056002 | 2021-02-22 | Jones | South Dakota | 46075 | 85 | 0 |
1056254 | 1056254 | 2021-02-22 | Jones | Texas | 48253 | 2735 | 47 |
1050732 | 1050732 | 2021-02-21 | Jones | Georgia | 13169 | 1872 | 39 |
1051106 | 1051106 | 2021-02-21 | Jones | Iowa | 19105 | 2835 | 54 |
1051707 | 1051707 | 2021-02-21 | Jones | Mississippi | 28067 | 7814 | 142 |
1052215 | 1052215 | 2021-02-21 | Jones | North Carolina | 37103 | 697 | 16 |
1052756 | 1052756 | 2021-02-21 | Jones | South Dakota | 46075 | 85 | 0 |
1053008 | 1053008 | 2021-02-21 | Jones | Texas | 48253 | 2735 | 47 |
1047485 | 1047485 | 2021-02-20 | Jones | Georgia | 13169 | 1867 | 39 |
1047859 | 1047859 | 2021-02-20 | Jones | Iowa | 19105 | 2835 | 54 |
1048460 | 1048460 | 2021-02-20 | Jones | Mississippi | 28067 | 7790 | 142 |
1048968 | 1048968 | 2021-02-20 | Jones | North Carolina | 37103 | 692 | 16 |
1049509 | 1049509 | 2021-02-20 | Jones | South Dakota | 46075 | 84 | 0 |
1049761 | 1049761 | 2021-02-20 | Jones | Texas | 48253 | 2735 | 47 |
1044240 | 1044240 | 2021-02-19 | Jones | Georgia | 13169 | 1856 | 38 |
1044614 | 1044614 | 2021-02-19 | Jones | Iowa | 19105 | 2835 | 54 |
1045214 | 1045214 | 2021-02-19 | Jones | Mississippi | 28067 | 7772 | 142 |
1045721 | 1045721 | 2021-02-19 | Jones | North Carolina | 37103 | 687 | 16 |
1046262 | 1046262 | 2021-02-19 | Jones | South Dakota | 46075 | 84 | 0 |
1046514 | 1046514 | 2021-02-19 | Jones | Texas | 48253 | 2729 | 46 |
1040995 | 1040995 | 2021-02-18 | Jones | Georgia | 13169 | 1847 | 38 |
1041369 | 1041369 | 2021-02-18 | Jones | Iowa | 19105 | 2834 | 54 |
1041969 | 1041969 | 2021-02-18 | Jones | Mississippi | 28067 | 7753 | 142 |
1042476 | 1042476 | 2021-02-18 | Jones | North Carolina | 37103 | 681 | 16 |
1043017 | 1043017 | 2021-02-18 | Jones | South Dakota | 46075 | 84 | 0 |
1043269 | 1043269 | 2021-02-18 | Jones | Texas | 48253 | 2729 | 46 |
1037750 | 1037750 | 2021-02-17 | Jones | Georgia | 13169 | 1837 | 38 |
1038124 | 1038124 | 2021-02-17 | Jones | Iowa | 19105 | 2834 | 54 |
1038724 | 1038724 | 2021-02-17 | Jones | Mississippi | 28067 | 7747 | 142 |
1039231 | 1039231 | 2021-02-17 | Jones | North Carolina | 37103 | 675 | 16 |
1039772 | 1039772 | 2021-02-17 | Jones | South Dakota | 46075 | 83 | 0 |
1040024 | 1040024 | 2021-02-17 | Jones | Texas | 48253 | 2729 | 46 |
1034505 | 1034505 | 2021-02-16 | Jones | Georgia | 13169 | 1820 | 38 |
1034879 | 1034879 | 2021-02-16 | Jones | Iowa | 19105 | 2830 | 54 |
1035479 | 1035479 | 2021-02-16 | Jones | Mississippi | 28067 | 7720 | 140 |
1035986 | 1035986 | 2021-02-16 | Jones | North Carolina | 37103 | 668 | 16 |
1036527 | 1036527 | 2021-02-16 | Jones | South Dakota | 46075 | 83 | 0 |
1036779 | 1036779 | 2021-02-16 | Jones | Texas | 48253 | 2723 | 46 |
1031259 | 1031259 | 2021-02-15 | Jones | Georgia | 13169 | 1805 | 38 |
1031633 | 1031633 | 2021-02-15 | Jones | Iowa | 19105 | 2829 | 54 |
1032234 | 1032234 | 2021-02-15 | Jones | Mississippi | 28067 | 7691 | 139 |
1032741 | 1032741 | 2021-02-15 | Jones | North Carolina | 37103 | 669 | 16 |
1033282 | 1033282 | 2021-02-15 | Jones | South Dakota | 46075 | 83 | 0 |
1033534 | 1033534 | 2021-02-15 | Jones | Texas | 48253 | 2723 | 46 |
1028012 | 1028012 | 2021-02-14 | Jones | Georgia | 13169 | 1805 | 38 |
1028386 | 1028386 | 2021-02-14 | Jones | Iowa | 19105 | 2826 | 54 |
1028987 | 1028987 | 2021-02-14 | Jones | Mississippi | 28067 | 7675 | 139 |
1029495 | 1029495 | 2021-02-14 | Jones | North Carolina | 37103 | 667 | 16 |
1030036 | 1030036 | 2021-02-14 | Jones | South Dakota | 46075 | 83 | 0 |
1030288 | 1030288 | 2021-02-14 | Jones | Texas | 48253 | 2723 | 46 |
1024767 | 1024767 | 2021-02-13 | Jones | Georgia | 13169 | 1800 | 38 |
1025141 | 1025141 | 2021-02-13 | Jones | Iowa | 19105 | 2823 | 54 |
1025741 | 1025741 | 2021-02-13 | Jones | Mississippi | 28067 | 7646 | 139 |
1026248 | 1026248 | 2021-02-13 | Jones | North Carolina | 37103 | 663 | 16 |
1026789 | 1026789 | 2021-02-13 | Jones | South Dakota | 46075 | 82 | 0 |
1027041 | 1027041 | 2021-02-13 | Jones | Texas | 48253 | 2723 | 46 |
1021522 | 1021522 | 2021-02-12 | Jones | Georgia | 13169 | 1792 | 37 |
1021896 | 1021896 | 2021-02-12 | Jones | Iowa | 19105 | 2822 | 54 |
1022496 | 1022496 | 2021-02-12 | Jones | Mississippi | 28067 | 7623 | 139 |
1023003 | 1023003 | 2021-02-12 | Jones | North Carolina | 37103 | 652 | 16 |
1023544 | 1023544 | 2021-02-12 | Jones | South Dakota | 46075 | 82 | 0 |
1023796 | 1023796 | 2021-02-12 | Jones | Texas | 48253 | 2712 | 46 |
1018277 | 1018277 | 2021-02-11 | Jones | Georgia | 13169 | 1779 | 36 |
1018651 | 1018651 | 2021-02-11 | Jones | Iowa | 19105 | 2818 | 54 |
1019251 | 1019251 | 2021-02-11 | Jones | Mississippi | 28067 | 7585 | 138 |
1019758 | 1019758 | 2021-02-11 | Jones | North Carolina | 37103 | 644 | 16 |
1020299 | 1020299 | 2021-02-11 | Jones | South Dakota | 46075 | 82 | 0 |
1020551 | 1020551 | 2021-02-11 | Jones | Texas | 48253 | 2709 | 46 |
1015032 | 1015032 | 2021-02-10 | Jones | Georgia | 13169 | 1764 | 36 |
1015406 | 1015406 | 2021-02-10 | Jones | Iowa | 19105 | 2819 | 53 |
1016006 | 1016006 | 2021-02-10 | Jones | Mississippi | 28067 | 7557 | 136 |
1016513 | 1016513 | 2021-02-10 | Jones | North Carolina | 37103 | 637 | 16 |
1017054 | 1017054 | 2021-02-10 | Jones | South Dakota | 46075 | 82 | 0 |
1017306 | 1017306 | 2021-02-10 | Jones | Texas | 48253 | 2682 | 45 |
1011787 | 1011787 | 2021-02-09 | Jones | Georgia | 13169 | 1760 | 33 |
1012161 | 1012161 | 2021-02-09 | Jones | Iowa | 19105 | 2816 | 53 |
1012761 | 1012761 | 2021-02-09 | Jones | Mississippi | 28067 | 7524 | 136 |
1013268 | 1013268 | 2021-02-09 | Jones | North Carolina | 37103 | 631 | 16 |
1013809 | 1013809 | 2021-02-09 | Jones | South Dakota | 46075 | 82 | 0 |
1014061 | 1014061 | 2021-02-09 | Jones | Texas | 48253 | 2684 | 43 |
1008541 | 1008541 | 2021-02-08 | Jones | Georgia | 13169 | 1755 | 33 |
1008915 | 1008915 | 2021-02-08 | Jones | Iowa | 19105 | 2815 | 53 |
1009516 | 1009516 | 2021-02-08 | Jones | Mississippi | 28067 | 7507 | 132 |
1010023 | 1010023 | 2021-02-08 | Jones | North Carolina | 37103 | 628 | 16 |
1010564 | 1010564 | 2021-02-08 | Jones | South Dakota | 46075 | 82 | 0 |
1010816 | 1010816 | 2021-02-08 | Jones | Texas | 48253 | 2685 | 43 |
1005295 | 1005295 | 2021-02-07 | Jones | Georgia | 13169 | 1749 | 33 |
1005669 | 1005669 | 2021-02-07 | Jones | Iowa | 19105 | 2812 | 53 |
1006269 | 1006269 | 2021-02-07 | Jones | Mississippi | 28067 | 7490 | 132 |
1006777 | 1006777 | 2021-02-07 | Jones | North Carolina | 37103 | 625 | 16 |
1007318 | 1007318 | 2021-02-07 | Jones | South Dakota | 46075 | 82 | 0 |
1007570 | 1007570 | 2021-02-07 | Jones | Texas | 48253 | 2685 | 43 |
1002049 | 1002049 | 2021-02-06 | Jones | Georgia | 13169 | 1741 | 33 |
1002423 | 1002423 | 2021-02-06 | Jones | Iowa | 19105 | 2808 | 53 |
1003023 | 1003023 | 2021-02-06 | Jones | Mississippi | 28067 | 7467 | 132 |
1003531 | 1003531 | 2021-02-06 | Jones | North Carolina | 37103 | 621 | 16 |
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);