participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,948 rows where station_code = "US003S" 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 |
---|---|---|---|---|---|
5134089 | 5134089 | 20240916044841_tkVGt | US003S | 2024-09-19T12:17:18.793Z | 2024-09-19T12:17:18.793Z |
5129842 | 5129842 | 20240917043855_vB1FF | US003S | 2024-09-19T12:12:08.841Z | 2024-09-19T12:12:08.841Z |
5126419 | 5126419 | 20240918113721_Cu4dk | US003S | 2024-09-19T12:05:56.004Z | 2024-09-19T12:06:42.197Z |
5126409 | 5126409 | 20240918113325_xdZYi | US003S | 2024-09-19T12:05:54.974Z | 2024-09-19T12:06:42.196Z |
5126370 | 5126370 | 20240918111451_H5zKa | US003S | 2024-09-19T12:05:50.620Z | 2024-09-19T12:06:42.189Z |
5126352 | 5126352 | 20240918111016_LZohn | US003S | 2024-09-19T12:05:48.747Z | 2024-09-19T12:06:42.186Z |
5126343 | 5126343 | 20240918110712_aaFDH | US003S | 2024-09-19T12:05:47.737Z | 2024-09-19T12:06:42.185Z |
5126325 | 5126325 | 20240918105554_5jFFp | US003S | 2024-09-19T12:05:45.322Z | 2024-09-19T12:06:42.181Z |
5126211 | 5126211 | 20240918094527_l5ZRW | US003S | 2024-09-19T12:05:21.713Z | 2024-09-19T12:06:42.161Z |
5126115 | 5126115 | 20240918082632_IhK38 | US003S | 2024-09-19T12:05:08.581Z | 2024-09-19T12:06:42.143Z |
5126054 | 5126054 | 20240918074017_0MS5b | US003S | 2024-09-19T12:04:51.448Z | 2024-09-19T12:06:42.132Z |
5125374 | 5125374 | 20240918022253_b0xdR | US003S | 2024-09-19T12:03:06.950Z | 2024-09-19T12:06:42.023Z |
5123854 | 5123854 | 20240914114527_rwxlQ | US003S | 2024-09-18T12:11:58.755Z | 2024-09-19T12:20:15.784Z |
5123815 | 5123815 | 20240914113636_fdIu1 | US003S | 2024-09-18T12:11:58.300Z | 2024-09-19T12:20:15.441Z |
5123766 | 5123766 | 20240914112447_5D5Gl | US003S | 2024-09-18T12:11:56.846Z | 2024-09-19T12:20:14.739Z |
5123604 | 5123604 | 20240914104217_g7FDR | US003S | 2024-09-18T12:11:52.032Z | 2024-09-19T12:20:13.117Z |
5123559 | 5123559 | 20240914103318_RhMAh | US003S | 2024-09-18T12:11:51.367Z | 2024-09-19T12:20:12.624Z |
5123514 | 5123514 | 20240914102321_UQUg3 | US003S | 2024-09-18T12:11:50.571Z | 2024-09-19T12:20:11.527Z |
5123311 | 5123311 | 20240914094055_DneGq | US003S | 2024-09-18T12:11:45.149Z | 2024-09-19T12:20:10.322Z |
5123256 | 5123256 | 20240914092626_JAdB4 | US003S | 2024-09-18T12:11:43.467Z | 2024-09-19T12:20:09.197Z |
5123101 | 5123101 | 20240914085225_17OLd | US003S | 2024-09-18T12:11:39.888Z | 2024-09-19T12:20:07.682Z |
5122977 | 5122977 | 20240914082916_9WUVn | US003S | 2024-09-18T12:11:36.199Z | 2024-09-19T12:20:06.992Z |
5122865 | 5122865 | 20240914081300_pgL2e | US003S | 2024-09-18T12:11:32.866Z | 2024-09-19T12:20:06.526Z |
5122601 | 5122601 | 20240914071952_C9u7g | US003S | 2024-09-18T12:11:24.612Z | 2024-09-19T12:20:05.373Z |
5122530 | 5122530 | 20240914070333_Nape3 | US003S | 2024-09-18T12:11:22.217Z | 2024-09-19T12:20:04.813Z |
5121590 | 5121590 | 20240914041009_ychrY | US003S | 2024-09-18T12:10:58.658Z | 2024-09-19T12:20:02.160Z |
5121559 | 5121559 | 20240914040911_Kv32d | US003S | 2024-09-18T12:10:58.384Z | 2024-09-19T12:20:02.136Z |
5120475 | 5120475 | 20240914032309_GmceI | US003S | 2024-09-18T12:10:41.458Z | 2024-09-19T12:20:00.455Z |
5120374 | 5120374 | 20240914031827_19OOh | US003S | 2024-09-18T12:10:39.040Z | 2024-09-19T12:20:00.085Z |
5118841 | 5118841 | 20240915111906_nBR7W | US003S | 2024-09-18T12:09:07.758Z | 2024-09-19T12:19:26.489Z |
5118691 | 5118691 | 20240915104747_5K5yU | US003S | 2024-09-18T12:08:58.857Z | 2024-09-19T12:19:24.965Z |
5118465 | 5118465 | 20240915095132_Lu5pW | US003S | 2024-09-18T12:08:46.124Z | 2024-09-19T12:19:23.086Z |
5118229 | 5118229 | 20240915085739_uaqNZ | US003S | 2024-09-18T12:08:31.539Z | 2024-09-19T12:19:21.453Z |
5118211 | 5118211 | 20240915085308_1UjU7 | US003S | 2024-09-18T12:08:30.069Z | 2024-09-19T12:19:21.273Z |
5118189 | 5118189 | 20240915084807_zBFyQ | US003S | 2024-09-18T12:08:29.053Z | 2024-09-19T12:19:21.133Z |
5118013 | 5118013 | 20240915080826_6REI9 | US003S | 2024-09-18T12:08:17.249Z | 2024-09-19T12:19:19.757Z |
5117935 | 5117935 | 20240915075021_k0n3U | US003S | 2024-09-18T12:08:08.237Z | 2024-09-19T12:19:19.082Z |
5117649 | 5117649 | 20240915060210_blD1o | US003S | 2024-09-18T12:07:50.960Z | 2024-09-19T12:19:16.741Z |
5117616 | 5117616 | 20240915054805_7vzHf | US003S | 2024-09-18T12:07:49.249Z | 2024-09-19T12:19:16.460Z |
5117531 | 5117531 | 20240915050310_JIIhS | US003S | 2024-09-18T12:07:45.388Z | 2024-09-19T12:19:15.718Z |
5117492 | 5117492 | 20240915044350_y2iJQ | US003S | 2024-09-18T12:07:43.028Z | 2024-09-19T12:19:15.455Z |
5117410 | 5117410 | 20240915043020_ISstG | US003S | 2024-09-18T12:07:40.639Z | 2024-09-19T12:19:14.927Z |
5109547 | 5109547 | 20240913102440_vSNle | US003S | 2024-09-17T12:14:40.962Z | 2024-09-19T12:20:53.721Z |
5109466 | 5109466 | 20240913095914_Ej501 | US003S | 2024-09-17T12:14:38.816Z | 2024-09-19T12:20:53.421Z |
5109417 | 5109417 | 20240913095129_NTM9W | US003S | 2024-09-17T12:14:37.786Z | 2024-09-19T12:20:53.265Z |
5109394 | 5109394 | 20240913094842_Hp6vV | US003S | 2024-09-17T12:14:37.335Z | 2024-09-19T12:20:53.207Z |
5109360 | 5109360 | 20240913093836_EU25a | US003S | 2024-09-17T12:14:36.453Z | 2024-09-19T12:20:53.100Z |
5109357 | 5109357 | 20240913093740_YGNSl | US003S | 2024-09-17T12:14:36.332Z | 2024-09-19T12:20:53.095Z |
5109188 | 5109188 | 20240913090945_A5Yxj | US003S | 2024-09-17T12:14:32.815Z | 2024-09-19T12:20:52.420Z |
5108962 | 5108962 | 20240913081447_UjDAm | US003S | 2024-09-17T12:14:22.275Z | 2024-09-19T12:20:51.306Z |
5108813 | 5108813 | 20240913073838_273X3 | US003S | 2024-09-17T12:14:08.390Z | 2024-09-19T12:20:50.833Z |
5108526 | 5108526 | 20240913060909_WZW1N | US003S | 2024-09-17T12:13:49.798Z | 2024-09-19T12:20:49.271Z |
5108467 | 5108467 | 20240913054744_yfNas | US003S | 2024-09-17T12:13:45.976Z | 2024-09-19T12:20:48.902Z |
5108384 | 5108384 | 20240913051450_Z8p2U | US003S | 2024-09-17T12:13:42.138Z | 2024-09-19T12:20:48.567Z |
5108372 | 5108372 | 20240913051208_Xpr0l | US003S | 2024-09-17T12:13:40.985Z | 2024-09-19T12:20:48.468Z |
5105147 | 5105147 | 20240913023236_x42tw | US003S | 2024-09-17T12:11:58.439Z | 2024-09-19T12:20:43.995Z |
5096768 | 5096768 | 20240912113906_I6Xyf | US003S | 2024-09-16T12:16:34.350Z | 2024-09-19T12:21:23.597Z |
5096751 | 5096751 | 20240912113730_eduzM | US003S | 2024-09-16T12:16:34.002Z | 2024-09-19T12:21:23.543Z |
5096748 | 5096748 | 20240912113716_AElB1 | US003S | 2024-09-16T12:16:33.883Z | 2024-09-19T12:21:23.541Z |
5096732 | 5096732 | 20240912113514_gDRke | US003S | 2024-09-16T12:16:33.150Z | 2024-09-19T12:21:23.520Z |
5096640 | 5096640 | 20240912112638_SPWHM | US003S | 2024-09-16T12:16:30.500Z | 2024-09-19T12:21:23.348Z |
5096510 | 5096510 | 20240912110522_WN0E4 | US003S | 2024-09-16T12:16:25.794Z | 2024-09-19T12:21:22.456Z |
5096395 | 5096395 | 20240912104332_L2gaA | US003S | 2024-09-16T12:16:22.441Z | 2024-09-19T12:21:22.243Z |
5096358 | 5096358 | 20240912103726_phACf | US003S | 2024-09-16T12:16:21.336Z | 2024-09-19T12:21:22.189Z |
5096183 | 5096183 | 20240912101249_oo5E8 | US003S | 2024-09-16T12:16:13.747Z | 2024-09-19T12:21:21.811Z |
5096114 | 5096114 | 20240912100425_Uy3X4 | US003S | 2024-09-16T12:16:10.763Z | 2024-09-19T12:21:21.547Z |
5095796 | 5095796 | 20240912090527_gF0el | US003S | 2024-09-16T12:15:58.498Z | 2024-09-19T12:21:20.248Z |
5095712 | 5095712 | 20240912084830_zAKPv | US003S | 2024-09-16T12:15:54.492Z | 2024-09-19T12:21:19.892Z |
5095519 | 5095519 | 20240912075704_67eKL | US003S | 2024-09-16T12:15:45.510Z | 2024-09-19T12:21:18.778Z |
5095473 | 5095473 | 20240912074313_JawV4 | US003S | 2024-09-16T12:15:42.347Z | 2024-09-19T12:21:18.623Z |
5095316 | 5095316 | 20240912071156_ZYkth | US003S | 2024-09-16T12:15:32.231Z | 2024-09-19T12:21:18.131Z |
5095057 | 5095057 | 20240912053307_0sLiI | US003S | 2024-09-16T12:15:11.522Z | 2024-09-19T12:21:17.132Z |
5094987 | 5094987 | 20240912050000_TF84R | US003S | 2024-09-16T12:15:07.380Z | 2024-09-19T12:21:16.855Z |
5094932 | 5094932 | 20240912044016_ijnrB | US003S | 2024-09-16T12:15:01.783Z | 2024-09-19T12:21:16.583Z |
5082883 | 5082883 | 20240911112000_QaVg6 | US003S | 2024-09-15T12:18:28.690Z | 2024-09-19T12:21:48.801Z |
5082750 | 5082750 | 20240911105535_nBVFC | US003S | 2024-09-15T12:18:24.792Z | 2024-09-19T12:21:48.525Z |
5082735 | 5082735 | 20240911105051_23364 | US003S | 2024-09-15T12:18:24.214Z | 2024-09-19T12:21:48.491Z |
5082705 | 5082705 | 20240911104753_SsU0f | US003S | 2024-09-15T12:18:22.977Z | 2024-09-19T12:21:48.365Z |
5082339 | 5082339 | 20240911095543_mlUT0 | US003S | 2024-09-15T12:18:11.602Z | 2024-09-19T12:21:47.826Z |
5082295 | 5082295 | 20240911095006_VfRoF | US003S | 2024-09-15T12:18:10.228Z | 2024-09-19T12:21:47.686Z |
5082230 | 5082230 | 20240911094143_tTujJ | US003S | 2024-09-15T12:18:08.730Z | 2024-09-19T12:21:47.539Z |
5082223 | 5082223 | 20240911093950_yyhMh | US003S | 2024-09-15T12:18:07.307Z | 2024-09-19T12:21:47.536Z |
5082182 | 5082182 | 20240911093328_0xEUK | US003S | 2024-09-15T12:18:06.051Z | 2024-09-19T12:21:47.425Z |
5081879 | 5081879 | 20240911085744_O2ZU3 | US003S | 2024-09-15T12:17:52.995Z | 2024-09-19T12:21:46.613Z |
5081538 | 5081538 | 20240911075644_TgvxB | US003S | 2024-09-15T12:17:37.265Z | 2024-09-19T12:21:45.693Z |
5081328 | 5081328 | 20240911072224_B20OQ | US003S | 2024-09-15T12:17:30.393Z | 2024-09-19T12:21:45.089Z |
5068612 | 5068612 | 20240910115452_MISlP | US003S | 2024-09-14T12:19:19.452Z | 2024-09-18T12:15:26.398Z |
5068581 | 5068581 | 20240910115121_Ehpao | US003S | 2024-09-14T12:19:18.599Z | 2024-09-18T12:15:26.343Z |
5068348 | 5068348 | 20240910112302_vDyMt | US003S | 2024-09-14T12:19:12.987Z | 2024-09-18T12:15:25.969Z |
5068073 | 5068073 | 20240910105020_83GBk | US003S | 2024-09-14T12:19:08.134Z | 2024-09-18T12:15:25.519Z |
5068061 | 5068061 | 20240910104838_Z0UM1 | US003S | 2024-09-14T12:19:07.886Z | 2024-09-18T12:15:25.486Z |
5068018 | 5068018 | 20240910104010_kh1Mp | US003S | 2024-09-14T12:19:06.871Z | 2024-09-18T12:15:25.370Z |
5067620 | 5067620 | 20240910095339_QrnPj | US003S | 2024-09-14T12:18:50.883Z | 2024-09-18T12:15:24.561Z |
5067532 | 5067532 | 20240910094208_tjKSq | US003S | 2024-09-14T12:18:47.484Z | 2024-09-18T12:15:24.314Z |
5067463 | 5067463 | 20240910093408_LJ5zN | US003S | 2024-09-14T12:18:44.521Z | 2024-09-18T12:15:24.164Z |
5067174 | 5067174 | 20240910090237_acWUT | US003S | 2024-09-14T12:18:34.664Z | 2024-09-18T12:15:23.524Z |
5066911 | 5066911 | 20240910083109_nVyvp | US003S | 2024-09-14T12:18:18.841Z | 2024-09-18T12:15:22.967Z |
5066721 | 5066721 | 20240910080821_c35Hf | US003S | 2024-09-14T12:18:09.051Z | 2024-09-18T12:15:22.609Z |
5066656 | 5066656 | 20240910080002_sgud8 | US003S | 2024-09-14T12:18:06.325Z | 2024-09-18T12:15:22.382Z |
5066597 | 5066597 | 20240910075319_9DBSv | US003S | 2024-09-14T12:18:03.961Z | 2024-09-18T12:15:22.274Z |
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);