participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,653 rows where station_code = "HR000J" 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 |
---|---|---|---|---|---|
5548176 | 5548176 | 20241116204842_OijIl | HR000J | 2024-11-18T14:08:23.864Z | 2024-11-22T14:23:10.745Z |
5548159 | 5548159 | 20241116203157_Hrhsn | HR000J | 2024-11-18T14:08:21.979Z | 2024-11-22T14:23:10.458Z |
5548066 | 5548066 | 20241116190106_SuAKf | HR000J | 2024-11-18T14:07:58.518Z | 2024-11-22T14:23:08.985Z |
5544939 | 5544939 | 20241115181422_w1FyL | HR000J | 2024-11-17T14:03:23.231Z | 2024-11-22T14:23:33.298Z |
5543900 | 5543900 | 20241115042604_stRIG | HR000J | 2024-11-16T14:07:37.811Z | 2024-11-22T14:24:02.380Z |
5543893 | 5543893 | 20241115042104_mYfI0 | HR000J | 2024-11-16T14:07:37.185Z | 2024-11-22T14:24:02.332Z |
5543884 | 5543884 | 20241115040921_YtN3r | HR000J | 2024-11-16T14:07:36.369Z | 2024-11-22T14:24:02.264Z |
5543842 | 5543842 | 20241115034950_glkzB | HR000J | 2024-11-16T14:07:23.722Z | 2024-11-22T14:24:01.902Z |
5543751 | 5543751 | 20241115031826_8IjwA | HR000J | 2024-11-16T14:07:08.409Z | 2024-11-22T14:24:01.237Z |
5543718 | 5543718 | 20241115030514_C9ITh | HR000J | 2024-11-16T14:07:04.473Z | 2024-11-22T14:24:00.923Z |
5538375 | 5538375 | 20241113032303_KVjO7 | HR000J | 2024-11-14T14:13:21.295Z | 2024-11-21T14:26:25.059Z |
5538334 | 5538334 | 20241113031459_KKnrQ | HR000J | 2024-11-14T14:13:16.558Z | 2024-11-21T14:26:23.527Z |
5538306 | 5538306 | 20241113030526_b1dUu | HR000J | 2024-11-14T14:13:12.671Z | 2024-11-21T14:26:22.997Z |
5531910 | 5531910 | 20241112041828_rAQPE | HR000J | 2024-11-13T14:16:02.007Z | 2024-11-20T14:26:15.855Z |
5531816 | 5531816 | 20241112041119_vzp39 | HR000J | 2024-11-13T14:15:56.422Z | 2024-11-20T14:26:14.687Z |
5531703 | 5531703 | 20241112040147_Ss0lv | HR000J | 2024-11-13T14:15:51.571Z | 2024-11-20T14:26:13.616Z |
5531557 | 5531557 | 20241112034815_FkntB | HR000J | 2024-11-13T14:15:44.608Z | 2024-11-20T14:26:12.340Z |
5531428 | 5531428 | 20241112033859_ND4Sb | HR000J | 2024-11-13T14:15:38.954Z | 2024-11-20T14:26:11.230Z |
5531343 | 5531343 | 20241112033241_dG82A | HR000J | 2024-11-13T14:15:35.108Z | 2024-11-20T14:26:10.428Z |
5531010 | 5531010 | 20241112030601_9aWFy | HR000J | 2024-11-13T14:15:01.061Z | 2024-11-20T14:26:05.975Z |
5531007 | 5531007 | 20241112030550_1RAf8 | HR000J | 2024-11-13T14:15:00.456Z | 2024-11-20T14:26:05.920Z |
5530634 | 5530634 | 20241112023554_bvI0v | HR000J | 2024-11-13T14:14:25.474Z | 2024-11-20T14:26:02.176Z |
5530121 | 5530121 | 20241112014648_93HMK | HR000J | 2024-11-13T14:13:57.473Z | 2024-11-20T14:25:54.626Z |
5529841 | 5529841 | 20241112010829_WUj3j | HR000J | 2024-11-13T14:13:14.601Z | 2024-11-20T14:25:49.858Z |
5529538 | 5529538 | 20241112003152_pYiL2 | HR000J | 2024-11-13T14:12:57.027Z | 2024-11-20T14:25:46.186Z |
5529291 | 5529291 | 20241111235751_lk6PA | HR000J | 2024-11-13T14:12:19.752Z | 2024-11-20T14:25:42.599Z |
5524450 | 5524450 | 20241111041540_l1XAS | HR000J | 2024-11-12T14:17:22.361Z | 2024-11-19T14:22:21.425Z |
5524417 | 5524417 | 20241111040942_5k29g | HR000J | 2024-11-12T14:17:17.038Z | 2024-11-19T14:22:21.187Z |
5524389 | 5524389 | 20241111040716_Ss3u7 | HR000J | 2024-11-12T14:17:14.695Z | 2024-11-19T14:22:20.938Z |
5524350 | 5524350 | 20241111035931_aYpxI | HR000J | 2024-11-12T14:17:05.956Z | 2024-11-19T14:22:20.460Z |
5523931 | 5523931 | 20241111025020_5lHjj | HR000J | 2024-11-12T14:16:21.185Z | 2024-11-19T14:22:15.943Z |
5523843 | 5523843 | 20241111023419_9Za9q | HR000J | 2024-11-12T14:16:16.706Z | 2024-11-19T14:22:15.520Z |
5523534 | 5523534 | 20241111014059_CdPBs | HR000J | 2024-11-12T14:15:53.895Z | 2024-11-19T14:22:13.108Z |
5523439 | 5523439 | 20241111012550_wjqhu | HR000J | 2024-11-12T14:15:37.105Z | 2024-11-19T14:22:12.147Z |
5523404 | 5523404 | 20241111011844_AbbA3 | HR000J | 2024-11-12T14:15:33.101Z | 2024-11-19T14:22:11.783Z |
5523397 | 5523397 | 20241111011705_1cpn1 | HR000J | 2024-11-12T14:15:31.729Z | 2024-11-19T14:22:11.681Z |
5523272 | 5523272 | 20241111005119_kQfGM | HR000J | 2024-11-12T14:15:12.347Z | 2024-11-19T14:22:11.029Z |
5523117 | 5523117 | 20241111000617_7360Y | HR000J | 2024-11-12T14:14:46.308Z | 2024-11-19T14:22:10.014Z |
5523093 | 5523093 | 20241110235943_OdM51 | HR000J | 2024-11-12T14:14:45.121Z | 2024-11-19T14:22:09.917Z |
5522947 | 5522947 | 20241110231534_0NifO | HR000J | 2024-11-12T14:14:32.939Z | 2024-11-19T14:22:09.101Z |
5522933 | 5522933 | 20241110230635_sWATN | HR000J | 2024-11-12T14:14:31.645Z | 2024-11-19T14:22:09.002Z |
5522924 | 5522924 | 20241110230039_nH3Mb | HR000J | 2024-11-12T14:14:30.281Z | 2024-11-19T14:22:08.925Z |
5522888 | 5522888 | 20241110224101_hInw6 | HR000J | 2024-11-12T14:14:27.083Z | 2024-11-19T14:22:08.624Z |
5517673 | 5517673 | 20241110042524_kKJhf | HR000J | 2024-11-11T14:14:43.861Z | 2024-11-18T14:26:37.772Z |
5517541 | 5517541 | 20241110040040_YWrrc | HR000J | 2024-11-11T14:14:33.741Z | 2024-11-18T14:26:37.043Z |
5517524 | 5517524 | 20241110035723_PPdhZ | HR000J | 2024-11-11T14:14:32.420Z | 2024-11-18T14:26:36.979Z |
5517409 | 5517409 | 20241110033936_Cv4JQ | HR000J | 2024-11-11T14:14:22.498Z | 2024-11-18T14:26:36.349Z |
5517323 | 5517323 | 20241110032600_5tZ9S | HR000J | 2024-11-11T14:14:14.438Z | 2024-11-18T14:26:35.955Z |
5517270 | 5517270 | 20241110031651_XVJxa | HR000J | 2024-11-11T14:14:11.456Z | 2024-11-18T14:26:35.715Z |
5517079 | 5517079 | 20241110024457_UyzPs | HR000J | 2024-11-11T14:13:51.236Z | 2024-11-18T14:26:34.646Z |
5516898 | 5516898 | 20241110021737_j6uYn | HR000J | 2024-11-11T14:13:30.331Z | 2024-11-18T14:26:33.696Z |
5516547 | 5516547 | 20241110011748_9k2LR | HR000J | 2024-11-11T14:13:07.909Z | 2024-11-18T14:26:31.872Z |
5516480 | 5516480 | 20241110010540_1mr1F | HR000J | 2024-11-11T14:13:03.763Z | 2024-11-18T14:26:31.444Z |
5516435 | 5516435 | 20241110005927_0PrCt | HR000J | 2024-11-11T14:13:01.133Z | 2024-11-18T14:26:31.225Z |
5516013 | 5516013 | 20241109233434_L8hLj | HR000J | 2024-11-11T14:11:59.407Z | 2024-11-18T14:26:28.937Z |
5515944 | 5515944 | 20241109231649_OZUJe | HR000J | 2024-11-11T14:11:49.308Z | 2024-11-18T14:26:28.604Z |
5515681 | 5515681 | 20241109222244_2mzU0 | HR000J | 2024-11-11T14:11:21.516Z | 2024-11-18T14:26:27.418Z |
5515593 | 5515593 | 20241109220553_f5ePu | HR000J | 2024-11-11T14:11:15.891Z | 2024-11-18T14:26:26.954Z |
5511086 | 5511086 | 20241109042342_8DSRT | HR000J | 2024-11-10T14:16:13.703Z | 2024-11-17T14:24:04.432Z |
5511075 | 5511075 | 20241109041937_S7YDy | HR000J | 2024-11-10T14:16:11.590Z | 2024-11-17T14:24:04.263Z |
5510851 | 5510851 | 20241109034434_AKpz5 | HR000J | 2024-11-10T14:15:46.379Z | 2024-11-17T14:24:01.799Z |
5510793 | 5510793 | 20241109033708_RUb2d | HR000J | 2024-11-10T14:15:43.259Z | 2024-11-17T14:24:01.341Z |
5510349 | 5510349 | 20241109022505_h9L3P | HR000J | 2024-11-10T14:15:04.137Z | 2024-11-17T14:23:56.430Z |
5510255 | 5510255 | 20241109020637_PxeHF | HR000J | 2024-11-10T14:14:52.098Z | 2024-11-17T14:23:54.604Z |
5510163 | 5510163 | 20241109015227_N8aqI | HR000J | 2024-11-10T14:14:41.616Z | 2024-11-17T14:23:53.655Z |
5509994 | 5509994 | 20241109012442_w3s4i | HR000J | 2024-11-10T14:14:24.892Z | 2024-11-17T14:23:51.665Z |
5509910 | 5509910 | 20241109010648_LCEkO | HR000J | 2024-11-10T14:14:13.924Z | 2024-11-17T14:23:50.558Z |
5509758 | 5509758 | 20241109002911_6Md3q | HR000J | 2024-11-10T14:13:57.279Z | 2024-11-17T14:23:48.781Z |
5509742 | 5509742 | 20241109002552_MVvX4 | HR000J | 2024-11-10T14:13:55.775Z | 2024-11-17T14:23:48.647Z |
5509716 | 5509716 | 20241109001836_15sfI | HR000J | 2024-11-10T14:13:53.489Z | 2024-11-17T14:23:48.526Z |
5509509 | 5509509 | 20241108233443_2t9uT | HR000J | 2024-11-10T14:13:29.227Z | 2024-11-17T14:23:46.301Z |
5509365 | 5509365 | 20241108225656_w2a2u | HR000J | 2024-11-10T14:13:16.064Z | 2024-11-17T14:23:43.661Z |
5509340 | 5509340 | 20241108225349_dYGRG | HR000J | 2024-11-10T14:13:13.582Z | 2024-11-17T14:23:43.237Z |
5509234 | 5509234 | 20241108223231_FtiRO | HR000J | 2024-11-10T14:12:59.990Z | 2024-11-17T14:23:41.854Z |
5509170 | 5509170 | 20241108221345_VIWAo | HR000J | 2024-11-10T14:12:47.916Z | 2024-11-17T14:23:41.186Z |
5504660 | 5504660 | 20241108023556_cM33o | HR000J | 2024-11-09T14:15:02.054Z | 2024-11-16T14:28:22.131Z |
5503823 | 5503823 | 20241107235517_8Hqrt | HR000J | 2024-11-09T14:13:46.356Z | 2024-11-16T14:28:12.803Z |
5503651 | 5503651 | 20241107231531_fjKLB | HR000J | 2024-11-09T14:13:29.243Z | 2024-11-16T14:28:10.601Z |
5502857 | 5502857 | 20241107195921_ClSrm | HR000J | 2024-11-09T14:12:08.601Z | 2024-11-16T14:27:59.953Z |
5502745 | 5502745 | 20241107194030_626mL | HR000J | 2024-11-09T14:12:01.199Z | 2024-11-16T14:27:59.206Z |
5502541 | 5502541 | 20241107190003_aO9ss | HR000J | 2024-11-09T14:11:42.262Z | 2024-11-16T14:27:57.381Z |
5497697 | 5497697 | 20241107043434_EQlvT | HR000J | 2024-11-08T14:14:13.009Z | 2024-11-15T14:25:05.603Z |
5497677 | 5497677 | 20241107042639_3QpXR | HR000J | 2024-11-08T14:14:10.177Z | 2024-11-15T14:25:05.485Z |
5497661 | 5497661 | 20241107042141_dQ3An | HR000J | 2024-11-08T14:14:09.235Z | 2024-11-15T14:25:05.355Z |
5497601 | 5497601 | 20241107041026_3IVUc | HR000J | 2024-11-08T14:14:02.218Z | 2024-11-15T14:25:04.995Z |
5497249 | 5497249 | 20241107030534_PBKgH | HR000J | 2024-11-08T14:13:26.524Z | 2024-11-15T14:25:02.299Z |
5496416 | 5496416 | 20241107002003_Pq6Zg | HR000J | 2024-11-08T14:12:08.026Z | 2024-11-15T14:24:57.542Z |
5496411 | 5496411 | 20241107001927_2geSb | HR000J | 2024-11-08T14:12:07.551Z | 2024-11-15T14:24:57.532Z |
5496288 | 5496288 | 20241106234750_ns3a7 | HR000J | 2024-11-08T14:11:54.527Z | 2024-11-15T14:24:56.504Z |
5496252 | 5496252 | 20241106234010_M6NPu | HR000J | 2024-11-08T14:11:51.674Z | 2024-11-15T14:24:56.359Z |
5496244 | 5496244 | 20241106233707_zhAxK | HR000J | 2024-11-08T14:11:50.937Z | 2024-11-15T14:24:56.334Z |
5496087 | 5496087 | 20241106225343_uoMve | HR000J | 2024-11-08T14:11:31.251Z | 2024-11-15T14:24:55.305Z |
5496069 | 5496069 | 20241106225126_TcTxG | HR000J | 2024-11-08T14:11:29.820Z | 2024-11-15T14:24:55.224Z |
5496000 | 5496000 | 20241106223355_w2cP7 | HR000J | 2024-11-08T14:11:20.525Z | 2024-11-15T14:24:54.636Z |
5495903 | 5495903 | 20241106220100_VdYYl | HR000J | 2024-11-08T14:11:05.524Z | 2024-11-15T14:24:53.842Z |
5495053 | 5495053 | 20241106182728_v6RHu | HR000J | 2024-11-08T14:09:09.761Z | 2024-11-15T14:24:45.884Z |
5494985 | 5494985 | 20241106180619_6gWay | HR000J | 2024-11-08T14:08:55.384Z | 2024-11-15T14:24:45.216Z |
5491010 | 5491010 | 20241106013505_qg0Ss | HR000J | 2024-11-07T14:15:12.229Z | 2024-11-14T14:23:23.212Z |
5490936 | 5490936 | 20241106011947_knwft | HR000J | 2024-11-07T14:15:06.095Z | 2024-11-14T14:23:22.962Z |
5490683 | 5490683 | 20241106000913_PXFB0 | HR000J | 2024-11-07T14:14:31.330Z | 2024-11-14T14:23:21.209Z |
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);