participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,302 rows where station_code = "GR0004" 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 |
---|---|---|---|---|---|
5132652 | 5132652 | 20240916015026_lXZcU | GR0004 | 2024-09-19T12:16:25.357Z | 2024-09-19T12:16:25.357Z |
5131984 | 5131984 | 20240915222921_I9Uy7 | GR0004 | 2024-09-19T12:15:40.470Z | 2024-09-19T12:15:40.470Z |
5128146 | 5128146 | 20240917005140_WV7uf | GR0004 | 2024-09-19T12:10:09.350Z | 2024-09-19T12:10:09.350Z |
5114879 | 5114879 | 20240915020258_9a8x1 | GR0004 | 2024-09-18T12:05:38.991Z | 2024-09-19T12:19:00.432Z |
5113697 | 5113697 | 20240915010703_k3ka7 | GR0004 | 2024-09-18T12:04:43.455Z | 2024-09-19T12:18:51.540Z |
5113694 | 5113694 | 20240915010656_D8aGb | GR0004 | 2024-09-18T12:04:42.571Z | 2024-09-19T12:18:51.529Z |
5113520 | 5113520 | 20240915005452_XFmfm | GR0004 | 2024-09-18T12:04:25.633Z | 2024-09-19T12:18:49.847Z |
5113462 | 5113462 | 20240915005129_X823G | GR0004 | 2024-09-18T12:04:20.231Z | 2024-09-19T12:18:49.428Z |
5113391 | 5113391 | 20240915004506_I5oKd | GR0004 | 2024-09-18T12:04:13.224Z | 2024-09-19T12:18:48.839Z |
5113191 | 5113191 | 20240915003033_02V7y | GR0004 | 2024-09-18T12:04:02.342Z | 2024-09-19T12:18:47.909Z |
5113084 | 5113084 | 20240915002149_iue5l | GR0004 | 2024-09-18T12:03:55.779Z | 2024-09-19T12:18:46.989Z |
5113066 | 5113066 | 20240915001746_CIjsX | GR0004 | 2024-09-18T12:03:54.169Z | 2024-09-19T12:18:46.824Z |
5112725 | 5112725 | 20240914234528_23gjv | GR0004 | 2024-09-18T12:03:25.084Z | 2024-09-19T12:18:43.671Z |
5111754 | 5111754 | 20240914211358_6iZTd | GR0004 | 2024-09-18T12:02:15.291Z | 2024-09-19T12:18:33.838Z |
5111644 | 5111644 | 20240914205743_EvTZY | GR0004 | 2024-09-18T12:02:09.184Z | 2024-09-19T12:18:32.791Z |
5100505 | 5100505 | 20240913232909_fnB22 | GR0004 | 2024-09-17T12:04:36.890Z | 2024-09-19T12:19:48.062Z |
5091688 | 5091688 | 20240912021827_CTDZ7 | GR0004 | 2024-09-16T12:13:18.593Z | 2024-09-19T12:21:13.323Z |
5090793 | 5090793 | 20240912014625_ITsY3 | GR0004 | 2024-09-16T12:12:36.819Z | 2024-09-19T12:21:12.113Z |
5090787 | 5090787 | 20240912014617_SJbWm | GR0004 | 2024-09-16T12:12:36.059Z | 2024-09-19T12:21:12.076Z |
5090729 | 5090729 | 20240912014148_rUYRy | GR0004 | 2024-09-16T12:12:31.968Z | 2024-09-19T12:21:11.705Z |
5089046 | 5089046 | 20240912002328_fEw2d | GR0004 | 2024-09-16T12:11:14.332Z | 2024-09-19T12:21:09.722Z |
5079765 | 5079765 | 20240911031003_zh73J | GR0004 | 2024-09-15T12:16:34.741Z | 2024-09-19T12:21:42.597Z |
5079601 | 5079601 | 20240911030515_Em9hv | GR0004 | 2024-09-15T12:16:27.802Z | 2024-09-19T12:21:42.469Z |
5079133 | 5079133 | 20240911023416_rV3Rg | GR0004 | 2024-09-15T12:16:05.987Z | 2024-09-19T12:21:41.157Z |
5078857 | 5078857 | 20240911021709_K695m | GR0004 | 2024-09-15T12:15:53.239Z | 2024-09-19T12:21:40.739Z |
5075661 | 5075661 | 20240912000033_ZBiyh | GR0004 | 2024-09-15T12:10:07.366Z | 2024-09-19T12:21:09.420Z |
5075554 | 5075554 | 20240911235524_jS9lD | GR0004 | 2024-09-15T12:10:01.213Z | 2024-09-19T12:21:09.298Z |
5075492 | 5075492 | 20240911235053_2JOpE | GR0004 | 2024-09-15T12:09:53.943Z | 2024-09-19T12:21:09.236Z |
5074993 | 5074993 | 20240911232005_rSzEt | GR0004 | 2024-09-15T12:09:16.798Z | 2024-09-19T12:21:07.969Z |
5074816 | 5074816 | 20240911230542_iEyea | GR0004 | 2024-09-15T12:08:56.740Z | 2024-09-19T12:21:07.758Z |
5074490 | 5074490 | 20240911224023_Q0CYo | GR0004 | 2024-09-15T12:08:33.973Z | 2024-09-19T12:21:07.351Z |
5074333 | 5074333 | 20240911223020_y8I72 | GR0004 | 2024-09-15T12:08:23.915Z | 2024-09-19T12:21:07.096Z |
5074329 | 5074329 | 20240911222953_uOMbC | GR0004 | 2024-09-15T12:08:23.405Z | 2024-09-19T12:21:07.086Z |
5074310 | 5074310 | 20240911222909_uWd7S | GR0004 | 2024-09-15T12:08:21.695Z | 2024-09-19T12:21:07.043Z |
5074116 | 5074116 | 20240911221643_tw7y1 | GR0004 | 2024-09-15T12:08:00.261Z | 2024-09-19T12:21:06.911Z |
5072985 | 5072985 | 20240911205111_YODp7 | GR0004 | 2024-09-15T12:06:24.031Z | 2024-09-19T12:21:05.053Z |
5072815 | 5072815 | 20240911204117_GhBIL | GR0004 | 2024-09-15T12:06:09.255Z | 2024-09-19T12:21:04.775Z |
5072442 | 5072442 | 20240911201006_HF34x | GR0004 | 2024-09-15T12:05:23.632Z | 2024-09-19T12:21:04.192Z |
5071742 | 5071742 | 20240911180903_vZiMl | GR0004 | 2024-09-15T12:03:23.143Z | 2024-09-19T12:21:02.572Z |
5054554 | 5054554 | 20240908030955_qsINz | GR0004 | 2024-09-13T12:16:46.867Z | 2024-09-16T12:21:16.049Z |
5054279 | 5054279 | 20240908023559_XNZJo | GR0004 | 2024-09-13T12:16:36.008Z | 2024-09-16T12:21:14.725Z |
5054002 | 5054002 | 20240908015954_VSwwh | GR0004 | 2024-09-13T12:16:26.203Z | 2024-09-16T12:21:13.733Z |
5053990 | 5053990 | 20240908015818_961WS | GR0004 | 2024-09-13T12:16:25.370Z | 2024-09-16T12:21:13.688Z |
5053970 | 5053970 | 20240908015628_2veWk | GR0004 | 2024-09-13T12:16:24.513Z | 2024-09-16T12:21:13.403Z |
5053947 | 5053947 | 20240908015325_grEz8 | GR0004 | 2024-09-13T12:16:23.821Z | 2024-09-16T12:21:13.363Z |
5053439 | 5053439 | 20240908003557_d519D | GR0004 | 2024-09-13T12:16:03.993Z | 2024-09-16T12:21:11.111Z |
5053372 | 5053372 | 20240908002154_pHvuH | GR0004 | 2024-09-13T12:16:01.932Z | 2024-09-16T12:21:10.446Z |
5052928 | 5052928 | 20240907223913_IDCrB | GR0004 | 2024-09-13T12:15:36.308Z | 2024-09-16T12:21:08.617Z |
5052835 | 5052835 | 20240907221627_n337K | GR0004 | 2024-09-13T12:15:31.409Z | 2024-09-16T12:21:08.191Z |
5052755 | 5052755 | 20240907215302_iDcY5 | GR0004 | 2024-09-13T12:15:25.351Z | 2024-09-16T12:21:07.550Z |
5052611 | 5052611 | 20240907211453_GwyV7 | GR0004 | 2024-09-13T12:15:15.638Z | 2024-09-16T12:21:06.641Z |
5052381 | 5052381 | 20240907203034_YWI02 | GR0004 | 2024-09-13T12:15:06.893Z | 2024-09-16T12:21:05.314Z |
5052274 | 5052274 | 20240907200753_KPh2H | GR0004 | 2024-09-13T12:15:02.440Z | 2024-09-16T12:21:04.848Z |
5052023 | 5052023 | 20240907192756_CigGN | GR0004 | 2024-09-13T12:14:53.870Z | 2024-09-16T12:21:03.186Z |
5051954 | 5051954 | 20240907191525_hm4YA | GR0004 | 2024-09-13T12:14:50.177Z | 2024-09-16T12:21:02.619Z |
5047018 | 5047018 | 20240909021547_w3sOs | GR0004 | 2024-09-13T12:08:08.689Z | 2024-09-17T12:19:00.794Z |
5046979 | 5046979 | 20240909020413_Zj76I | GR0004 | 2024-09-13T12:08:03.931Z | 2024-09-17T12:19:00.682Z |
5046737 | 5046737 | 20240909010647_A8N6T | GR0004 | 2024-09-13T12:07:25.180Z | 2024-09-17T12:19:00.208Z |
5046730 | 5046730 | 20240909010114_MIHCM | GR0004 | 2024-09-13T12:07:24.364Z | 2024-09-17T12:19:00.201Z |
5046724 | 5046724 | 20240909005945_KWVS8 | GR0004 | 2024-09-13T12:07:23.643Z | 2024-09-17T12:19:00.196Z |
5046512 | 5046512 | 20240908235429_ZSnm5 | GR0004 | 2024-09-13T12:06:50.207Z | 2024-09-17T12:18:59.440Z |
5046320 | 5046320 | 20240908224553_3gynx | GR0004 | 2024-09-13T12:06:24.876Z | 2024-09-17T12:18:59.075Z |
5046318 | 5046318 | 20240908224516_smY6U | GR0004 | 2024-09-13T12:06:24.376Z | 2024-09-17T12:18:59.074Z |
5046243 | 5046243 | 20240908221213_IhNfo | GR0004 | 2024-09-13T12:06:11.327Z | 2024-09-17T12:18:58.793Z |
5046234 | 5046234 | 20240908220458_swgMR | GR0004 | 2024-09-13T12:06:10.033Z | 2024-09-17T12:18:58.768Z |
5046217 | 5046217 | 20240908215612_SK1Hk | GR0004 | 2024-09-13T12:06:08.901Z | 2024-09-17T12:18:58.742Z |
5046103 | 5046103 | 20240908212123_Eb68P | GR0004 | 2024-09-13T12:05:55.269Z | 2024-09-17T12:18:58.535Z |
5045875 | 5045875 | 20240908195001_U9hWX | GR0004 | 2024-09-13T12:05:17.277Z | 2024-09-17T12:18:58.036Z |
5045870 | 5045870 | 20240908194925_SOiNR | GR0004 | 2024-09-13T12:05:16.343Z | 2024-09-17T12:18:58.031Z |
5045735 | 5045735 | 20240908183756_sX06W | GR0004 | 2024-09-13T12:04:49.304Z | 2024-09-17T12:18:57.163Z |
5045722 | 5045722 | 20240908182710_k3MiD | GR0004 | 2024-09-13T12:04:47.647Z | 2024-09-17T12:18:57.117Z |
5039997 | 5039997 | 20240906024310_LRRlO | GR0004 | 2024-09-12T12:15:54.277Z | 2024-09-14T12:23:06.573Z |
5039922 | 5039922 | 20240906022816_njZgg | GR0004 | 2024-09-12T12:15:50.975Z | 2024-09-14T12:23:05.841Z |
5039764 | 5039764 | 20240906015942_l9k9Y | GR0004 | 2024-09-12T12:15:44.677Z | 2024-09-14T12:23:04.565Z |
5039705 | 5039705 | 20240906015408_me3p4 | GR0004 | 2024-09-12T12:15:42.735Z | 2024-09-14T12:23:04.316Z |
5039385 | 5039385 | 20240906003938_eDMGu | GR0004 | 2024-09-12T12:15:28.861Z | 2024-09-14T12:23:01.784Z |
5039201 | 5039201 | 20240905234849_lBBgr | GR0004 | 2024-09-12T12:15:21.059Z | 2024-09-14T12:23:00.770Z |
5039177 | 5039177 | 20240905234543_WFcBm | GR0004 | 2024-09-12T12:15:20.316Z | 2024-09-14T12:23:00.642Z |
5039168 | 5039168 | 20240905234314_6jIz4 | GR0004 | 2024-09-12T12:15:19.740Z | 2024-09-14T12:23:00.610Z |
5039141 | 5039141 | 20240905232937_fMA5V | GR0004 | 2024-09-12T12:15:17.170Z | 2024-09-14T12:23:00.402Z |
5038828 | 5038828 | 20240905221230_Xk1Pt | GR0004 | 2024-09-12T12:15:03.688Z | 2024-09-14T12:22:58.228Z |
5038815 | 5038815 | 20240905220634_nheiv | GR0004 | 2024-09-12T12:15:02.906Z | 2024-09-14T12:22:58.204Z |
5038748 | 5038748 | 20240905213700_tJ3o6 | GR0004 | 2024-09-12T12:14:59.086Z | 2024-09-14T12:22:57.672Z |
5038638 | 5038638 | 20240905211657_FCBCk | GR0004 | 2024-09-12T12:14:52.340Z | 2024-09-14T12:22:56.908Z |
5038565 | 5038565 | 20240905205518_CkOjE | GR0004 | 2024-09-12T12:14:48.157Z | 2024-09-14T12:22:56.416Z |
5038515 | 5038515 | 20240905203609_8Le7x | GR0004 | 2024-09-12T12:14:45.218Z | 2024-09-14T12:22:56.308Z |
5038371 | 5038371 | 20240905194856_T34ER | GR0004 | 2024-09-12T12:14:36.173Z | 2024-09-14T12:22:55.829Z |
5033394 | 5033394 | 20240907025443_appHj | GR0004 | 2024-09-12T12:09:26.294Z | 2024-09-15T12:21:29.981Z |
5032826 | 5032826 | 20240907015328_kvqC6 | GR0004 | 2024-09-12T12:08:07.682Z | 2024-09-15T12:21:27.997Z |
5032818 | 5032818 | 20240907015220_m7qmj | GR0004 | 2024-09-12T12:08:06.888Z | 2024-09-15T12:21:27.989Z |
5032796 | 5032796 | 20240907014924_VLFyH | GR0004 | 2024-09-12T12:08:03.714Z | 2024-09-15T12:21:27.848Z |
5032643 | 5032643 | 20240907012505_6OZnc | GR0004 | 2024-09-12T12:07:47.706Z | 2024-09-15T12:21:27.198Z |
5032560 | 5032560 | 20240907011414_3n1PP | GR0004 | 2024-09-12T12:07:40.299Z | 2024-09-15T12:21:26.784Z |
5032128 | 5032128 | 20240907001653_bv8JT | GR0004 | 2024-09-12T12:06:35.543Z | 2024-09-15T12:21:25.301Z |
5032119 | 5032119 | 20240907001547_xX7YM | GR0004 | 2024-09-12T12:06:34.733Z | 2024-09-15T12:21:25.269Z |
5032069 | 5032069 | 20240907000554_a6M03 | GR0004 | 2024-09-12T12:06:29.119Z | 2024-09-15T12:21:25.185Z |
5031798 | 5031798 | 20240906232007_ygNZv | GR0004 | 2024-09-12T12:05:49.868Z | 2024-09-15T12:21:24.326Z |
5031379 | 5031379 | 20240906213705_qBw3u | GR0004 | 2024-09-12T12:04:39.787Z | 2024-09-15T12:21:22.148Z |
5031189 | 5031189 | 20240906204830_eqaBh | GR0004 | 2024-09-12T12:04:15.168Z | 2024-09-15T12:21:21.671Z |
5026271 | 5026271 | 20240905025130_wrWnI | GR0004 | 2024-09-11T12:12:10.463Z | 2024-09-13T12:19:57.443Z |
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);