ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Jefferson" and "date" is on date 2022-01-02 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2073398 | 2073398 | 2022-01-02 | Jefferson | Alabama | 1073 | 129265 | 2024 |
2073508 | 2073508 | 2022-01-02 | Jefferson | Arkansas | 5069 | 13226 | 235 |
2073638 | 2073638 | 2022-01-02 | Jefferson | Colorado | 8059 | 82540 | 1105 |
2073717 | 2073717 | 2022-01-02 | Jefferson | Florida | 12065 | 2634 | 36 |
2073834 | 2073834 | 2022-01-02 | Jefferson | Georgia | 13163 | 2887 | 94 |
2073946 | 2073946 | 2022-01-02 | Jefferson | Idaho | 16051 | 4610 | 53 |
2074005 | 2074005 | 2022-01-02 | Jefferson | Illinois | 17081 | 7536 | 151 |
2074106 | 2074106 | 2022-01-02 | Jefferson | Indiana | 18077 | 6754 | 116 |
2074210 | 2074210 | 2022-01-02 | Jefferson | Iowa | 19101 | 2555 | 44 |
2074303 | 2074303 | 2022-01-02 | Jefferson | Kansas | 20087 | 3238 | 53 |
2074420 | 2074420 | 2022-01-02 | Jefferson | Kentucky | 21111 | 144121 | 1834 |
2074510 | 2074510 | 2022-01-02 | Jefferson | Louisiana | 22051 | 77982 | 1193 |
2074810 | 2074810 | 2022-01-02 | Jefferson | Mississippi | 28063 | 994 | 35 |
2074910 | 2074910 | 2022-01-02 | Jefferson | Missouri | 29099 | 39372 | 459 |
2074999 | 2074999 | 2022-01-02 | Jefferson | Montana | 30043 | 1954 | 21 |
2075081 | 2075081 | 2022-01-02 | Jefferson | Nebraska | 31095 | 1007 | 3 |
2075232 | 2075232 | 2022-01-02 | Jefferson | New York | 36045 | 13437 | 118 |
2075466 | 2075466 | 2022-01-02 | Jefferson | Ohio | 39081 | 10954 | 251 |
2075548 | 2075548 | 2022-01-02 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2075608 | 2075608 | 2022-01-02 | Jefferson | Oregon | 41031 | 4437 | 69 |
2075661 | 2075661 | 2022-01-02 | Jefferson | Pennsylvania | 42065 | 6923 | 185 |
2075937 | 2075937 | 2022-01-02 | Jefferson | Tennessee | 47089 | 10836 | 215 |
2076111 | 2076111 | 2022-01-02 | Jefferson | Texas | 48245 | 33485 | 736 |
2076439 | 2076439 | 2022-01-02 | Jefferson | Washington | 53031 | 1447 | 21 |
2076481 | 2076481 | 2022-01-02 | Jefferson | West Virginia | 54037 | 9170 | 97 |
2076545 | 2076545 | 2022-01-02 | Jefferson | Wisconsin | 55055 | 15552 | 191 |
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);