ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,871 rows where county = "Saline" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Saline · 511 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
318883 | 318883 | 2020-07-10 | Saline | Arkansas | 5125 | 433 | 3 |
319385 | 319385 | 2020-07-10 | Saline | Illinois | 17165 | 16 | 0 |
319680 | 319680 | 2020-07-10 | Saline | Kansas | 20169 | 215 | 2 |
320287 | 320287 | 2020-07-10 | Saline | Missouri | 29195 | 307 | 5 |
320413 | 320413 | 2020-07-10 | Saline | Nebraska | 31151 | 545 | 2 |
315710 | 315710 | 2020-07-09 | Saline | Arkansas | 5125 | 420 | 3 |
316212 | 316212 | 2020-07-09 | Saline | Illinois | 17165 | 11 | 0 |
316505 | 316505 | 2020-07-09 | Saline | Kansas | 20169 | 190 | 2 |
317112 | 317112 | 2020-07-09 | Saline | Missouri | 29195 | 299 | 5 |
317237 | 317237 | 2020-07-09 | Saline | Nebraska | 31151 | 545 | 2 |
312535 | 312535 | 2020-07-08 | Saline | Arkansas | 5125 | 399 | 3 |
313038 | 313038 | 2020-07-08 | Saline | Illinois | 17165 | 10 | 0 |
313331 | 313331 | 2020-07-08 | Saline | Kansas | 20169 | 190 | 2 |
313938 | 313938 | 2020-07-08 | Saline | Missouri | 29195 | 295 | 4 |
314063 | 314063 | 2020-07-08 | Saline | Nebraska | 31151 | 544 | 2 |
309365 | 309365 | 2020-07-07 | Saline | Arkansas | 5125 | 375 | 2 |
309868 | 309868 | 2020-07-07 | Saline | Illinois | 17165 | 10 | 0 |
310161 | 310161 | 2020-07-07 | Saline | Kansas | 20169 | 173 | 2 |
310767 | 310767 | 2020-07-07 | Saline | Missouri | 29195 | 290 | 4 |
310892 | 310892 | 2020-07-07 | Saline | Nebraska | 31151 | 540 | 2 |
306197 | 306197 | 2020-07-06 | Saline | Arkansas | 5125 | 359 | 2 |
306700 | 306700 | 2020-07-06 | Saline | Illinois | 17165 | 9 | 0 |
306993 | 306993 | 2020-07-06 | Saline | Kansas | 20169 | 173 | 2 |
307599 | 307599 | 2020-07-06 | Saline | Missouri | 29195 | 287 | 4 |
307724 | 307724 | 2020-07-06 | Saline | Nebraska | 31151 | 539 | 2 |
303033 | 303033 | 2020-07-05 | Saline | Arkansas | 5125 | 353 | 2 |
303535 | 303535 | 2020-07-05 | Saline | Illinois | 17165 | 9 | 0 |
303826 | 303826 | 2020-07-05 | Saline | Kansas | 20169 | 145 | 2 |
304432 | 304432 | 2020-07-05 | Saline | Missouri | 29195 | 284 | 4 |
304557 | 304557 | 2020-07-05 | Saline | Nebraska | 31151 | 540 | 2 |
299869 | 299869 | 2020-07-04 | Saline | Arkansas | 5125 | 337 | 2 |
300371 | 300371 | 2020-07-04 | Saline | Illinois | 17165 | 9 | 0 |
300662 | 300662 | 2020-07-04 | Saline | Kansas | 20169 | 145 | 2 |
301268 | 301268 | 2020-07-04 | Saline | Missouri | 29195 | 284 | 4 |
301393 | 301393 | 2020-07-04 | Saline | Nebraska | 31151 | 540 | 2 |
296707 | 296707 | 2020-07-03 | Saline | Arkansas | 5125 | 319 | 2 |
297209 | 297209 | 2020-07-03 | Saline | Illinois | 17165 | 9 | 0 |
297500 | 297500 | 2020-07-03 | Saline | Kansas | 20169 | 130 | 2 |
298105 | 298105 | 2020-07-03 | Saline | Missouri | 29195 | 284 | 4 |
298230 | 298230 | 2020-07-03 | Saline | Nebraska | 31151 | 540 | 2 |
293551 | 293551 | 2020-07-02 | Saline | Arkansas | 5125 | 311 | 2 |
294052 | 294052 | 2020-07-02 | Saline | Illinois | 17165 | 9 | 0 |
294342 | 294342 | 2020-07-02 | Saline | Kansas | 20169 | 110 | 2 |
294947 | 294947 | 2020-07-02 | Saline | Missouri | 29195 | 283 | 4 |
295071 | 295071 | 2020-07-02 | Saline | Nebraska | 31151 | 536 | 2 |
290397 | 290397 | 2020-07-01 | Saline | Arkansas | 5125 | 292 | 2 |
290898 | 290898 | 2020-07-01 | Saline | Illinois | 17165 | 9 | 0 |
291188 | 291188 | 2020-07-01 | Saline | Kansas | 20169 | 110 | 2 |
291793 | 291793 | 2020-07-01 | Saline | Missouri | 29195 | 283 | 4 |
291916 | 291916 | 2020-07-01 | Saline | Nebraska | 31151 | 535 | 2 |
287246 | 287246 | 2020-06-30 | Saline | Arkansas | 5125 | 275 | 2 |
287748 | 287748 | 2020-06-30 | Saline | Illinois | 17165 | 9 | 0 |
288038 | 288038 | 2020-06-30 | Saline | Kansas | 20169 | 110 | 2 |
288642 | 288642 | 2020-06-30 | Saline | Missouri | 29195 | 283 | 4 |
288764 | 288764 | 2020-06-30 | Saline | Nebraska | 31151 | 533 | 2 |
284100 | 284100 | 2020-06-29 | Saline | Arkansas | 5125 | 261 | 2 |
284599 | 284599 | 2020-06-29 | Saline | Illinois | 17165 | 9 | 0 |
284889 | 284889 | 2020-06-29 | Saline | Kansas | 20169 | 110 | 2 |
285492 | 285492 | 2020-06-29 | Saline | Missouri | 29195 | 283 | 4 |
285614 | 285614 | 2020-06-29 | Saline | Nebraska | 31151 | 534 | 2 |
280954 | 280954 | 2020-06-28 | Saline | Arkansas | 5125 | 250 | 2 |
281454 | 281454 | 2020-06-28 | Saline | Illinois | 17165 | 9 | 0 |
281743 | 281743 | 2020-06-28 | Saline | Kansas | 20169 | 98 | 2 |
282347 | 282347 | 2020-06-28 | Saline | Missouri | 29195 | 283 | 4 |
282469 | 282469 | 2020-06-28 | Saline | Nebraska | 31151 | 533 | 2 |
277807 | 277807 | 2020-06-27 | Saline | Arkansas | 5125 | 246 | 2 |
278306 | 278306 | 2020-06-27 | Saline | Illinois | 17165 | 9 | 0 |
278595 | 278595 | 2020-06-27 | Saline | Kansas | 20169 | 98 | 2 |
279199 | 279199 | 2020-06-27 | Saline | Missouri | 29195 | 282 | 4 |
279321 | 279321 | 2020-06-27 | Saline | Nebraska | 31151 | 533 | 2 |
274659 | 274659 | 2020-06-26 | Saline | Arkansas | 5125 | 233 | 2 |
275158 | 275158 | 2020-06-26 | Saline | Illinois | 17165 | 8 | 0 |
275447 | 275447 | 2020-06-26 | Saline | Kansas | 20169 | 98 | 2 |
276051 | 276051 | 2020-06-26 | Saline | Missouri | 29195 | 282 | 4 |
276173 | 276173 | 2020-06-26 | Saline | Nebraska | 31151 | 531 | 2 |
271519 | 271519 | 2020-06-25 | Saline | Arkansas | 5125 | 225 | 2 |
272016 | 272016 | 2020-06-25 | Saline | Illinois | 17165 | 8 | 0 |
272304 | 272304 | 2020-06-25 | Saline | Kansas | 20169 | 77 | 2 |
272908 | 272908 | 2020-06-25 | Saline | Missouri | 29195 | 282 | 4 |
273030 | 273030 | 2020-06-25 | Saline | Nebraska | 31151 | 531 | 2 |
268384 | 268384 | 2020-06-24 | Saline | Arkansas | 5125 | 217 | 2 |
268879 | 268879 | 2020-06-24 | Saline | Illinois | 17165 | 8 | 0 |
269167 | 269167 | 2020-06-24 | Saline | Kansas | 20169 | 77 | 2 |
269769 | 269769 | 2020-06-24 | Saline | Missouri | 29195 | 278 | 4 |
269891 | 269891 | 2020-06-24 | Saline | Nebraska | 31151 | 530 | 2 |
265254 | 265254 | 2020-06-23 | Saline | Arkansas | 5125 | 211 | 2 |
265749 | 265749 | 2020-06-23 | Saline | Illinois | 17165 | 8 | 0 |
266035 | 266035 | 2020-06-23 | Saline | Kansas | 20169 | 55 | 2 |
266636 | 266636 | 2020-06-23 | Saline | Missouri | 29195 | 278 | 4 |
266756 | 266756 | 2020-06-23 | Saline | Nebraska | 31151 | 530 | 2 |
262126 | 262126 | 2020-06-22 | Saline | Arkansas | 5125 | 210 | 2 |
262621 | 262621 | 2020-06-22 | Saline | Illinois | 17165 | 8 | 0 |
262907 | 262907 | 2020-06-22 | Saline | Kansas | 20169 | 50 | 2 |
263510 | 263510 | 2020-06-22 | Saline | Missouri | 29195 | 278 | 4 |
263629 | 263629 | 2020-06-22 | Saline | Nebraska | 31151 | 530 | 2 |
258999 | 258999 | 2020-06-21 | Saline | Arkansas | 5125 | 209 | 2 |
259494 | 259494 | 2020-06-21 | Saline | Illinois | 17165 | 8 | 0 |
259780 | 259780 | 2020-06-21 | Saline | Kansas | 20169 | 45 | 2 |
260382 | 260382 | 2020-06-21 | Saline | Missouri | 29195 | 278 | 4 |
260500 | 260500 | 2020-06-21 | Saline | Nebraska | 31151 | 525 | 2 |
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);