ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Clark" and state = "Nevada" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536180 | 536180 | 2020-09-15 | Clark | Nevada | 32003 | 62952 | 1287 |
532945 | 532945 | 2020-09-14 | Clark | Nevada | 32003 | 62812 | 1262 |
529709 | 529709 | 2020-09-13 | Clark | Nevada | 32003 | 62650 | 1260 |
526473 | 526473 | 2020-09-12 | Clark | Nevada | 32003 | 62402 | 1259 |
523237 | 523237 | 2020-09-11 | Clark | Nevada | 32003 | 62057 | 1249 |
520000 | 520000 | 2020-09-10 | Clark | Nevada | 32003 | 61871 | 1240 |
516765 | 516765 | 2020-09-09 | Clark | Nevada | 32003 | 61642 | 1223 |
513531 | 513531 | 2020-09-08 | Clark | Nevada | 32003 | 61543 | 1206 |
510298 | 510298 | 2020-09-07 | Clark | Nevada | 32003 | 61476 | 1206 |
507065 | 507065 | 2020-09-06 | Clark | Nevada | 32003 | 61237 | 1205 |
503833 | 503833 | 2020-09-05 | Clark | Nevada | 32003 | 60819 | 1203 |
500599 | 500599 | 2020-09-04 | Clark | Nevada | 32003 | 60514 | 1190 |
497365 | 497365 | 2020-09-03 | Clark | Nevada | 32003 | 60144 | 1181 |
494132 | 494132 | 2020-09-02 | Clark | Nevada | 32003 | 59857 | 1157 |
490898 | 490898 | 2020-09-01 | Clark | Nevada | 32003 | 59716 | 1134 |
487665 | 487665 | 2020-08-31 | Clark | Nevada | 32003 | 59420 | 1126 |
484431 | 484431 | 2020-08-30 | Clark | Nevada | 32003 | 59153 | 1126 |
481196 | 481196 | 2020-08-29 | Clark | Nevada | 32003 | 58789 | 1126 |
477964 | 477964 | 2020-08-28 | Clark | Nevada | 32003 | 58292 | 1111 |
474731 | 474731 | 2020-08-27 | Clark | Nevada | 32003 | 57756 | 1099 |
471498 | 471498 | 2020-08-26 | Clark | Nevada | 32003 | 57283 | 1078 |
468266 | 468266 | 2020-08-25 | Clark | Nevada | 32003 | 57131 | 1058 |
465038 | 465038 | 2020-08-24 | Clark | Nevada | 32003 | 56796 | 1028 |
461807 | 461807 | 2020-08-23 | Clark | Nevada | 32003 | 56464 | 1027 |
458580 | 458580 | 2020-08-22 | Clark | Nevada | 32003 | 56010 | 1027 |
455352 | 455352 | 2020-08-21 | Clark | Nevada | 32003 | 55521 | 1015 |
452124 | 452124 | 2020-08-20 | Clark | Nevada | 32003 | 54795 | 1006 |
448896 | 448896 | 2020-08-19 | Clark | Nevada | 32003 | 54353 | 969 |
445669 | 445669 | 2020-08-18 | Clark | Nevada | 32003 | 54076 | 937 |
442443 | 442443 | 2020-08-17 | Clark | Nevada | 32003 | 53458 | 913 |
439216 | 439216 | 2020-08-16 | Clark | Nevada | 32003 | 52867 | 910 |
435991 | 435991 | 2020-08-15 | Clark | Nevada | 32003 | 52239 | 908 |
432765 | 432765 | 2020-08-14 | Clark | Nevada | 32003 | 51457 | 884 |
429538 | 429538 | 2020-08-13 | Clark | Nevada | 32003 | 50569 | 869 |
426313 | 426313 | 2020-08-12 | Clark | Nevada | 32003 | 50081 | 842 |
423091 | 423091 | 2020-08-11 | Clark | Nevada | 32003 | 49646 | 828 |
419868 | 419868 | 2020-08-10 | Clark | Nevada | 32003 | 49151 | 811 |
416647 | 416647 | 2020-08-09 | Clark | Nevada | 32003 | 48466 | 807 |
413426 | 413426 | 2020-08-08 | Clark | Nevada | 32003 | 47739 | 799 |
410206 | 410206 | 2020-08-07 | Clark | Nevada | 32003 | 46990 | 770 |
406986 | 406986 | 2020-08-06 | Clark | Nevada | 32003 | 46185 | 752 |
403767 | 403767 | 2020-08-05 | Clark | Nevada | 32003 | 45563 | 744 |
400549 | 400549 | 2020-08-04 | Clark | Nevada | 32003 | 44997 | 716 |
397334 | 397334 | 2020-08-03 | Clark | Nevada | 32003 | 44066 | 702 |
394118 | 394118 | 2020-08-02 | Clark | Nevada | 32003 | 43147 | 688 |
390901 | 390901 | 2020-08-01 | Clark | Nevada | 32003 | 42167 | 688 |
387684 | 387684 | 2020-07-31 | Clark | Nevada | 32003 | 41245 | 687 |
384467 | 384467 | 2020-07-30 | Clark | Nevada | 32003 | 40193 | 664 |
381250 | 381250 | 2020-07-29 | Clark | Nevada | 32003 | 39345 | 645 |
378032 | 378032 | 2020-07-28 | Clark | Nevada | 32003 | 38534 | 626 |
374817 | 374817 | 2020-07-27 | Clark | Nevada | 32003 | 37492 | 606 |
371605 | 371605 | 2020-07-26 | Clark | Nevada | 32003 | 36593 | 601 |
368393 | 368393 | 2020-07-25 | Clark | Nevada | 32003 | 35786 | 601 |
365184 | 365184 | 2020-07-24 | Clark | Nevada | 32003 | 35000 | 592 |
361978 | 361978 | 2020-07-23 | Clark | Nevada | 32003 | 34209 | 580 |
358772 | 358772 | 2020-07-22 | Clark | Nevada | 32003 | 33057 | 577 |
355568 | 355568 | 2020-07-21 | Clark | Nevada | 32003 | 32025 | 553 |
352365 | 352365 | 2020-07-20 | Clark | Nevada | 32003 | 31312 | 527 |
349162 | 349162 | 2020-07-19 | Clark | Nevada | 32003 | 30432 | 527 |
345961 | 345961 | 2020-07-18 | Clark | Nevada | 32003 | 29304 | 527 |
342762 | 342762 | 2020-07-17 | Clark | Nevada | 32003 | 28189 | 518 |
339564 | 339564 | 2020-07-16 | Clark | Nevada | 32003 | 26926 | 507 |
336368 | 336368 | 2020-07-15 | Clark | Nevada | 32003 | 25611 | 502 |
333174 | 333174 | 2020-07-14 | Clark | Nevada | 32003 | 24824 | 498 |
329983 | 329983 | 2020-07-13 | Clark | Nevada | 32003 | 23803 | 483 |
326796 | 326796 | 2020-07-12 | Clark | Nevada | 32003 | 23048 | 483 |
323612 | 323612 | 2020-07-11 | Clark | Nevada | 32003 | 22286 | 483 |
320432 | 320432 | 2020-07-10 | Clark | Nevada | 32003 | 21449 | 473 |
317256 | 317256 | 2020-07-09 | Clark | Nevada | 32003 | 20622 | 468 |
314082 | 314082 | 2020-07-08 | Clark | Nevada | 32003 | 20126 | 454 |
310911 | 310911 | 2020-07-07 | Clark | Nevada | 32003 | 19654 | 450 |
307743 | 307743 | 2020-07-06 | Clark | Nevada | 32003 | 18818 | 439 |
304576 | 304576 | 2020-07-05 | Clark | Nevada | 32003 | 18442 | 439 |
301413 | 301413 | 2020-07-04 | Clark | Nevada | 32003 | 17707 | 435 |
298250 | 298250 | 2020-07-03 | Clark | Nevada | 32003 | 17028 | 435 |
295090 | 295090 | 2020-07-02 | Clark | Nevada | 32003 | 16180 | 432 |
291935 | 291935 | 2020-07-01 | Clark | Nevada | 32003 | 15604 | 420 |
288783 | 288783 | 2020-06-30 | Clark | Nevada | 32003 | 15095 | 416 |
285633 | 285633 | 2020-06-29 | Clark | Nevada | 32003 | 14607 | 414 |
282488 | 282488 | 2020-06-28 | Clark | Nevada | 32003 | 13910 | 410 |
279341 | 279341 | 2020-06-27 | Clark | Nevada | 32003 | 13174 | 410 |
276193 | 276193 | 2020-06-26 | Clark | Nevada | 32003 | 12204 | 408 |
273049 | 273049 | 2020-06-25 | Clark | Nevada | 32003 | 11878 | 405 |
269910 | 269910 | 2020-06-24 | Clark | Nevada | 32003 | 11481 | 404 |
266775 | 266775 | 2020-06-23 | Clark | Nevada | 32003 | 11186 | 402 |
263648 | 263648 | 2020-06-22 | Clark | Nevada | 32003 | 10774 | 400 |
260519 | 260519 | 2020-06-21 | Clark | Nevada | 32003 | 10486 | 398 |
257393 | 257393 | 2020-06-20 | Clark | Nevada | 32003 | 10259 | 397 |
254270 | 254270 | 2020-06-19 | Clark | Nevada | 32003 | 9852 | 390 |
251155 | 251155 | 2020-06-18 | Clark | Nevada | 32003 | 9535 | 387 |
248040 | 248040 | 2020-06-17 | Clark | Nevada | 32003 | 9318 | 386 |
244927 | 244927 | 2020-06-16 | Clark | Nevada | 32003 | 9157 | 380 |
241815 | 241815 | 2020-06-15 | Clark | Nevada | 32003 | 8815 | 379 |
238705 | 238705 | 2020-06-14 | Clark | Nevada | 32003 | 8735 | 378 |
235598 | 235598 | 2020-06-13 | Clark | Nevada | 32003 | 8556 | 377 |
232493 | 232493 | 2020-06-12 | Clark | Nevada | 32003 | 8314 | 377 |
229388 | 229388 | 2020-06-11 | Clark | Nevada | 32003 | 8100 | 375 |
226284 | 226284 | 2020-06-10 | Clark | Nevada | 32003 | 7915 | 367 |
223184 | 223184 | 2020-06-09 | Clark | Nevada | 32003 | 7804 | 365 |
220089 | 220089 | 2020-06-08 | Clark | Nevada | 32003 | 7592 | 363 |
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);