participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
884 rows where station_code = "HR002M" 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 |
---|---|---|---|---|---|
5092989 | 5092989 | 20240912030422_7xFAq | HR002M | 2024-09-16T12:14:09.071Z | 2024-09-19T12:21:14.798Z |
5090953 | 5090953 | 20240912015424_iKUds | HR002M | 2024-09-16T12:12:45.574Z | 2024-09-19T12:21:12.427Z |
5090572 | 5090572 | 20240912013235_GvV6F | HR002M | 2024-09-16T12:12:25.420Z | 2024-09-19T12:21:11.430Z |
5089566 | 5089566 | 20240912004917_V2DNm | HR002M | 2024-09-16T12:11:29.760Z | 2024-09-19T12:21:10.063Z |
5079087 | 5079087 | 20240911023232_sfEUP | HR002M | 2024-09-15T12:16:04.405Z | 2024-09-19T12:21:41.094Z |
5078898 | 5078898 | 20240911021940_J5hKQ | HR002M | 2024-09-15T12:15:54.973Z | 2024-09-19T12:21:40.804Z |
5078879 | 5078879 | 20240911021835_2aB8Y | HR002M | 2024-09-15T12:15:54.559Z | 2024-09-19T12:21:40.783Z |
5078026 | 5078026 | 20240911013601_rCyLY | HR002M | 2024-09-15T12:15:17.266Z | 2024-09-19T12:21:39.918Z |
5076752 | 5076752 | 20240911000704_7KYp0 | HR002M | 2024-09-15T12:13:59.923Z | 2024-09-19T12:21:37.541Z |
5076511 | 5076511 | 20240910234210_sQS2P | HR002M | 2024-09-15T12:13:39.850Z | 2024-09-19T12:21:37.313Z |
5075964 | 5075964 | 20240910230201_tLwQz | HR002M | 2024-09-15T12:13:13.417Z | 2024-09-19T12:21:36.259Z |
5075071 | 5075071 | 20240911232716_2kfr9 | HR002M | 2024-09-15T12:09:22.744Z | 2024-09-19T12:21:08.241Z |
5074880 | 5074880 | 20240911231238_W6kqq | HR002M | 2024-09-15T12:09:09.957Z | 2024-09-19T12:21:07.869Z |
5072382 | 5072382 | 20240911200129_hKzxj | HR002M | 2024-09-15T12:05:17.003Z | 2024-09-19T12:21:04.032Z |
5072089 | 5072089 | 20240911193245_sBdjV | HR002M | 2024-09-15T12:04:38.108Z | 2024-09-19T12:21:03.509Z |
5069712 | 5069712 | 20240910215955_KntfJ | HR002M | 2024-09-14T12:20:04.652Z | 2024-09-19T12:21:35.260Z |
5065208 | 5065208 | 20240910032040_j3iTe | HR002M | 2024-09-14T12:16:40.463Z | 2024-09-18T12:15:18.734Z |
5065069 | 5065069 | 20240910030049_CAgxV | HR002M | 2024-09-14T12:16:22.122Z | 2024-09-18T12:15:18.323Z |
5065057 | 5065057 | 20240910025919_NDh7N | HR002M | 2024-09-14T12:16:21.099Z | 2024-09-18T12:15:18.267Z |
5064050 | 5064050 | 20240909233850_YP6c5 | HR002M | 2024-09-14T12:14:46.414Z | 2024-09-18T12:15:15.365Z |
5060580 | 5060580 | 20240910204022_QlzM4 | HR002M | 2024-09-14T12:09:10.293Z | 2024-09-19T12:21:33.093Z |
5054605 | 5054605 | 20240908031920_GoLP1 | HR002M | 2024-09-13T12:16:48.370Z | 2024-09-16T12:21:16.248Z |
5054538 | 5054538 | 20240908030521_BMGiS | HR002M | 2024-09-13T12:16:46.173Z | 2024-09-16T12:21:15.924Z |
5054470 | 5054470 | 20240908025527_8zKac | HR002M | 2024-09-13T12:16:42.848Z | 2024-09-16T12:21:15.663Z |
5054443 | 5054443 | 20240908025158_SjUBt | HR002M | 2024-09-13T12:16:41.712Z | 2024-09-16T12:21:15.557Z |
5054245 | 5054245 | 20240908023156_pQ64r | HR002M | 2024-09-13T12:16:35.343Z | 2024-09-16T12:21:14.671Z |
5053917 | 5053917 | 20240908014853_dprjn | HR002M | 2024-09-13T12:16:22.833Z | 2024-09-16T12:21:13.162Z |
5053814 | 5053814 | 20240908013425_MKd8h | HR002M | 2024-09-13T12:16:18.032Z | 2024-09-16T12:21:12.808Z |
5053651 | 5053651 | 20240908011232_k23ta | HR002M | 2024-09-13T12:16:11.477Z | 2024-09-16T12:21:12.258Z |
5053391 | 5053391 | 20240908002724_o6o3k | HR002M | 2024-09-13T12:16:02.832Z | 2024-09-16T12:21:10.535Z |
5053297 | 5053297 | 20240908000603_qeY3J | HR002M | 2024-09-13T12:15:57.607Z | 2024-09-16T12:21:10.286Z |
5053160 | 5053160 | 20240907234052_29Yxj | HR002M | 2024-09-13T12:15:51.734Z | 2024-09-16T12:21:09.920Z |
5053056 | 5053056 | 20240907231215_iUi5c | HR002M | 2024-09-13T12:15:44.271Z | 2024-09-16T12:21:09.237Z |
5052699 | 5052699 | 20240907213924_3WAUC | HR002M | 2024-09-13T12:15:21.466Z | 2024-09-16T12:21:07.213Z |
5052653 | 5052653 | 20240907212523_N1uDF | HR002M | 2024-09-13T12:15:17.411Z | 2024-09-16T12:21:06.961Z |
5052389 | 5052389 | 20240907203124_MEfKM | HR002M | 2024-09-13T12:15:07.187Z | 2024-09-16T12:21:05.355Z |
5052125 | 5052125 | 20240907194257_czTeC | HR002M | 2024-09-13T12:14:57.538Z | 2024-09-16T12:21:03.921Z |
5051999 | 5051999 | 20240907192359_3BS2I | HR002M | 2024-09-13T12:14:52.541Z | 2024-09-16T12:21:02.857Z |
5033628 | 5033628 | 20240907032110_JY05L | HR002M | 2024-09-12T12:09:46.174Z | 2024-09-15T12:21:31.298Z |
5033539 | 5033539 | 20240907030746_gBZD2 | HR002M | 2024-09-12T12:09:38.319Z | 2024-09-15T12:21:30.432Z |
5033013 | 5033013 | 20240907021321_bZ6Ce | HR002M | 2024-09-12T12:08:43.037Z | 2024-09-15T12:21:28.778Z |
5032866 | 5032866 | 20240907015712_ktunF | HR002M | 2024-09-12T12:08:12.836Z | 2024-09-15T12:21:28.119Z |
5032574 | 5032574 | 20240907011659_Y7YKx | HR002M | 2024-09-12T12:07:41.352Z | 2024-09-15T12:21:26.814Z |
5032451 | 5032451 | 20240907010347_eaOOm | HR002M | 2024-09-12T12:07:19.442Z | 2024-09-15T12:21:26.476Z |
5031086 | 5031086 | 20240906202357_Sb4F7 | HR002M | 2024-09-12T12:03:52.939Z | 2024-09-15T12:21:21.377Z |
5026238 | 5026238 | 20240905024616_MCGSs | HR002M | 2024-09-11T12:12:07.173Z | 2024-09-13T12:19:57.232Z |
5026200 | 5026200 | 20240905023840_Zey9z | HR002M | 2024-09-11T12:12:04.244Z | 2024-09-13T12:19:57.164Z |
5026161 | 5026161 | 20240905022858_hTZcu | HR002M | 2024-09-11T12:12:00.064Z | 2024-09-13T12:19:56.986Z |
5026080 | 5026080 | 20240905021236_1dSPS | HR002M | 2024-09-11T12:11:52.867Z | 2024-09-13T12:19:56.831Z |
5020684 | 5020684 | 20240905024616_M2MgQ | HR002M | 2024-09-10T12:14:56.285Z | 2024-09-10T12:16:55.215Z |
5020650 | 5020650 | 20240905023840_6RPc6 | HR002M | 2024-09-10T12:14:54.351Z | 2024-09-10T12:16:55.205Z |
5020595 | 5020595 | 20240905022858_Lwf3L | HR002M | 2024-09-10T12:14:47.661Z | 2024-09-10T12:16:55.189Z |
5020517 | 5020517 | 20240905021236_OQZJu | HR002M | 2024-09-10T12:14:38.483Z | 2024-09-10T12:16:55.169Z |
5020254 | 5020254 | 20240905012234_3wl3s | HR002M | 2024-09-10T12:14:11.051Z | 2024-09-13T12:19:55.780Z |
5019845 | 5019845 | 20240905000336_8WlC0 | HR002M | 2024-09-10T12:13:36.923Z | 2024-09-13T12:19:54.038Z |
5019262 | 5019262 | 20240904221830_2998x | HR002M | 2024-09-10T12:12:31.565Z | 2024-09-13T12:19:51.162Z |
5018984 | 5018984 | 20240904211838_2KOkq | HR002M | 2024-09-10T12:11:52.599Z | 2024-09-13T12:19:50.005Z |
5018817 | 5018817 | 20240904203642_rySv0 | HR002M | 2024-09-10T12:11:36.125Z | 2024-09-13T12:19:49.187Z |
5018803 | 5018803 | 20240904203322_YujGb | HR002M | 2024-09-10T12:11:34.629Z | 2024-09-13T12:19:49.111Z |
5010209 | 5010209 | 20240904024306_GdGCU | HR002M | 2024-09-09T12:08:27.959Z | 2024-09-12T12:19:26.340Z |
5010117 | 5010117 | 20240904023406_GIqrq | HR002M | 2024-09-09T12:08:24.015Z | 2024-09-12T12:19:25.895Z |
5010067 | 5010067 | 20240904023037_KMGTJ | HR002M | 2024-09-09T12:08:21.327Z | 2024-09-12T12:19:25.758Z |
5009880 | 5009880 | 20240904021118_cdzI8 | HR002M | 2024-09-09T12:08:11.950Z | 2024-09-12T12:19:24.845Z |
5009467 | 5009467 | 20240904012731_2X0Oz | HR002M | 2024-09-09T12:07:45.835Z | 2024-09-12T12:19:23.059Z |
5009349 | 5009349 | 20240904011420_ddVEG | HR002M | 2024-09-09T12:07:36.043Z | 2024-09-12T12:19:22.436Z |
5008961 | 5008961 | 20240904003909_kioah | HR002M | 2024-09-09T12:07:16.600Z | 2024-09-12T12:19:20.854Z |
5008393 | 5008393 | 20240903233922_XLcJs | HR002M | 2024-09-09T12:06:41.825Z | 2024-09-12T12:19:17.436Z |
5008266 | 5008266 | 20240903232625_4X3Rk | HR002M | 2024-09-09T12:06:34.931Z | 2024-09-12T12:19:16.829Z |
5008075 | 5008075 | 20240903225957_DpkmL | HR002M | 2024-09-09T12:06:24.868Z | 2024-09-12T12:19:16.067Z |
5007956 | 5007956 | 20240903224358_ufA39 | HR002M | 2024-09-09T12:06:17.410Z | 2024-09-12T12:19:15.616Z |
5007204 | 5007204 | 20240903202157_Rs6UF | HR002M | 2024-09-09T12:05:35.415Z | 2024-09-12T12:19:12.077Z |
5000724 | 5000724 | 20240902024312_gDCK9 | HR002M | 2024-09-08T12:15:37.949Z | 2024-09-10T12:19:29.539Z |
5000369 | 5000369 | 20240902020517_4AYp3 | HR002M | 2024-09-08T12:15:21.662Z | 2024-09-10T12:19:26.823Z |
4998340 | 4998340 | 20240903024905_2zs3m | HR002M | 2024-09-08T12:07:31.003Z | 2024-09-11T12:21:12.207Z |
4997445 | 4997445 | 20240903001654_Vo2Zp | HR002M | 2024-09-08T12:06:18.424Z | 2024-09-11T12:21:04.571Z |
4996502 | 4996502 | 20240902194757_T3cqU | HR002M | 2024-09-08T12:04:52.677Z | 2024-09-11T12:20:55.124Z |
4991318 | 4991318 | 20240901021913_0k2a1 | HR002M | 2024-09-07T12:11:55.322Z | 2024-09-09T12:27:05.194Z |
4991260 | 4991260 | 20240901021355_rk7rq | HR002M | 2024-09-07T12:11:48.414Z | 2024-09-09T12:27:03.664Z |
4990802 | 4990802 | 20240901011358_4BtkX | HR002M | 2024-09-07T12:11:08.821Z | 2024-09-09T12:26:44.930Z |
4990747 | 4990747 | 20240901010402_btGi1 | HR002M | 2024-09-07T12:11:00.746Z | 2024-09-09T12:26:35.994Z |
4990679 | 4990679 | 20240901005249_b34aM | HR002M | 2024-09-07T12:10:56.229Z | 2024-09-09T12:26:28.512Z |
4990667 | 4990667 | 20240901005130_BJBDN | HR002M | 2024-09-07T12:10:53.489Z | 2024-09-09T12:26:27.138Z |
4990031 | 4990031 | 20240831231722_aA1Ht | HR002M | 2024-09-07T12:09:56.065Z | 2024-09-09T12:26:09.050Z |
4989083 | 4989083 | 20240901223711_r00sm | HR002M | 2024-09-07T12:08:29.132Z | 2024-09-10T12:19:16.626Z |
4983253 | 4983253 | 20240812004226_qddHY | HR002M | 2024-09-06T12:15:22.425Z | 2024-09-06T12:15:22.425Z |
4982880 | 4982880 | 20240812003901_kkWCf | HR002M | 2024-09-06T12:15:05.883Z | 2024-09-06T12:15:05.883Z |
4982032 | 4982032 | 20240812002923_dYLTU | HR002M | 2024-09-06T12:14:41.695Z | 2024-09-06T12:14:41.695Z |
4981791 | 4981791 | 20240812002729_COJrY | HR002M | 2024-09-06T12:14:37.851Z | 2024-09-06T12:14:37.851Z |
4981579 | 4981579 | 20240812002410_RMQ2q | HR002M | 2024-09-06T12:14:33.789Z | 2024-09-06T12:14:33.789Z |
4980801 | 4980801 | 20240812001555_tnaz7 | HR002M | 2024-09-06T12:14:17.443Z | 2024-09-06T12:14:17.443Z |
4980188 | 4980188 | 20240812000944_x7y9F | HR002M | 2024-09-06T12:13:51.489Z | 2024-09-06T12:13:51.489Z |
4979683 | 4979683 | 20240812000334_r70JT | HR002M | 2024-09-06T12:13:22.438Z | 2024-09-06T12:13:22.438Z |
4978444 | 4978444 | 20240811235055_UNxmW | HR002M | 2024-09-06T12:12:34.028Z | 2024-09-06T12:12:34.028Z |
4978289 | 4978289 | 20240811234922_gkqFU | HR002M | 2024-09-06T12:12:31.803Z | 2024-09-06T12:12:31.803Z |
4977969 | 4977969 | 20240811234636_L2FK4 | HR002M | 2024-09-06T12:12:27.211Z | 2024-09-06T12:12:27.211Z |
4977118 | 4977118 | 20240811233630_X2iQx | HR002M | 2024-09-06T12:12:04.614Z | 2024-09-06T12:12:04.614Z |
4976645 | 4976645 | 20240811233232_j08Uw | HR002M | 2024-09-06T12:11:42.202Z | 2024-09-06T12:11:42.202Z |
4976637 | 4976637 | 20240811233225_AHzIG | HR002M | 2024-09-06T12:11:41.894Z | 2024-09-06T12:11:41.894Z |
4976476 | 4976476 | 20240811233032_f1sJg | HR002M | 2024-09-06T12:11:33.206Z | 2024-09-06T12:11:33.206Z |
4976427 | 4976427 | 20240811233003_d7Q4e | HR002M | 2024-09-06T12:11:31.726Z | 2024-09-06T12:11:31.726Z |
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);