ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,114 rows where county = "Smith" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- Texas 767
- Mississippi 760
- Tennessee 753
- Kansas 734
county 1
- Smith · 3,014 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419149 | 2419149 | 2022-04-18 | Smith | Kansas | 20183 | 644 | 7 |
2419642 | 2419642 | 2022-04-18 | Smith | Mississippi | 28129 | 4112 | 68 |
2420775 | 2420775 | 2022-04-18 | Smith | Tennessee | 47159 | 6161 | 84 |
2421003 | 2421003 | 2022-04-18 | Smith | Texas | 48423 | 45455 | 964 |
2415893 | 2415893 | 2022-04-17 | Smith | Kansas | 20183 | 644 | 7 |
2416386 | 2416386 | 2022-04-17 | Smith | Mississippi | 28129 | 4111 | 68 |
2417519 | 2417519 | 2022-04-17 | Smith | Tennessee | 47159 | 6161 | 84 |
2417747 | 2417747 | 2022-04-17 | Smith | Texas | 48423 | 45427 | 964 |
2412637 | 2412637 | 2022-04-16 | Smith | Kansas | 20183 | 644 | 7 |
2413130 | 2413130 | 2022-04-16 | Smith | Mississippi | 28129 | 4111 | 68 |
2414263 | 2414263 | 2022-04-16 | Smith | Tennessee | 47159 | 6161 | 84 |
2414491 | 2414491 | 2022-04-16 | Smith | Texas | 48423 | 45427 | 964 |
2409381 | 2409381 | 2022-04-15 | Smith | Kansas | 20183 | 644 | 7 |
2409874 | 2409874 | 2022-04-15 | Smith | Mississippi | 28129 | 4111 | 68 |
2411007 | 2411007 | 2022-04-15 | Smith | Tennessee | 47159 | 6161 | 84 |
2411235 | 2411235 | 2022-04-15 | Smith | Texas | 48423 | 45427 | 964 |
2406125 | 2406125 | 2022-04-14 | Smith | Kansas | 20183 | 643 | 7 |
2406618 | 2406618 | 2022-04-14 | Smith | Mississippi | 28129 | 4111 | 68 |
2407751 | 2407751 | 2022-04-14 | Smith | Tennessee | 47159 | 6161 | 84 |
2407979 | 2407979 | 2022-04-14 | Smith | Texas | 48423 | 45427 | 964 |
2402869 | 2402869 | 2022-04-13 | Smith | Kansas | 20183 | 643 | 7 |
2403362 | 2403362 | 2022-04-13 | Smith | Mississippi | 28129 | 4111 | 68 |
2404495 | 2404495 | 2022-04-13 | Smith | Tennessee | 47159 | 6161 | 84 |
2404723 | 2404723 | 2022-04-13 | Smith | Texas | 48423 | 45421 | 964 |
2399615 | 2399615 | 2022-04-12 | Smith | Kansas | 20183 | 643 | 7 |
2400108 | 2400108 | 2022-04-12 | Smith | Mississippi | 28129 | 4111 | 68 |
2401240 | 2401240 | 2022-04-12 | Smith | Tennessee | 47159 | 6160 | 83 |
2401468 | 2401468 | 2022-04-12 | Smith | Texas | 48423 | 45418 | 964 |
2396359 | 2396359 | 2022-04-11 | Smith | Kansas | 20183 | 643 | 7 |
2396852 | 2396852 | 2022-04-11 | Smith | Mississippi | 28129 | 4106 | 67 |
2397985 | 2397985 | 2022-04-11 | Smith | Tennessee | 47159 | 6160 | 83 |
2398213 | 2398213 | 2022-04-11 | Smith | Texas | 48423 | 45415 | 964 |
2393104 | 2393104 | 2022-04-10 | Smith | Kansas | 20183 | 643 | 7 |
2393597 | 2393597 | 2022-04-10 | Smith | Mississippi | 28129 | 4106 | 67 |
2394730 | 2394730 | 2022-04-10 | Smith | Tennessee | 47159 | 6160 | 83 |
2394958 | 2394958 | 2022-04-10 | Smith | Texas | 48423 | 45409 | 964 |
2389848 | 2389848 | 2022-04-09 | Smith | Kansas | 20183 | 643 | 7 |
2390341 | 2390341 | 2022-04-09 | Smith | Mississippi | 28129 | 4106 | 67 |
2391474 | 2391474 | 2022-04-09 | Smith | Tennessee | 47159 | 6160 | 83 |
2391702 | 2391702 | 2022-04-09 | Smith | Texas | 48423 | 45407 | 964 |
2386592 | 2386592 | 2022-04-08 | Smith | Kansas | 20183 | 643 | 7 |
2387085 | 2387085 | 2022-04-08 | Smith | Mississippi | 28129 | 4106 | 67 |
2388218 | 2388218 | 2022-04-08 | Smith | Tennessee | 47159 | 6160 | 83 |
2388446 | 2388446 | 2022-04-08 | Smith | Texas | 48423 | 45403 | 964 |
2383338 | 2383338 | 2022-04-07 | Smith | Kansas | 20183 | 643 | 7 |
2383830 | 2383830 | 2022-04-07 | Smith | Mississippi | 28129 | 4106 | 67 |
2384963 | 2384963 | 2022-04-07 | Smith | Tennessee | 47159 | 6160 | 83 |
2385191 | 2385191 | 2022-04-07 | Smith | Texas | 48423 | 45396 | 964 |
2380083 | 2380083 | 2022-04-06 | Smith | Kansas | 20183 | 643 | 7 |
2380575 | 2380575 | 2022-04-06 | Smith | Mississippi | 28129 | 4106 | 67 |
2381708 | 2381708 | 2022-04-06 | Smith | Tennessee | 47159 | 6160 | 83 |
2381936 | 2381936 | 2022-04-06 | Smith | Texas | 48423 | 45393 | 964 |
2376828 | 2376828 | 2022-04-05 | Smith | Kansas | 20183 | 643 | 7 |
2377320 | 2377320 | 2022-04-05 | Smith | Mississippi | 28129 | 4106 | 67 |
2378453 | 2378453 | 2022-04-05 | Smith | Tennessee | 47159 | 6158 | 83 |
2378681 | 2378681 | 2022-04-05 | Smith | Texas | 48423 | 45392 | 964 |
2373576 | 2373576 | 2022-04-04 | Smith | Kansas | 20183 | 643 | 7 |
2374068 | 2374068 | 2022-04-04 | Smith | Mississippi | 28129 | 4106 | 67 |
2375199 | 2375199 | 2022-04-04 | Smith | Tennessee | 47159 | 6158 | 83 |
2375427 | 2375427 | 2022-04-04 | Smith | Texas | 48423 | 45387 | 962 |
2370323 | 2370323 | 2022-04-03 | Smith | Kansas | 20183 | 643 | 7 |
2370815 | 2370815 | 2022-04-03 | Smith | Mississippi | 28129 | 4098 | 67 |
2371947 | 2371947 | 2022-04-03 | Smith | Tennessee | 47159 | 6158 | 83 |
2372175 | 2372175 | 2022-04-03 | Smith | Texas | 48423 | 45384 | 962 |
2367070 | 2367070 | 2022-04-02 | Smith | Kansas | 20183 | 643 | 7 |
2367562 | 2367562 | 2022-04-02 | Smith | Mississippi | 28129 | 4098 | 67 |
2368694 | 2368694 | 2022-04-02 | Smith | Tennessee | 47159 | 6158 | 83 |
2368922 | 2368922 | 2022-04-02 | Smith | Texas | 48423 | 45383 | 962 |
2363817 | 2363817 | 2022-04-01 | Smith | Kansas | 20183 | 643 | 7 |
2364309 | 2364309 | 2022-04-01 | Smith | Mississippi | 28129 | 4098 | 67 |
2365441 | 2365441 | 2022-04-01 | Smith | Tennessee | 47159 | 6158 | 83 |
2365669 | 2365669 | 2022-04-01 | Smith | Texas | 48423 | 45378 | 962 |
2360563 | 2360563 | 2022-03-31 | Smith | Kansas | 20183 | 643 | 7 |
2361055 | 2361055 | 2022-03-31 | Smith | Mississippi | 28129 | 4098 | 67 |
2362188 | 2362188 | 2022-03-31 | Smith | Tennessee | 47159 | 6158 | 83 |
2362416 | 2362416 | 2022-03-31 | Smith | Texas | 48423 | 45375 | 962 |
2357309 | 2357309 | 2022-03-30 | Smith | Kansas | 20183 | 643 | 7 |
2357801 | 2357801 | 2022-03-30 | Smith | Mississippi | 28129 | 4098 | 67 |
2358934 | 2358934 | 2022-03-30 | Smith | Tennessee | 47159 | 6158 | 83 |
2359162 | 2359162 | 2022-03-30 | Smith | Texas | 48423 | 45343 | 962 |
2354056 | 2354056 | 2022-03-29 | Smith | Kansas | 20183 | 643 | 7 |
2354548 | 2354548 | 2022-03-29 | Smith | Mississippi | 28129 | 4098 | 67 |
2355680 | 2355680 | 2022-03-29 | Smith | Tennessee | 47159 | 6157 | 83 |
2355908 | 2355908 | 2022-03-29 | Smith | Texas | 48423 | 45342 | 960 |
2350804 | 2350804 | 2022-03-28 | Smith | Kansas | 20183 | 643 | 7 |
2351296 | 2351296 | 2022-03-28 | Smith | Mississippi | 28129 | 4098 | 67 |
2352427 | 2352427 | 2022-03-28 | Smith | Tennessee | 47159 | 6157 | 83 |
2352655 | 2352655 | 2022-03-28 | Smith | Texas | 48423 | 45336 | 960 |
2347551 | 2347551 | 2022-03-27 | Smith | Kansas | 20183 | 643 | 7 |
2348043 | 2348043 | 2022-03-27 | Smith | Mississippi | 28129 | 4095 | 67 |
2349175 | 2349175 | 2022-03-27 | Smith | Tennessee | 47159 | 6157 | 83 |
2349403 | 2349403 | 2022-03-27 | Smith | Texas | 48423 | 45335 | 960 |
2344298 | 2344298 | 2022-03-26 | Smith | Kansas | 20183 | 643 | 7 |
2344790 | 2344790 | 2022-03-26 | Smith | Mississippi | 28129 | 4095 | 67 |
2345922 | 2345922 | 2022-03-26 | Smith | Tennessee | 47159 | 6157 | 83 |
2346150 | 2346150 | 2022-03-26 | Smith | Texas | 48423 | 45335 | 960 |
2341045 | 2341045 | 2022-03-25 | Smith | Kansas | 20183 | 643 | 7 |
2341537 | 2341537 | 2022-03-25 | Smith | Mississippi | 28129 | 4095 | 67 |
2342669 | 2342669 | 2022-03-25 | Smith | Tennessee | 47159 | 6157 | 83 |
2342897 | 2342897 | 2022-03-25 | Smith | Texas | 48423 | 45330 | 959 |
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);