ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Onslow" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055476 | 1055476 | 2021-02-22 | Onslow | North Carolina | 37133 | 14411 | 133 |
1052230 | 1052230 | 2021-02-21 | Onslow | North Carolina | 37133 | 14400 | 133 |
1048983 | 1048983 | 2021-02-20 | Onslow | North Carolina | 37133 | 14346 | 133 |
1045736 | 1045736 | 2021-02-19 | Onslow | North Carolina | 37133 | 14315 | 132 |
1042491 | 1042491 | 2021-02-18 | Onslow | North Carolina | 37133 | 14285 | 131 |
1039246 | 1039246 | 2021-02-17 | Onslow | North Carolina | 37133 | 14256 | 129 |
1036001 | 1036001 | 2021-02-16 | Onslow | North Carolina | 37133 | 14168 | 126 |
1032756 | 1032756 | 2021-02-15 | Onslow | North Carolina | 37133 | 14130 | 126 |
1029510 | 1029510 | 2021-02-14 | Onslow | North Carolina | 37133 | 14093 | 125 |
1026263 | 1026263 | 2021-02-13 | Onslow | North Carolina | 37133 | 14070 | 125 |
1023018 | 1023018 | 2021-02-12 | Onslow | North Carolina | 37133 | 14034 | 125 |
1019773 | 1019773 | 2021-02-11 | Onslow | North Carolina | 37133 | 13982 | 123 |
1016528 | 1016528 | 2021-02-10 | Onslow | North Carolina | 37133 | 13909 | 122 |
1013283 | 1013283 | 2021-02-09 | Onslow | North Carolina | 37133 | 13840 | 120 |
1010038 | 1010038 | 2021-02-08 | Onslow | North Carolina | 37133 | 13805 | 118 |
1006792 | 1006792 | 2021-02-07 | Onslow | North Carolina | 37133 | 13770 | 118 |
1003546 | 1003546 | 2021-02-06 | Onslow | North Carolina | 37133 | 13693 | 117 |
1000300 | 1000300 | 2021-02-05 | Onslow | North Carolina | 37133 | 13610 | 116 |
997054 | 997054 | 2021-02-04 | Onslow | North Carolina | 37133 | 13512 | 115 |
993808 | 993808 | 2021-02-03 | Onslow | North Carolina | 37133 | 13351 | 115 |
990562 | 990562 | 2021-02-02 | Onslow | North Carolina | 37133 | 13152 | 115 |
987316 | 987316 | 2021-02-01 | Onslow | North Carolina | 37133 | 13122 | 114 |
984069 | 984069 | 2021-01-31 | Onslow | North Carolina | 37133 | 13076 | 113 |
980822 | 980822 | 2021-01-30 | Onslow | North Carolina | 37133 | 12715 | 109 |
977576 | 977576 | 2021-01-29 | Onslow | North Carolina | 37133 | 12715 | 109 |
974331 | 974331 | 2021-01-28 | Onslow | North Carolina | 37133 | 12564 | 109 |
971086 | 971086 | 2021-01-27 | Onslow | North Carolina | 37133 | 12416 | 105 |
967841 | 967841 | 2021-01-26 | Onslow | North Carolina | 37133 | 12245 | 103 |
964597 | 964597 | 2021-01-25 | Onslow | North Carolina | 37133 | 12172 | 99 |
961352 | 961352 | 2021-01-24 | Onslow | North Carolina | 37133 | 12126 | 98 |
958107 | 958107 | 2021-01-23 | Onslow | North Carolina | 37133 | 12014 | 96 |
954861 | 954861 | 2021-01-22 | Onslow | North Carolina | 37133 | 11854 | 94 |
951616 | 951616 | 2021-01-21 | Onslow | North Carolina | 37133 | 11647 | 93 |
948371 | 948371 | 2021-01-20 | Onslow | North Carolina | 37133 | 11552 | 91 |
945124 | 945124 | 2021-01-19 | Onslow | North Carolina | 37133 | 11436 | 90 |
941878 | 941878 | 2021-01-18 | Onslow | North Carolina | 37133 | 11318 | 90 |
938633 | 938633 | 2021-01-17 | Onslow | North Carolina | 37133 | 11318 | 90 |
935388 | 935388 | 2021-01-16 | Onslow | North Carolina | 37133 | 11178 | 89 |
932143 | 932143 | 2021-01-15 | Onslow | North Carolina | 37133 | 11029 | 87 |
928898 | 928898 | 2021-01-14 | Onslow | North Carolina | 37133 | 10898 | 84 |
925653 | 925653 | 2021-01-13 | Onslow | North Carolina | 37133 | 10704 | 82 |
922407 | 922407 | 2021-01-12 | Onslow | North Carolina | 37133 | 10598 | 83 |
919162 | 919162 | 2021-01-11 | Onslow | North Carolina | 37133 | 10511 | 82 |
915917 | 915917 | 2021-01-10 | Onslow | North Carolina | 37133 | 10448 | 82 |
912672 | 912672 | 2021-01-09 | Onslow | North Carolina | 37133 | 10274 | 82 |
909427 | 909427 | 2021-01-08 | Onslow | North Carolina | 37133 | 10108 | 81 |
906182 | 906182 | 2021-01-07 | Onslow | North Carolina | 37133 | 9816 | 74 |
902936 | 902936 | 2021-01-06 | Onslow | North Carolina | 37133 | 9593 | 74 |
899691 | 899691 | 2021-01-05 | Onslow | North Carolina | 37133 | 9458 | 71 |
896446 | 896446 | 2021-01-04 | Onslow | North Carolina | 37133 | 9391 | 69 |
893200 | 893200 | 2021-01-03 | Onslow | North Carolina | 37133 | 9317 | 69 |
889954 | 889954 | 2021-01-02 | Onslow | North Carolina | 37133 | 9191 | 68 |
886707 | 886707 | 2021-01-01 | Onslow | North Carolina | 37133 | 8730 | 66 |
883462 | 883462 | 2020-12-31 | Onslow | North Carolina | 37133 | 8730 | 66 |
880217 | 880217 | 2020-12-30 | Onslow | North Carolina | 37133 | 8646 | 65 |
876972 | 876972 | 2020-12-29 | Onslow | North Carolina | 37133 | 8421 | 62 |
873727 | 873727 | 2020-12-28 | Onslow | North Carolina | 37133 | 8384 | 62 |
870482 | 870482 | 2020-12-27 | Onslow | North Carolina | 37133 | 8323 | 62 |
867237 | 867237 | 2020-12-26 | Onslow | North Carolina | 37133 | 8284 | 59 |
863992 | 863992 | 2020-12-25 | Onslow | North Carolina | 37133 | 7962 | 58 |
860747 | 860747 | 2020-12-24 | Onslow | North Carolina | 37133 | 7962 | 58 |
857502 | 857502 | 2020-12-23 | Onslow | North Carolina | 37133 | 7962 | 58 |
854257 | 854257 | 2020-12-22 | Onslow | North Carolina | 37133 | 7865 | 58 |
851012 | 851012 | 2020-12-21 | Onslow | North Carolina | 37133 | 7791 | 57 |
847767 | 847767 | 2020-12-20 | Onslow | North Carolina | 37133 | 7739 | 57 |
844522 | 844522 | 2020-12-19 | Onslow | North Carolina | 37133 | 7646 | 57 |
841276 | 841276 | 2020-12-18 | Onslow | North Carolina | 37133 | 7518 | 55 |
838031 | 838031 | 2020-12-17 | Onslow | North Carolina | 37133 | 7383 | 54 |
834785 | 834785 | 2020-12-16 | Onslow | North Carolina | 37133 | 7319 | 54 |
831539 | 831539 | 2020-12-15 | Onslow | North Carolina | 37133 | 7190 | 52 |
828292 | 828292 | 2020-12-14 | Onslow | North Carolina | 37133 | 7114 | 51 |
825046 | 825046 | 2020-12-13 | Onslow | North Carolina | 37133 | 7077 | 49 |
821799 | 821799 | 2020-12-12 | Onslow | North Carolina | 37133 | 6887 | 48 |
818553 | 818553 | 2020-12-11 | Onslow | North Carolina | 37133 | 6708 | 47 |
815307 | 815307 | 2020-12-10 | Onslow | North Carolina | 37133 | 6486 | 47 |
812062 | 812062 | 2020-12-09 | Onslow | North Carolina | 37133 | 6308 | 47 |
808817 | 808817 | 2020-12-08 | Onslow | North Carolina | 37133 | 6150 | 46 |
805572 | 805572 | 2020-12-07 | Onslow | North Carolina | 37133 | 6074 | 45 |
802327 | 802327 | 2020-12-06 | Onslow | North Carolina | 37133 | 6011 | 45 |
799082 | 799082 | 2020-12-05 | Onslow | North Carolina | 37133 | 5880 | 45 |
795837 | 795837 | 2020-12-04 | Onslow | North Carolina | 37133 | 5767 | 45 |
792592 | 792592 | 2020-12-03 | Onslow | North Carolina | 37133 | 5678 | 44 |
789347 | 789347 | 2020-12-02 | Onslow | North Carolina | 37133 | 5577 | 44 |
786102 | 786102 | 2020-12-01 | Onslow | North Carolina | 37133 | 5445 | 43 |
782858 | 782858 | 2020-11-30 | Onslow | North Carolina | 37133 | 5404 | 42 |
779612 | 779612 | 2020-11-29 | Onslow | North Carolina | 37133 | 5364 | 41 |
776367 | 776367 | 2020-11-28 | Onslow | North Carolina | 37133 | 5251 | 41 |
773122 | 773122 | 2020-11-27 | Onslow | North Carolina | 37133 | 5178 | 40 |
769877 | 769877 | 2020-11-26 | Onslow | North Carolina | 37133 | 4992 | 39 |
766631 | 766631 | 2020-11-25 | Onslow | North Carolina | 37133 | 4992 | 39 |
763386 | 763386 | 2020-11-24 | Onslow | North Carolina | 37133 | 4865 | 39 |
760141 | 760141 | 2020-11-23 | Onslow | North Carolina | 37133 | 4809 | 39 |
756895 | 756895 | 2020-11-22 | Onslow | North Carolina | 37133 | 4769 | 39 |
753648 | 753648 | 2020-11-21 | Onslow | North Carolina | 37133 | 4659 | 37 |
750402 | 750402 | 2020-11-20 | Onslow | North Carolina | 37133 | 4553 | 37 |
747156 | 747156 | 2020-11-19 | Onslow | North Carolina | 37133 | 4447 | 36 |
743910 | 743910 | 2020-11-18 | Onslow | North Carolina | 37133 | 4364 | 36 |
740663 | 740663 | 2020-11-17 | Onslow | North Carolina | 37133 | 4281 | 36 |
737418 | 737418 | 2020-11-16 | Onslow | North Carolina | 37133 | 4215 | 36 |
734174 | 734174 | 2020-11-15 | Onslow | North Carolina | 37133 | 4176 | 36 |
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);