participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,652 rows where station_code = "US0039" 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 |
---|---|---|---|---|---|
5505553 | 5505553 | 20241108060634_1pLan | US0039 | 2024-11-09T14:16:23.112Z | 2024-11-09T14:16:28.814Z |
5505489 | 5505489 | 20241108054051_K3W8l | US0039 | 2024-11-09T14:16:20.548Z | 2024-11-09T14:16:28.798Z |
5504712 | 5504712 | 20241108024255_W4E3n | US0039 | 2024-11-09T14:15:05.476Z | 2024-11-09T14:16:28.606Z |
5504706 | 5504706 | 20241108024210_n5fyK | US0039 | 2024-11-09T14:15:05.201Z | 2024-11-09T14:16:28.605Z |
5504488 | 5504488 | 20241108020609_3Okou | US0039 | 2024-11-09T14:14:44.729Z | 2024-11-09T14:16:28.552Z |
5504202 | 5504202 | 20241108011327_aHH6l | US0039 | 2024-11-09T14:14:13.451Z | 2024-11-09T14:16:28.475Z |
5504010 | 5504010 | 20241108003914_3ssYn | US0039 | 2024-11-09T14:13:58.372Z | 2024-11-09T14:16:28.426Z |
5503746 | 5503746 | 20241107234327_oAUsC | US0039 | 2024-11-09T14:13:42.318Z | 2024-11-09T14:16:28.337Z |
5498900 | 5498900 | 20241108102216_4zOjw | US0039 | 2024-11-09T14:02:44.671Z | 2024-11-09T14:02:44.671Z |
5498701 | 5498701 | 20241108093822_MJxMM | US0039 | 2024-11-09T14:02:13.553Z | 2024-11-09T14:02:13.553Z |
5498661 | 5498661 | 20241108093301_0H0ao | US0039 | 2024-11-09T14:02:07.557Z | 2024-11-09T14:02:07.557Z |
5498588 | 5498588 | 20241108091418_UGthZ | US0039 | 2024-11-09T14:01:53.114Z | 2024-11-09T14:01:53.114Z |
5498567 | 5498567 | 20241108090925_bM31H | US0039 | 2024-11-09T14:01:48.050Z | 2024-11-09T14:01:48.050Z |
5498557 | 5498557 | 20241108090641_rbnlE | US0039 | 2024-11-09T14:01:46.839Z | 2024-11-09T14:01:46.839Z |
5498512 | 5498512 | 20241108085320_UK4R4 | US0039 | 2024-11-09T14:01:40.839Z | 2024-11-09T14:01:40.839Z |
5498368 | 5498368 | 20241108082053_H2KcJ | US0039 | 2024-11-09T14:01:15.865Z | 2024-11-09T14:01:15.865Z |
5492382 | 5492382 | 20241107082046_Dvuno | US0039 | 2024-11-08T14:00:56.121Z | 2024-11-09T14:16:27.359Z |
5492329 | 5492329 | 20241107081000_f7syJ | US0039 | 2024-11-08T14:00:47.666Z | 2024-11-09T14:16:27.346Z |
5492291 | 5492291 | 20241107080107_kwJRE | US0039 | 2024-11-08T14:00:43.022Z | 2024-11-09T14:16:27.337Z |
5492236 | 5492236 | 20241107074131_0EsFL | US0039 | 2024-11-08T14:00:35.851Z | 2024-11-09T14:16:27.325Z |
5492183 | 5492183 | 20241107072154_EePoI | US0039 | 2024-11-08T14:00:24.795Z | 2024-11-09T14:16:27.305Z |
5491916 | 5491916 | 20241106061943_Co8HJ | US0039 | 2024-11-07T14:17:19.495Z | 2024-11-09T14:20:16.207Z |
5491816 | 5491816 | 20241106052052_rdiKU | US0039 | 2024-11-07T14:17:03.224Z | 2024-11-09T14:20:14.900Z |
5491807 | 5491807 | 20241106051513_3njnP | US0039 | 2024-11-07T14:17:01.633Z | 2024-11-09T14:20:14.821Z |
5491758 | 5491758 | 20241106050046_aMbf9 | US0039 | 2024-11-07T14:16:55.768Z | 2024-11-09T14:20:14.267Z |
5491730 | 5491730 | 20241106044713_gJeJE | US0039 | 2024-11-07T14:16:52.355Z | 2024-11-09T14:20:13.981Z |
5491695 | 5491695 | 20241106042946_sbj7A | US0039 | 2024-11-07T14:16:46.755Z | 2024-11-09T14:20:13.128Z |
5491641 | 5491641 | 20241106041319_wcTDy | US0039 | 2024-11-07T14:16:35.996Z | 2024-11-09T14:20:12.155Z |
5491593 | 5491593 | 20241106035842_AxJAl | US0039 | 2024-11-07T14:16:28.504Z | 2024-11-09T14:20:11.454Z |
5491541 | 5491541 | 20241106034156_OHtEK | US0039 | 2024-11-07T14:16:20.834Z | 2024-11-09T14:20:10.551Z |
5491500 | 5491500 | 20241106032831_TC2kR | US0039 | 2024-11-07T14:16:15.309Z | 2024-11-09T14:20:09.773Z |
5491498 | 5491498 | 20241106032748_vkP2t | US0039 | 2024-11-07T14:16:15.185Z | 2024-11-09T14:20:09.771Z |
5491480 | 5491480 | 20241106032349_U656d | US0039 | 2024-11-07T14:16:12.765Z | 2024-11-09T14:20:09.276Z |
5491413 | 5491413 | 20241106031347_54lGJ | US0039 | 2024-11-07T14:16:04.702Z | 2024-11-09T14:20:07.409Z |
5490697 | 5490697 | 20241106001119_5sTCf | US0039 | 2024-11-07T14:14:33.787Z | 2024-11-09T14:19:58.593Z |
5486319 | 5486319 | 20241106104250_q6Rw2 | US0039 | 2024-11-07T14:02:36.401Z | 2024-11-09T14:16:42.310Z |
5486311 | 5486311 | 20241106103851_deJON | US0039 | 2024-11-07T14:02:31.555Z | 2024-11-09T14:16:41.592Z |
5486290 | 5486290 | 20241106102750_A7owH | US0039 | 2024-11-07T14:02:26.413Z | 2024-11-09T14:16:40.784Z |
5486271 | 5486271 | 20241106102119_F396x | US0039 | 2024-11-07T14:02:23.468Z | 2024-11-09T14:16:40.592Z |
5486256 | 5486256 | 20241106101701_3womN | US0039 | 2024-11-07T14:02:21.199Z | 2024-11-09T14:16:40.386Z |
5486119 | 5486119 | 20241106094429_UXslE | US0039 | 2024-11-07T14:01:55.790Z | 2024-11-09T14:16:38.265Z |
5486087 | 5486087 | 20241106093024_3eWuy | US0039 | 2024-11-07T14:01:46.559Z | 2024-11-09T14:16:37.617Z |
5486033 | 5486033 | 20241106091530_93p2K | US0039 | 2024-11-07T14:01:36.323Z | 2024-11-09T14:16:36.353Z |
5486022 | 5486022 | 20241106091256_T2r5V | US0039 | 2024-11-07T14:01:34.207Z | 2024-11-09T14:16:36.205Z |
5485993 | 5485993 | 20241106090303_0w6ju | US0039 | 2024-11-07T14:01:25.789Z | 2024-11-09T14:16:35.784Z |
5485985 | 5485985 | 20241106090203_JW5eb | US0039 | 2024-11-07T14:01:24.497Z | 2024-11-09T14:16:35.679Z |
5485972 | 5485972 | 20241106085732_i1JHI | US0039 | 2024-11-07T14:01:19.328Z | 2024-11-09T14:16:35.465Z |
5485785 | 5485785 | 20241106072905_SWl6a | US0039 | 2024-11-07T14:00:37.185Z | 2024-11-09T14:16:32.295Z |
5485751 | 5485751 | 20241106071858_T37oA | US0039 | 2024-11-07T14:00:29.224Z | 2024-11-09T14:16:31.642Z |
5485749 | 5485749 | 20241106071846_I4o3D | US0039 | 2024-11-07T14:00:28.837Z | 2024-11-09T14:16:31.555Z |
5485554 | 5485554 | 20241105063549_mJl2D | US0039 | 2024-11-06T14:18:29.109Z | 2024-11-09T14:21:22.865Z |
5485440 | 5485440 | 20241105053948_wom1Y | US0039 | 2024-11-06T14:18:17.829Z | 2024-11-09T14:21:21.586Z |
5485429 | 5485429 | 20241105053503_Pq3Os | US0039 | 2024-11-06T14:18:15.613Z | 2024-11-09T14:21:21.539Z |
5479659 | 5479659 | 20241105101427_roWJr | US0039 | 2024-11-06T14:03:01.452Z | 2024-11-09T14:19:10.285Z |
5479584 | 5479584 | 20241105100213_2tt4d | US0039 | 2024-11-06T14:02:49.716Z | 2024-11-09T14:19:09.477Z |
5479363 | 5479363 | 20241105091248_EYgZ6 | US0039 | 2024-11-06T14:02:06.684Z | 2024-11-09T14:19:04.806Z |
5479346 | 5479346 | 20241105090723_FVpKL | US0039 | 2024-11-06T14:02:04.497Z | 2024-11-09T14:19:04.627Z |
5479327 | 5479327 | 20241105090530_7WzkN | US0039 | 2024-11-06T14:02:00.536Z | 2024-11-09T14:19:04.254Z |
5479316 | 5479316 | 20241105090448_dTxT6 | US0039 | 2024-11-06T14:01:59.266Z | 2024-11-09T14:19:04.154Z |
5478994 | 5478994 | 20241105072231_4m0Q4 | US0039 | 2024-11-06T14:00:35.523Z | 2024-11-09T14:18:57.721Z |
5478986 | 5478986 | 20241105072111_Az20Y | US0039 | 2024-11-06T14:00:33.542Z | 2024-11-09T14:18:57.593Z |
5478946 | 5478946 | 20241105070145_nknZr | US0039 | 2024-11-06T14:00:26.320Z | 2024-11-09T14:18:57.045Z |
5478843 | 5478843 | 20241104064131_8q6TN | US0039 | 2024-11-05T14:18:55.022Z | 2024-11-09T14:22:31.652Z |
5478833 | 5478833 | 20241104063434_9U7eT | US0039 | 2024-11-05T14:18:54.277Z | 2024-11-09T14:22:31.584Z |
5478823 | 5478823 | 20241104063143_Pzz5R | US0039 | 2024-11-05T14:18:53.157Z | 2024-11-09T14:22:31.521Z |
5478820 | 5478820 | 20241104062856_tcyl2 | US0039 | 2024-11-05T14:18:53.145Z | 2024-11-09T14:22:31.520Z |
5478817 | 5478817 | 20241104062001_0nLso | US0039 | 2024-11-05T14:18:53.024Z | 2024-11-09T14:22:31.519Z |
5478814 | 5478814 | 20241104061932_J6SnU | US0039 | 2024-11-05T14:18:52.974Z | 2024-11-09T14:22:31.518Z |
5478797 | 5478797 | 20241104061448_pLFT5 | US0039 | 2024-11-05T14:18:52.195Z | 2024-11-09T14:22:31.471Z |
5478790 | 5478790 | 20241104060614_XRXFd | US0039 | 2024-11-05T14:18:50.897Z | 2024-11-09T14:22:31.443Z |
5478765 | 5478765 | 20241104055033_ZfYRz | US0039 | 2024-11-05T14:18:48.175Z | 2024-11-09T14:22:31.196Z |
5478758 | 5478758 | 20241104054502_l23YU | US0039 | 2024-11-05T14:18:47.730Z | 2024-11-09T14:22:31.161Z |
5478749 | 5478749 | 20241104054136_O32mt | US0039 | 2024-11-05T14:18:47.109Z | 2024-11-09T14:22:31.115Z |
5478563 | 5478563 | 20241104043344_ln1Nq | US0039 | 2024-11-05T14:18:31.789Z | 2024-11-09T14:22:29.725Z |
5478506 | 5478506 | 20241104042026_EvFIi | US0039 | 2024-11-05T14:18:26.584Z | 2024-11-09T14:22:28.762Z |
5478489 | 5478489 | 20241104041737_8fQmB | US0039 | 2024-11-05T14:18:25.416Z | 2024-11-09T14:22:28.505Z |
5478364 | 5478364 | 20241104035547_Ur3rJ | US0039 | 2024-11-05T14:18:15.799Z | 2024-11-09T14:22:27.352Z |
5477732 | 5477732 | 20241104022741_dEER3 | US0039 | 2024-11-05T14:17:20.377Z | 2024-11-09T14:22:21.327Z |
5477254 | 5477254 | 20241104012705_lniJ4 | US0039 | 2024-11-05T14:16:37.804Z | 2024-11-09T14:22:16.167Z |
5477226 | 5477226 | 20241104012205_2JzAf | US0039 | 2024-11-05T14:16:33.135Z | 2024-11-09T14:22:15.923Z |
5477036 | 5477036 | 20241104005423_kv9lT | US0039 | 2024-11-05T14:16:18.762Z | 2024-11-09T14:22:13.932Z |
5476655 | 5476655 | 20241104000302_8q6yG | US0039 | 2024-11-05T14:15:49.006Z | 2024-11-09T14:22:11.391Z |
5476419 | 5476419 | 20241103232420_XLA2T | US0039 | 2024-11-05T14:15:19.595Z | 2024-11-09T14:22:09.315Z |
5470945 | 5470945 | 20241104101138_JbvlB | US0039 | 2024-11-05T14:02:20.860Z | 2024-11-09T14:20:26.546Z |
5470922 | 5470922 | 20241104100402_9pTRO | US0039 | 2024-11-05T14:02:17.992Z | 2024-11-09T14:20:26.334Z |
5470638 | 5470638 | 20241104091324_fHomJ | US0039 | 2024-11-05T14:01:25.650Z | 2024-11-09T14:20:22.209Z |
5470618 | 5470618 | 20241104090524_OIP1v | US0039 | 2024-11-05T14:01:17.404Z | 2024-11-09T14:20:21.948Z |
5470551 | 5470551 | 20241104084257_vaSei | US0039 | 2024-11-05T14:01:04.624Z | 2024-11-09T14:20:21.322Z |
5470523 | 5470523 | 20241104083120_2vwlg | US0039 | 2024-11-05T14:00:59.013Z | 2024-11-09T14:20:21.189Z |
5470518 | 5470518 | 20241104082722_TCO7O | US0039 | 2024-11-05T14:00:58.486Z | 2024-11-09T14:20:21.169Z |
5470470 | 5470470 | 20241104081308_B1I5v | US0039 | 2024-11-05T14:00:48.148Z | 2024-11-09T14:20:20.579Z |
5470443 | 5470443 | 20241104080541_iQC5T | US0039 | 2024-11-05T14:00:40.138Z | 2024-11-09T14:20:19.925Z |
5470430 | 5470430 | 20241104080430_gDUri | US0039 | 2024-11-05T14:00:37.955Z | 2024-11-09T14:20:19.503Z |
5470388 | 5470388 | 20241104075128_Vsanl | US0039 | 2024-11-05T14:00:28.385Z | 2024-11-09T14:20:18.994Z |
5470384 | 5470384 | 20241104074734_Uwfri | US0039 | 2024-11-05T14:00:27.586Z | 2024-11-09T14:20:18.957Z |
5470354 | 5470354 | 20241104073425_3ki4k | US0039 | 2024-11-05T14:00:21.585Z | 2024-11-09T14:20:18.722Z |
5470330 | 5470330 | 20241104071554_BVPYH | US0039 | 2024-11-05T14:00:17.212Z | 2024-11-09T14:20:18.562Z |
5470305 | 5470305 | 20241104064921_Rp3U2 | US0039 | 2024-11-05T14:00:11.024Z | 2024-11-09T14:20:18.294Z |
5470230 | 5470230 | 20241103064457_Cpbti | US0039 | 2024-11-04T14:17:55.066Z | 2024-11-09T14:23:05.973Z |
5470215 | 5470215 | 20241103063948_bdNp6 | US0039 | 2024-11-04T14:17:54.326Z | 2024-11-09T14:23:05.937Z |
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);