participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,443 rows where station_code = "US003N" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5134435 | 5134435 | 20240916091342_M253F | US003N | 2024-09-19T12:17:43.672Z | 2024-09-19T12:17:43.672Z |
5134423 | 5134423 | 20240916090351_xjx5g | US003N | 2024-09-19T12:17:43.209Z | 2024-09-19T12:17:43.209Z |
5134420 | 5134420 | 20240916090339_WB8rY | US003N | 2024-09-19T12:17:43.035Z | 2024-09-19T12:17:43.035Z |
5134289 | 5134289 | 20240916074941_lMpM1 | US003N | 2024-09-19T12:17:35.395Z | 2024-09-19T12:17:35.395Z |
5134239 | 5134239 | 20240916072150_AJM6N | US003N | 2024-09-19T12:17:32.834Z | 2024-09-19T12:17:32.834Z |
5134228 | 5134228 | 20240916071046_Pxw2i | US003N | 2024-09-19T12:17:32.384Z | 2024-09-19T12:17:32.384Z |
5134208 | 5134208 | 20240916064141_YOSm3 | US003N | 2024-09-19T12:17:30.147Z | 2024-09-19T12:17:30.147Z |
5134190 | 5134190 | 20240916062957_tyGQj | US003N | 2024-09-19T12:17:28.791Z | 2024-09-19T12:17:28.791Z |
5123413 | 5123413 | 20240914100020_EvFX4 | US003N | 2024-09-18T12:11:48.272Z | 2024-09-19T12:20:10.787Z |
5123307 | 5123307 | 20240914093727_HfzXs | US003N | 2024-09-18T12:11:45.063Z | 2024-09-19T12:20:10.156Z |
5123299 | 5123299 | 20240914093712_Kb2RU | US003N | 2024-09-18T12:11:44.827Z | 2024-09-19T12:20:10.143Z |
5123268 | 5123268 | 20240914092812_Wro2L | US003N | 2024-09-18T12:11:43.751Z | 2024-09-19T12:20:09.245Z |
5123155 | 5123155 | 20240914090448_lONLX | US003N | 2024-09-18T12:11:41.323Z | 2024-09-19T12:20:08.496Z |
5123126 | 5123126 | 20240914085758_5CYMy | US003N | 2024-09-18T12:11:40.436Z | 2024-09-19T12:20:08.035Z |
5123076 | 5123076 | 20240914084753_VuHpC | US003N | 2024-09-18T12:11:39.526Z | 2024-09-19T12:20:07.576Z |
5122929 | 5122929 | 20240914082404_nocXV | US003N | 2024-09-18T12:11:34.280Z | 2024-09-19T12:20:06.707Z |
5122816 | 5122816 | 20240914080344_PHIwk | US003N | 2024-09-18T12:11:31.734Z | 2024-09-19T12:20:06.319Z |
5122745 | 5122745 | 20240914074827_83Sq7 | US003N | 2024-09-18T12:11:29.902Z | 2024-09-19T12:20:05.910Z |
5122709 | 5122709 | 20240914073439_pTFY8 | US003N | 2024-09-18T12:11:29.025Z | 2024-09-19T12:20:05.821Z |
5122677 | 5122677 | 20240914073044_9lGgx | US003N | 2024-09-18T12:11:28.178Z | 2024-09-19T12:20:05.663Z |
5122631 | 5122631 | 20240914072452_6wMUM | US003N | 2024-09-18T12:11:25.615Z | 2024-09-19T12:20:05.458Z |
5122614 | 5122614 | 20240914072259_XFd3m | US003N | 2024-09-18T12:11:24.994Z | 2024-09-19T12:20:05.385Z |
5122603 | 5122603 | 20240914072123_vQ1Ya | US003N | 2024-09-18T12:11:24.620Z | 2024-09-19T12:20:05.375Z |
5122599 | 5122599 | 20240914071633_7YZTh | US003N | 2024-09-18T12:11:24.510Z | 2024-09-19T12:20:05.363Z |
5122584 | 5122584 | 20240914071528_HZklZ | US003N | 2024-09-18T12:11:24.194Z | 2024-09-19T12:20:05.192Z |
5122435 | 5122435 | 20240914062217_d9Tg7 | US003N | 2024-09-18T12:11:18.304Z | 2024-09-19T12:20:04.311Z |
5122409 | 5122409 | 20240914061207_EWst3 | US003N | 2024-09-18T12:11:17.518Z | 2024-09-19T12:20:04.196Z |
5122370 | 5122370 | 20240914055909_16Wz5 | US003N | 2024-09-18T12:11:15.753Z | 2024-09-19T12:20:04.021Z |
5122325 | 5122325 | 20240914053932_FGx47 | US003N | 2024-09-18T12:11:14.412Z | 2024-09-19T12:20:03.932Z |
5122235 | 5122235 | 20240914050606_v23uW | US003N | 2024-09-18T12:11:11.082Z | 2024-09-19T12:20:03.363Z |
5122209 | 5122209 | 20240914045431_gzQRy | US003N | 2024-09-18T12:11:10.126Z | 2024-09-19T12:20:03.148Z |
5121343 | 5121343 | 20240914035833_D7uFv | US003N | 2024-09-18T12:10:54.615Z | 2024-09-19T12:20:01.637Z |
5121261 | 5121261 | 20240914035643_w2UvV | US003N | 2024-09-18T12:10:53.461Z | 2024-09-19T12:20:01.534Z |
5121134 | 5121134 | 20240914035356_j2S6o | US003N | 2024-09-18T12:10:51.797Z | 2024-09-19T12:20:01.448Z |
5121049 | 5121049 | 20240914034921_41GqT | US003N | 2024-09-18T12:10:50.324Z | 2024-09-19T12:20:01.261Z |
5120849 | 5120849 | 20240914033740_FlanF | US003N | 2024-09-18T12:10:47.707Z | 2024-09-19T12:20:00.937Z |
5120443 | 5120443 | 20240914032033_rJmuu | US003N | 2024-09-18T12:10:39.877Z | 2024-09-19T12:20:00.233Z |
5120243 | 5120243 | 20240914031005_fQrgh | US003N | 2024-09-18T12:10:36.128Z | 2024-09-19T12:19:59.807Z |
5119521 | 5119521 | 20240914023654_oYEqr | US003N | 2024-09-18T12:10:21.922Z | 2024-09-19T12:19:58.450Z |
5118468 | 5118468 | 20240915095237_EW7VV | US003N | 2024-09-18T12:08:46.299Z | 2024-09-19T12:19:23.109Z |
5118455 | 5118455 | 20240915095014_49zAp | US003N | 2024-09-18T12:08:45.148Z | 2024-09-19T12:19:23.042Z |
5118428 | 5118428 | 20240915094506_ZckM9 | US003N | 2024-09-18T12:08:43.530Z | 2024-09-19T12:19:22.778Z |
5118416 | 5118416 | 20240915094047_aS1ra | US003N | 2024-09-18T12:08:43.161Z | 2024-09-19T12:19:22.629Z |
5118401 | 5118401 | 20240915093808_aH1UG | US003N | 2024-09-18T12:08:42.353Z | 2024-09-19T12:19:22.504Z |
5118370 | 5118370 | 20240915092922_pvRyg | US003N | 2024-09-18T12:08:40.559Z | 2024-09-19T12:19:22.378Z |
5118354 | 5118354 | 20240915092749_xNBDh | US003N | 2024-09-18T12:08:39.314Z | 2024-09-19T12:19:22.264Z |
5118352 | 5118352 | 20240915092737_ibDf3 | US003N | 2024-09-18T12:08:39.214Z | 2024-09-19T12:19:22.243Z |
5118223 | 5118223 | 20240915085503_u26Ec | US003N | 2024-09-18T12:08:31.209Z | 2024-09-19T12:19:21.414Z |
5118135 | 5118135 | 20240915084029_zZlZQ | US003N | 2024-09-18T12:08:26.267Z | 2024-09-19T12:19:20.712Z |
5118120 | 5118120 | 20240915083610_mWjS7 | US003N | 2024-09-18T12:08:25.140Z | 2024-09-19T12:19:20.582Z |
5118045 | 5118045 | 20240915081507_TEh3m | US003N | 2024-09-18T12:08:20.474Z | 2024-09-19T12:19:19.936Z |
5117897 | 5117897 | 20240915073918_WnPnm | US003N | 2024-09-18T12:08:05.526Z | 2024-09-19T12:19:18.817Z |
5117779 | 5117779 | 20240915070026_X2G4R | US003N | 2024-09-18T12:07:58.767Z | 2024-09-19T12:19:17.839Z |
5117775 | 5117775 | 20240915070001_Cg9kj | US003N | 2024-09-18T12:07:58.333Z | 2024-09-19T12:19:17.815Z |
5117728 | 5117728 | 20240915063759_fTSgj | US003N | 2024-09-18T12:07:53.727Z | 2024-09-19T12:19:17.250Z |
5117700 | 5117700 | 20240915062830_EI1II | US003N | 2024-09-18T12:07:52.542Z | 2024-09-19T12:19:17.013Z |
5117653 | 5117653 | 20240915060429_9V5Fb | US003N | 2024-09-18T12:07:51.070Z | 2024-09-19T12:19:16.774Z |
5117501 | 5117501 | 20240915044722_I0e8T | US003N | 2024-09-18T12:07:43.473Z | 2024-09-19T12:19:15.500Z |
5117485 | 5117485 | 20240915044123_u33tg | US003N | 2024-09-18T12:07:42.645Z | 2024-09-19T12:19:15.342Z |
5117377 | 5117377 | 20240915042134_gkwQb | US003N | 2024-09-18T12:07:38.986Z | 2024-09-19T12:19:14.533Z |
5116500 | 5116500 | 20240915032956_RBmfw | US003N | 2024-09-18T12:07:07.556Z | 2024-09-19T12:19:11.386Z |
5114212 | 5114212 | 20240915013130_Vnx9E | US003N | 2024-09-18T12:05:06.670Z | 2024-09-19T12:18:56.922Z |
5114158 | 5114158 | 20240915012955_36z96 | US003N | 2024-09-18T12:05:04.542Z | 2024-09-19T12:18:56.517Z |
5109192 | 5109192 | 20240913091043_2GaNV | US003N | 2024-09-17T12:14:32.940Z | 2024-09-19T12:20:52.432Z |
5109166 | 5109166 | 20240913090128_d7JiM | US003N | 2024-09-17T12:14:32.168Z | 2024-09-19T12:20:52.349Z |
5109101 | 5109101 | 20240913084627_bU4O8 | US003N | 2024-09-17T12:14:30.305Z | 2024-09-19T12:20:51.711Z |
5108968 | 5108968 | 20240913081541_Y1eux | US003N | 2024-09-17T12:14:22.901Z | 2024-09-19T12:20:51.327Z |
5108964 | 5108964 | 20240913081524_xkrxi | US003N | 2024-09-17T12:14:22.451Z | 2024-09-19T12:20:51.312Z |
5108939 | 5108939 | 20240913080918_8POoy | US003N | 2024-09-17T12:14:20.475Z | 2024-09-19T12:20:51.222Z |
5108934 | 5108934 | 20240913080708_IoUu1 | US003N | 2024-09-17T12:14:19.338Z | 2024-09-19T12:20:51.205Z |
5108899 | 5108899 | 20240913080044_3IxR3 | US003N | 2024-09-17T12:14:15.884Z | 2024-09-19T12:20:51.063Z |
5108833 | 5108833 | 20240913074152_9mLVT | US003N | 2024-09-17T12:14:09.176Z | 2024-09-19T12:20:50.907Z |
5108817 | 5108817 | 20240913074036_JEJNJ | US003N | 2024-09-17T12:14:08.626Z | 2024-09-19T12:20:50.848Z |
5108804 | 5108804 | 20240913073454_ZB23z | US003N | 2024-09-17T12:14:07.922Z | 2024-09-19T12:20:50.815Z |
5108750 | 5108750 | 20240913071949_bOWxa | US003N | 2024-09-17T12:14:04.179Z | 2024-09-19T12:20:50.609Z |
5108716 | 5108716 | 20240913070748_pw3H4 | US003N | 2024-09-17T12:13:59.818Z | 2024-09-19T12:20:50.470Z |
5108688 | 5108688 | 20240913070043_vnNAZ | US003N | 2024-09-17T12:13:57.669Z | 2024-09-19T12:20:50.329Z |
5108665 | 5108665 | 20240913065653_ttu2W | US003N | 2024-09-17T12:13:56.448Z | 2024-09-19T12:20:50.215Z |
5108619 | 5108619 | 20240913064745_nFtFt | US003N | 2024-09-17T12:13:53.946Z | 2024-09-19T12:20:49.857Z |
5108614 | 5108614 | 20240913064502_rJ5zZ | US003N | 2024-09-17T12:13:53.725Z | 2024-09-19T12:20:49.812Z |
5108608 | 5108608 | 20240913064324_sHbuK | US003N | 2024-09-17T12:13:53.472Z | 2024-09-19T12:20:49.805Z |
5108591 | 5108591 | 20240913063707_2O28V | US003N | 2024-09-17T12:13:52.310Z | 2024-09-19T12:20:49.694Z |
5108562 | 5108562 | 20240913062822_Kp5zp | US003N | 2024-09-17T12:13:51.105Z | 2024-09-19T12:20:49.514Z |
5108534 | 5108534 | 20240913061956_IwYPv | US003N | 2024-09-17T12:13:50.244Z | 2024-09-19T12:20:49.394Z |
5108517 | 5108517 | 20240913060841_ptlxU | US003N | 2024-09-17T12:13:48.773Z | 2024-09-19T12:20:49.222Z |
5108502 | 5108502 | 20240913060411_3d5nf | US003N | 2024-09-17T12:13:48.026Z | 2024-09-19T12:20:49.056Z |
5108497 | 5108497 | 20240913060256_IA6Dg | US003N | 2024-09-17T12:13:47.809Z | 2024-09-19T12:20:49.051Z |
5108490 | 5108490 | 20240913055809_f2X2u | US003N | 2024-09-17T12:13:47.458Z | 2024-09-19T12:20:49.030Z |
5108446 | 5108446 | 20240913053643_c4QBT | US003N | 2024-09-17T12:13:44.924Z | 2024-09-19T12:20:48.832Z |
5108437 | 5108437 | 20240913053210_R4fwh | US003N | 2024-09-17T12:13:44.628Z | 2024-09-19T12:20:48.825Z |
5108429 | 5108429 | 20240913053135_FAoPT | US003N | 2024-09-17T12:13:44.166Z | 2024-09-19T12:20:48.784Z |
5108424 | 5108424 | 20240913053020_42mTX | US003N | 2024-09-17T12:13:43.901Z | 2024-09-19T12:20:48.769Z |
5108422 | 5108422 | 20240913053014_ezPjj | US003N | 2024-09-17T12:13:43.722Z | 2024-09-19T12:20:48.764Z |
5108416 | 5108416 | 20240913052953_1BlOz | US003N | 2024-09-17T12:13:43.469Z | 2024-09-19T12:20:48.733Z |
5108359 | 5108359 | 20240913050037_Qh2Sc | US003N | 2024-09-17T12:13:38.395Z | 2024-09-19T12:20:48.314Z |
5108341 | 5108341 | 20240913045747_RRaqj | US003N | 2024-09-17T12:13:37.654Z | 2024-09-19T12:20:48.281Z |
5108006 | 5108006 | 20240913041906_k3srB | US003N | 2024-09-17T12:13:28.064Z | 2024-09-19T12:20:47.744Z |
5107738 | 5107738 | 20240913040923_a3TkJ | US003N | 2024-09-17T12:13:23.165Z | 2024-09-19T12:20:47.512Z |
5107717 | 5107717 | 20240913040857_O8ZxX | US003N | 2024-09-17T12:13:22.349Z | 2024-09-19T12:20:47.492Z |
5107495 | 5107495 | 20240913035809_PusGl | US003N | 2024-09-17T12:13:16.317Z | 2024-09-19T12:20:47.193Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);