ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,932 rows where county = "Knox" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
county 1
- Knox · 2,927 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054153 | 1054153 | 2021-02-22 | Knox | Illinois | 17095 | 4992 | 156 |
1054250 | 1054250 | 2021-02-22 | Knox | Indiana | 18083 | 3546 | 84 |
1054567 | 1054567 | 2021-02-22 | Knox | Kentucky | 21121 | 2818 | 11 |
1054698 | 1054698 | 2021-02-22 | Knox | Maine | 23013 | 624 | 5 |
1055056 | 1055056 | 2021-02-22 | Knox | Missouri | 29103 | 176 | 2 |
1055229 | 1055229 | 2021-02-22 | Knox | Nebraska | 31107 | 834 | 12 |
1055607 | 1055607 | 2021-02-22 | Knox | Ohio | 39083 | 3969 | 83 |
1056078 | 1056078 | 2021-02-22 | Knox | Tennessee | 47093 | 46227 | 564 |
1056265 | 1056265 | 2021-02-22 | Knox | Texas | 48275 | 253 | 15 |
1050906 | 1050906 | 2021-02-21 | Knox | Illinois | 17095 | 4991 | 156 |
1051003 | 1051003 | 2021-02-21 | Knox | Indiana | 18083 | 3545 | 84 |
1051320 | 1051320 | 2021-02-21 | Knox | Kentucky | 21121 | 2803 | 11 |
1051451 | 1051451 | 2021-02-21 | Knox | Maine | 23013 | 622 | 5 |
1051809 | 1051809 | 2021-02-21 | Knox | Missouri | 29103 | 176 | 2 |
1051982 | 1051982 | 2021-02-21 | Knox | Nebraska | 31107 | 834 | 12 |
1052361 | 1052361 | 2021-02-21 | Knox | Ohio | 39083 | 3964 | 81 |
1052832 | 1052832 | 2021-02-21 | Knox | Tennessee | 47093 | 46126 | 561 |
1053019 | 1053019 | 2021-02-21 | Knox | Texas | 48275 | 253 | 15 |
1047659 | 1047659 | 2021-02-20 | Knox | Illinois | 17095 | 4989 | 156 |
1047756 | 1047756 | 2021-02-20 | Knox | Indiana | 18083 | 3542 | 82 |
1048073 | 1048073 | 2021-02-20 | Knox | Kentucky | 21121 | 2800 | 11 |
1048204 | 1048204 | 2021-02-20 | Knox | Maine | 23013 | 620 | 5 |
1048562 | 1048562 | 2021-02-20 | Knox | Missouri | 29103 | 176 | 2 |
1048735 | 1048735 | 2021-02-20 | Knox | Nebraska | 31107 | 834 | 12 |
1049114 | 1049114 | 2021-02-20 | Knox | Ohio | 39083 | 3960 | 79 |
1049585 | 1049585 | 2021-02-20 | Knox | Tennessee | 47093 | 46005 | 559 |
1049772 | 1049772 | 2021-02-20 | Knox | Texas | 48275 | 253 | 15 |
1044414 | 1044414 | 2021-02-19 | Knox | Illinois | 17095 | 4988 | 156 |
1044511 | 1044511 | 2021-02-19 | Knox | Indiana | 18083 | 3542 | 82 |
1044828 | 1044828 | 2021-02-19 | Knox | Kentucky | 21121 | 2806 | 11 |
1044959 | 1044959 | 2021-02-19 | Knox | Maine | 23013 | 620 | 5 |
1045316 | 1045316 | 2021-02-19 | Knox | Missouri | 29103 | 175 | 2 |
1045489 | 1045489 | 2021-02-19 | Knox | Nebraska | 31107 | 834 | 12 |
1045867 | 1045867 | 2021-02-19 | Knox | Ohio | 39083 | 3953 | 79 |
1046338 | 1046338 | 2021-02-19 | Knox | Tennessee | 47093 | 45856 | 558 |
1046525 | 1046525 | 2021-02-19 | Knox | Texas | 48275 | 248 | 14 |
1041169 | 1041169 | 2021-02-18 | Knox | Illinois | 17095 | 4952 | 156 |
1041266 | 1041266 | 2021-02-18 | Knox | Indiana | 18083 | 3541 | 82 |
1041583 | 1041583 | 2021-02-18 | Knox | Kentucky | 21121 | 2791 | 11 |
1041714 | 1041714 | 2021-02-18 | Knox | Maine | 23013 | 618 | 5 |
1042071 | 1042071 | 2021-02-18 | Knox | Missouri | 29103 | 175 | 2 |
1042244 | 1042244 | 2021-02-18 | Knox | Nebraska | 31107 | 834 | 12 |
1042622 | 1042622 | 2021-02-18 | Knox | Ohio | 39083 | 3948 | 81 |
1043093 | 1043093 | 2021-02-18 | Knox | Tennessee | 47093 | 45720 | 557 |
1043280 | 1043280 | 2021-02-18 | Knox | Texas | 48275 | 248 | 14 |
1037924 | 1037924 | 2021-02-17 | Knox | Illinois | 17095 | 4935 | 156 |
1038021 | 1038021 | 2021-02-17 | Knox | Indiana | 18083 | 3539 | 82 |
1038338 | 1038338 | 2021-02-17 | Knox | Kentucky | 21121 | 2778 | 11 |
1038469 | 1038469 | 2021-02-17 | Knox | Maine | 23013 | 616 | 5 |
1038826 | 1038826 | 2021-02-17 | Knox | Missouri | 29103 | 175 | 2 |
1038999 | 1038999 | 2021-02-17 | Knox | Nebraska | 31107 | 834 | 12 |
1039377 | 1039377 | 2021-02-17 | Knox | Ohio | 39083 | 3939 | 80 |
1039848 | 1039848 | 2021-02-17 | Knox | Tennessee | 47093 | 45489 | 553 |
1040035 | 1040035 | 2021-02-17 | Knox | Texas | 48275 | 248 | 14 |
1034679 | 1034679 | 2021-02-16 | Knox | Illinois | 17095 | 4933 | 156 |
1034776 | 1034776 | 2021-02-16 | Knox | Indiana | 18083 | 3539 | 82 |
1035093 | 1035093 | 2021-02-16 | Knox | Kentucky | 21121 | 2775 | 11 |
1035224 | 1035224 | 2021-02-16 | Knox | Maine | 23013 | 614 | 5 |
1035581 | 1035581 | 2021-02-16 | Knox | Missouri | 29103 | 175 | 2 |
1035754 | 1035754 | 2021-02-16 | Knox | Nebraska | 31107 | 834 | 12 |
1036132 | 1036132 | 2021-02-16 | Knox | Ohio | 39083 | 3935 | 80 |
1036603 | 1036603 | 2021-02-16 | Knox | Tennessee | 47093 | 45489 | 552 |
1036790 | 1036790 | 2021-02-16 | Knox | Texas | 48275 | 246 | 14 |
1031433 | 1031433 | 2021-02-15 | Knox | Illinois | 17095 | 4933 | 156 |
1031530 | 1031530 | 2021-02-15 | Knox | Indiana | 18083 | 3538 | 82 |
1031847 | 1031847 | 2021-02-15 | Knox | Kentucky | 21121 | 2763 | 11 |
1031978 | 1031978 | 2021-02-15 | Knox | Maine | 23013 | 614 | 5 |
1032336 | 1032336 | 2021-02-15 | Knox | Missouri | 29103 | 175 | 2 |
1032509 | 1032509 | 2021-02-15 | Knox | Nebraska | 31107 | 834 | 12 |
1032887 | 1032887 | 2021-02-15 | Knox | Ohio | 39083 | 3920 | 79 |
1033358 | 1033358 | 2021-02-15 | Knox | Tennessee | 47093 | 45351 | 550 |
1033545 | 1033545 | 2021-02-15 | Knox | Texas | 48275 | 246 | 14 |
1028186 | 1028186 | 2021-02-14 | Knox | Illinois | 17095 | 4931 | 156 |
1028283 | 1028283 | 2021-02-14 | Knox | Indiana | 18083 | 3537 | 82 |
1028600 | 1028600 | 2021-02-14 | Knox | Kentucky | 21121 | 2763 | 11 |
1028731 | 1028731 | 2021-02-14 | Knox | Maine | 23013 | 612 | 5 |
1029089 | 1029089 | 2021-02-14 | Knox | Missouri | 29103 | 175 | 2 |
1029262 | 1029262 | 2021-02-14 | Knox | Nebraska | 31107 | 834 | 12 |
1029641 | 1029641 | 2021-02-14 | Knox | Ohio | 39083 | 3905 | 78 |
1030112 | 1030112 | 2021-02-14 | Knox | Tennessee | 47093 | 45205 | 548 |
1030299 | 1030299 | 2021-02-14 | Knox | Texas | 48275 | 246 | 14 |
1024941 | 1024941 | 2021-02-13 | Knox | Illinois | 17095 | 4929 | 154 |
1025038 | 1025038 | 2021-02-13 | Knox | Indiana | 18083 | 3534 | 82 |
1025355 | 1025355 | 2021-02-13 | Knox | Kentucky | 21121 | 2753 | 11 |
1025486 | 1025486 | 2021-02-13 | Knox | Maine | 23013 | 603 | 5 |
1025843 | 1025843 | 2021-02-13 | Knox | Missouri | 29103 | 175 | 2 |
1026016 | 1026016 | 2021-02-13 | Knox | Nebraska | 31107 | 834 | 12 |
1026394 | 1026394 | 2021-02-13 | Knox | Ohio | 39083 | 3900 | 77 |
1026865 | 1026865 | 2021-02-13 | Knox | Tennessee | 47093 | 45063 | 546 |
1027052 | 1027052 | 2021-02-13 | Knox | Texas | 48275 | 246 | 14 |
1021696 | 1021696 | 2021-02-12 | Knox | Illinois | 17095 | 4924 | 154 |
1021793 | 1021793 | 2021-02-12 | Knox | Indiana | 18083 | 3529 | 82 |
1022110 | 1022110 | 2021-02-12 | Knox | Kentucky | 21121 | 2740 | 11 |
1022241 | 1022241 | 2021-02-12 | Knox | Maine | 23013 | 601 | 5 |
1022598 | 1022598 | 2021-02-12 | Knox | Missouri | 29103 | 175 | 2 |
1022771 | 1022771 | 2021-02-12 | Knox | Nebraska | 31107 | 832 | 12 |
1023149 | 1023149 | 2021-02-12 | Knox | Ohio | 39083 | 3890 | 67 |
1023620 | 1023620 | 2021-02-12 | Knox | Tennessee | 47093 | 44892 | 542 |
1023807 | 1023807 | 2021-02-12 | Knox | Texas | 48275 | 242 | 14 |
1018451 | 1018451 | 2021-02-11 | Knox | Illinois | 17095 | 4915 | 153 |
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);