ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,225 rows where county = "Jasper" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- Missouri 772
- South Carolina 772
- Georgia 768
- Iowa 768
- Indiana 767
- Mississippi 761
- Texas 760
- Illinois 757
county 1
- Jasper · 6,125 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461936 | 2461936 | 2022-05-01 | Jasper | Mississippi | 28061 | 4894 | 75 |
2462037 | 2462037 | 2022-05-01 | Jasper | Missouri | 29097 | 20862 | 310 |
2462938 | 2462938 | 2022-05-01 | Jasper | South Carolina | 45053 | 5897 | 93 |
2463240 | 2463240 | 2022-05-01 | Jasper | Texas | 48241 | 6094 | 187 |
2457701 | 2457701 | 2022-04-30 | Jasper | Georgia | 13159 | 3139 | 72 |
2457873 | 2457873 | 2022-04-30 | Jasper | Illinois | 17079 | 2681 | 32 |
2457973 | 2457973 | 2022-04-30 | Jasper | Indiana | 18073 | 9079 | 149 |
2458079 | 2458079 | 2022-04-30 | Jasper | Iowa | 19099 | 8657 | 110 |
2458680 | 2458680 | 2022-04-30 | Jasper | Mississippi | 28061 | 4894 | 75 |
2458781 | 2458781 | 2022-04-30 | Jasper | Missouri | 29097 | 20862 | 310 |
2459682 | 2459682 | 2022-04-30 | Jasper | South Carolina | 45053 | 5897 | 93 |
2459984 | 2459984 | 2022-04-30 | Jasper | Texas | 48241 | 6094 | 187 |
2454445 | 2454445 | 2022-04-29 | Jasper | Georgia | 13159 | 3139 | 72 |
2454617 | 2454617 | 2022-04-29 | Jasper | Illinois | 17079 | 2681 | 32 |
2454717 | 2454717 | 2022-04-29 | Jasper | Indiana | 18073 | 9079 | 149 |
2454823 | 2454823 | 2022-04-29 | Jasper | Iowa | 19099 | 8657 | 110 |
2455424 | 2455424 | 2022-04-29 | Jasper | Mississippi | 28061 | 4894 | 75 |
2455525 | 2455525 | 2022-04-29 | Jasper | Missouri | 29097 | 20862 | 310 |
2456426 | 2456426 | 2022-04-29 | Jasper | South Carolina | 45053 | 5897 | 93 |
2456728 | 2456728 | 2022-04-29 | Jasper | Texas | 48241 | 6093 | 187 |
2451189 | 2451189 | 2022-04-28 | Jasper | Georgia | 13159 | 3139 | 72 |
2451361 | 2451361 | 2022-04-28 | Jasper | Illinois | 17079 | 2681 | 32 |
2451461 | 2451461 | 2022-04-28 | Jasper | Indiana | 18073 | 9068 | 149 |
2451567 | 2451567 | 2022-04-28 | Jasper | Iowa | 19099 | 8657 | 110 |
2452168 | 2452168 | 2022-04-28 | Jasper | Mississippi | 28061 | 4894 | 75 |
2452269 | 2452269 | 2022-04-28 | Jasper | Missouri | 29097 | 20862 | 310 |
2453170 | 2453170 | 2022-04-28 | Jasper | South Carolina | 45053 | 5897 | 93 |
2453472 | 2453472 | 2022-04-28 | Jasper | Texas | 48241 | 6092 | 187 |
2447933 | 2447933 | 2022-04-27 | Jasper | Georgia | 13159 | 3139 | 72 |
2448105 | 2448105 | 2022-04-27 | Jasper | Illinois | 17079 | 2681 | 32 |
2448205 | 2448205 | 2022-04-27 | Jasper | Indiana | 18073 | 9068 | 149 |
2448311 | 2448311 | 2022-04-27 | Jasper | Iowa | 19099 | 8657 | 110 |
2448912 | 2448912 | 2022-04-27 | Jasper | Mississippi | 28061 | 4894 | 75 |
2449013 | 2449013 | 2022-04-27 | Jasper | Missouri | 29097 | 20862 | 310 |
2449914 | 2449914 | 2022-04-27 | Jasper | South Carolina | 45053 | 5893 | 93 |
2450216 | 2450216 | 2022-04-27 | Jasper | Texas | 48241 | 6092 | 187 |
2444677 | 2444677 | 2022-04-26 | Jasper | Georgia | 13159 | 3133 | 72 |
2444849 | 2444849 | 2022-04-26 | Jasper | Illinois | 17079 | 2681 | 32 |
2444949 | 2444949 | 2022-04-26 | Jasper | Indiana | 18073 | 9057 | 148 |
2445055 | 2445055 | 2022-04-26 | Jasper | Iowa | 19099 | 8648 | 110 |
2445656 | 2445656 | 2022-04-26 | Jasper | Mississippi | 28061 | 4894 | 75 |
2445756 | 2445756 | 2022-04-26 | Jasper | Missouri | 29097 | 20862 | 310 |
2446657 | 2446657 | 2022-04-26 | Jasper | South Carolina | 45053 | 5893 | 93 |
2446959 | 2446959 | 2022-04-26 | Jasper | Texas | 48241 | 6089 | 187 |
2441421 | 2441421 | 2022-04-25 | Jasper | Georgia | 13159 | 3133 | 72 |
2441593 | 2441593 | 2022-04-25 | Jasper | Illinois | 17079 | 2681 | 32 |
2441693 | 2441693 | 2022-04-25 | Jasper | Indiana | 18073 | 9057 | 148 |
2441799 | 2441799 | 2022-04-25 | Jasper | Iowa | 19099 | 8648 | 110 |
2442400 | 2442400 | 2022-04-25 | Jasper | Mississippi | 28061 | 4887 | 75 |
2442501 | 2442501 | 2022-04-25 | Jasper | Missouri | 29097 | 20862 | 310 |
2443402 | 2443402 | 2022-04-25 | Jasper | South Carolina | 45053 | 5893 | 93 |
2443704 | 2443704 | 2022-04-25 | Jasper | Texas | 48241 | 6088 | 187 |
2438165 | 2438165 | 2022-04-24 | Jasper | Georgia | 13159 | 3132 | 72 |
2438337 | 2438337 | 2022-04-24 | Jasper | Illinois | 17079 | 2679 | 32 |
2438437 | 2438437 | 2022-04-24 | Jasper | Indiana | 18073 | 9039 | 148 |
2438543 | 2438543 | 2022-04-24 | Jasper | Iowa | 19099 | 8648 | 110 |
2439144 | 2439144 | 2022-04-24 | Jasper | Mississippi | 28061 | 4887 | 75 |
2439245 | 2439245 | 2022-04-24 | Jasper | Missouri | 29097 | 20862 | 310 |
2440146 | 2440146 | 2022-04-24 | Jasper | South Carolina | 45053 | 5893 | 93 |
2440448 | 2440448 | 2022-04-24 | Jasper | Texas | 48241 | 6088 | 187 |
2434909 | 2434909 | 2022-04-23 | Jasper | Georgia | 13159 | 3132 | 72 |
2435081 | 2435081 | 2022-04-23 | Jasper | Illinois | 17079 | 2679 | 32 |
2435181 | 2435181 | 2022-04-23 | Jasper | Indiana | 18073 | 9039 | 148 |
2435287 | 2435287 | 2022-04-23 | Jasper | Iowa | 19099 | 8648 | 110 |
2435888 | 2435888 | 2022-04-23 | Jasper | Mississippi | 28061 | 4887 | 75 |
2435989 | 2435989 | 2022-04-23 | Jasper | Missouri | 29097 | 20862 | 310 |
2436890 | 2436890 | 2022-04-23 | Jasper | South Carolina | 45053 | 5893 | 93 |
2437192 | 2437192 | 2022-04-23 | Jasper | Texas | 48241 | 6088 | 187 |
2431653 | 2431653 | 2022-04-22 | Jasper | Georgia | 13159 | 3132 | 72 |
2431825 | 2431825 | 2022-04-22 | Jasper | Illinois | 17079 | 2679 | 32 |
2431925 | 2431925 | 2022-04-22 | Jasper | Indiana | 18073 | 9039 | 148 |
2432031 | 2432031 | 2022-04-22 | Jasper | Iowa | 19099 | 8648 | 110 |
2432632 | 2432632 | 2022-04-22 | Jasper | Mississippi | 28061 | 4887 | 75 |
2432733 | 2432733 | 2022-04-22 | Jasper | Missouri | 29097 | 20862 | 310 |
2433634 | 2433634 | 2022-04-22 | Jasper | South Carolina | 45053 | 5893 | 93 |
2433936 | 2433936 | 2022-04-22 | Jasper | Texas | 48241 | 6087 | 187 |
2428397 | 2428397 | 2022-04-21 | Jasper | Georgia | 13159 | 3132 | 72 |
2428569 | 2428569 | 2022-04-21 | Jasper | Illinois | 17079 | 2678 | 32 |
2428669 | 2428669 | 2022-04-21 | Jasper | Indiana | 18073 | 9025 | 148 |
2428775 | 2428775 | 2022-04-21 | Jasper | Iowa | 19099 | 8648 | 110 |
2429376 | 2429376 | 2022-04-21 | Jasper | Mississippi | 28061 | 4887 | 75 |
2429477 | 2429477 | 2022-04-21 | Jasper | Missouri | 29097 | 20862 | 310 |
2430378 | 2430378 | 2022-04-21 | Jasper | South Carolina | 45053 | 5893 | 93 |
2430680 | 2430680 | 2022-04-21 | Jasper | Texas | 48241 | 6082 | 187 |
2425141 | 2425141 | 2022-04-20 | Jasper | Georgia | 13159 | 3132 | 72 |
2425313 | 2425313 | 2022-04-20 | Jasper | Illinois | 17079 | 2677 | 32 |
2425413 | 2425413 | 2022-04-20 | Jasper | Indiana | 18073 | 9025 | 148 |
2425519 | 2425519 | 2022-04-20 | Jasper | Iowa | 19099 | 8648 | 110 |
2426120 | 2426120 | 2022-04-20 | Jasper | Mississippi | 28061 | 4887 | 75 |
2426221 | 2426221 | 2022-04-20 | Jasper | Missouri | 29097 | 20862 | 310 |
2427122 | 2427122 | 2022-04-20 | Jasper | South Carolina | 45053 | 5893 | 93 |
2427424 | 2427424 | 2022-04-20 | Jasper | Texas | 48241 | 6082 | 187 |
2421885 | 2421885 | 2022-04-19 | Jasper | Georgia | 13159 | 3126 | 71 |
2422057 | 2422057 | 2022-04-19 | Jasper | Illinois | 17079 | 2677 | 32 |
2422157 | 2422157 | 2022-04-19 | Jasper | Indiana | 18073 | 9022 | 148 |
2422263 | 2422263 | 2022-04-19 | Jasper | Iowa | 19099 | 8644 | 110 |
2422864 | 2422864 | 2022-04-19 | Jasper | Mississippi | 28061 | 4887 | 75 |
2422965 | 2422965 | 2022-04-19 | Jasper | Missouri | 29097 | 20862 | 310 |
2423866 | 2423866 | 2022-04-19 | Jasper | South Carolina | 45053 | 5893 | 93 |
2424168 | 2424168 | 2022-04-19 | Jasper | Texas | 48241 | 6081 | 187 |
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);