participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
154 rows where station_code = "US002J" 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 |
---|---|---|---|---|---|
5134273 | 5134273 | 20240916074517_MkswV | US002J | 2024-09-19T12:17:34.833Z | 2024-09-20T12:14:13.677Z |
5056291 | 5056291 | 20240908100708_54nig | US002J | 2024-09-13T12:17:29.599Z | 2024-09-16T12:21:24.192Z |
5055130 | 5055130 | 20240908065442_S5xpW | US002J | 2024-09-13T12:17:05.644Z | 2024-09-16T12:21:17.989Z |
5055128 | 5055128 | 20240908065358_cJWfX | US002J | 2024-09-13T12:17:05.641Z | 2024-09-16T12:21:17.985Z |
5054704 | 5054704 | 20240908034117_C6kI8 | US002J | 2024-09-13T12:16:52.498Z | 2024-09-16T12:21:16.650Z |
5049322 | 5049322 | 20240909103635_fZRrT | US002J | 2024-09-13T12:11:58.955Z | 2024-09-17T12:19:09.912Z |
5034670 | 5034670 | 20240907073922_ij0do | US002J | 2024-09-12T12:11:10.581Z | 2024-09-15T12:21:35.513Z |
5002672 | 5002672 | 20240904103053_635EA | US002J | 2024-09-09T12:00:55.174Z | 2024-09-13T12:19:41.611Z |
4884772 | 4884772 | 20240807060238_UTzGe | US002J | 2024-08-20T12:16:00.527Z | 2024-08-27T12:16:32.597Z |
4838520 | 4838520 | 20240805090028_uT52l | US002J | 2024-08-16T12:02:25.795Z | 2024-08-19T12:15:49.796Z |
4837693 | 4837693 | 20240805073615_XGxlD | US002J | 2024-08-16T12:01:14.521Z | 2024-08-19T12:15:21.164Z |
4817664 | 4817664 | 20240804071131_ymgVC | US002J | 2024-08-14T12:00:53.312Z | 2024-08-17T12:23:37.066Z |
4817590 | 4817590 | 20240804065453_Rvimu | US002J | 2024-08-14T12:00:41.771Z | 2024-08-17T12:23:34.286Z |
4817453 | 4817453 | 20240804055202_2zqID | US002J | 2024-08-14T12:00:18.314Z | 2024-08-17T12:23:19.505Z |
4807050 | 4807050 | 20240803092544_8sWNx | US002J | 2024-08-13T12:02:15.168Z | 2024-08-15T12:18:18.585Z |
4797988 | 4797988 | 20240803075240_I388n | US002J | 2024-08-12T12:02:21.385Z | 2024-08-15T12:17:30.643Z |
4797776 | 4797776 | 20240803072047_8TF5f | US002J | 2024-08-12T12:01:37.521Z | 2024-08-15T12:17:20.652Z |
4797762 | 4797762 | 20240803071835_3rTum | US002J | 2024-08-12T12:01:35.639Z | 2024-08-15T12:17:20.248Z |
4788390 | 4788390 | 20240802090929_1vbud | US002J | 2024-08-11T12:04:29.131Z | 2024-08-13T12:15:49.063Z |
4787255 | 4787255 | 20240802053851_FTquX | US002J | 2024-08-11T12:01:28.183Z | 2024-08-13T12:15:23.848Z |
4751612 | 4751612 | 20240730073714_Mws9o | US002J | 2024-08-05T12:03:40.238Z | 2024-08-08T12:19:20.829Z |
4746741 | 4746741 | 20240730062459_VzDTK | US002J | 2024-08-04T12:09:27.170Z | 2024-08-08T12:19:03.596Z |
4603779 | 4603779 | 20240710090553_DK1Nv | US002J | 2024-07-12T12:01:36.843Z | 2024-07-19T12:13:31.988Z |
4580317 | 4580317 | 20240707075849_mM1qG | US002J | 2024-07-09T12:03:19.599Z | 2024-07-15T12:12:10.789Z |
4522375 | 4522375 | 20240629070229_3XHEr | US002J | 2024-06-30T12:05:28.900Z | 2024-07-07T12:13:51.020Z |
4335300 | 4335300 | 20240509083845_Ia9U4 | US002J | 2024-05-18T12:13:31.474Z | 2024-05-19T12:15:52.668Z |
4160730 | 4160730 | 20240408103158_Ftwv1 | US002J | 2024-04-09T12:13:47.998Z | 2024-04-16T12:20:27.233Z |
4144021 | 4144021 | 20240403075648_fJUmS | US002J | 2024-04-05T12:08:42.752Z | 2024-04-11T12:23:49.163Z |
4142850 | 4142850 | 20240404024145_ch1pq | US002J | 2024-04-05T12:03:33.799Z | 2024-04-12T12:19:46.270Z |
4119918 | 4119918 | 20240328092511_4ykJ0 | US002J | 2024-03-30T12:12:53.764Z | 2024-04-05T12:18:45.671Z |
4101533 | 4101533 | 20240320075028_9zPtF | US002J | 2024-03-22T12:12:47.105Z | 2024-03-28T12:21:02.562Z |
4091340 | 4091340 | 20240319111927_UcL0T | US002J | 2024-03-21T12:00:29.877Z | 2024-03-28T12:19:22.920Z |
4088506 | 4088506 | 20240318095539_U4CJu | US002J | 2024-03-19T12:14:16.460Z | 2024-03-26T12:21:19.392Z |
4087006 | 4087006 | 20240318080853_FzZPU | US002J | 2024-03-19T12:09:33.408Z | 2024-03-26T12:21:15.313Z |
4068564 | 4068564 | 20240313074650_XLe2I | US002J | 2024-03-15T12:09:07.428Z | 2024-03-21T12:22:22.472Z |
3875004 | 3875004 | 20240120112330_pSWxj | US002J | 2024-01-23T14:11:36.704Z | 2024-01-28T14:20:31.393Z |
3868445 | 3868445 | 20240119083948_cNgN4 | US002J | 2024-01-22T14:08:42.479Z | 2024-01-27T14:20:48.242Z |
3851169 | 3851169 | 20240117071924_KbZ4I | US002J | 2024-01-20T14:10:11.846Z | 2024-01-21T14:20:26.017Z |
3850711 | 3850711 | 20240117054935_Q2UoH | US002J | 2024-01-20T14:09:06.949Z | 2024-01-21T14:20:08.513Z |
3816967 | 3816967 | 20240113102221_NQpnR | US002J | 2024-01-16T14:04:23.845Z | 2024-01-22T14:22:14.473Z |
3816709 | 3816709 | 20240113094722_YqIsE | US002J | 2024-01-16T14:03:47.340Z | 2024-01-22T14:22:10.475Z |
3751853 | 3751853 | 20240104105253_v3BPO | US002J | 2024-01-07T14:04:00.425Z | 2024-01-13T14:25:53.811Z |
3751680 | 3751680 | 20240104094935_p3gVE | US002J | 2024-01-07T14:03:34.502Z | 2024-01-13T14:25:51.968Z |
3487280 | 3487280 | 20231129090508_nby1G | US002J | 2024-01-06T00:04:48.797Z | 2024-01-06T00:04:48.797Z |
3484678 | 3484678 | 20231128110227_82m3m | US002J | 2024-01-06T00:04:47.344Z | 2024-01-06T00:04:47.344Z |
3484364 | 3484364 | 20231128070646_cnGia | US002J | 2024-01-06T00:04:47.309Z | 2024-01-06T00:04:47.309Z |
3421822 | 3421822 | 20231118071650_CHIMl | US002J | 2024-01-06T00:04:28.701Z | 2024-01-06T00:04:28.701Z |
3421743 | 3421743 | 20231118065250_mJwUL | US002J | 2024-01-06T00:04:28.692Z | 2024-01-06T00:04:28.692Z |
3408651 | 3408651 | 20231116055237_0x8Ht | US002J | 2024-01-06T00:04:24.486Z | 2024-01-06T00:04:24.486Z |
3391179 | 3391179 | 20231114053335_PPs5L | US002J | 2024-01-06T00:04:20.146Z | 2024-01-06T00:04:20.146Z |
3382569 | 3382569 | 20231113101736_o1WoH | US002J | 2024-01-06T00:04:17.949Z | 2024-01-06T00:04:17.949Z |
3381332 | 3381332 | 20231113072512_uvgNQ | US002J | 2024-01-06T00:04:17.795Z | 2024-01-06T00:04:17.795Z |
3352624 | 3352624 | 20231109090005_Gn4V2 | US002J | 2024-01-06T00:04:10.479Z | 2024-01-06T00:04:10.479Z |
3352255 | 3352255 | 20231109072947_cluv6 | US002J | 2024-01-06T00:04:10.391Z | 2024-01-06T00:04:10.391Z |
3352066 | 3352066 | 20231109063141_8eG1S | US002J | 2024-01-06T00:04:10.339Z | 2024-01-06T00:04:10.339Z |
3314596 | 3314596 | 20231105064944_iObcc | US002J | 2024-01-06T00:03:52.695Z | 2024-01-06T00:03:52.695Z |
3309864 | 3309864 | 20231104064353_B9D5L | US002J | 2024-01-06T00:03:48.636Z | 2024-01-06T00:03:48.636Z |
3299200 | 3299200 | 20231102111742_AoTMb | US002J | 2024-01-06T00:03:40.707Z | 2024-01-06T00:03:40.707Z |
3270615 | 3270615 | 20231024102856_mN3cv | US002J | 2024-01-06T00:03:25.321Z | 2024-01-06T00:03:25.321Z |
3269677 | 3269677 | 20231024072526_ZJ5JI | US002J | 2024-01-06T00:03:25.192Z | 2024-01-06T00:03:25.192Z |
3241819 | 3241819 | 20231022085914_3zNA7 | US002J | 2024-01-06T00:03:16.621Z | 2024-01-06T00:03:16.621Z |
3241741 | 3241741 | 20231022085221_p7dQE | US002J | 2024-01-06T00:03:16.598Z | 2024-01-06T00:03:16.598Z |
3241460 | 3241460 | 20231022082301_1206q | US002J | 2024-01-06T00:03:16.536Z | 2024-01-06T00:03:16.536Z |
3240520 | 3240520 | 20231022055239_9a18t | US002J | 2024-01-06T00:03:16.309Z | 2024-01-06T00:03:16.309Z |
3238444 | 3238444 | 20231022041407_iB36C | US002J | 2024-01-06T00:03:15.925Z | 2024-01-06T00:03:15.925Z |
3224721 | 3224721 | 20231021100146_QD9xV | US002J | 2024-01-06T00:03:10.391Z | 2024-01-06T00:03:10.391Z |
3216436 | 3216436 | 20231020112145_iV9Ht | US002J | 2024-01-06T00:03:05.805Z | 2024-01-06T00:03:05.805Z |
3215502 | 3215502 | 20231020092035_2smby | US002J | 2024-01-06T00:03:05.466Z | 2024-01-06T00:03:05.466Z |
3207933 | 3207933 | 20231019070056_dPbw3 | US002J | 2024-01-06T00:03:01.530Z | 2024-01-06T00:03:01.530Z |
3201828 | 3201828 | 20231018062906_UijRX | US002J | 2024-01-06T00:02:57.817Z | 2024-01-06T00:02:57.817Z |
3201781 | 3201781 | 20231018062012_L2ty1 | US002J | 2024-01-06T00:02:57.800Z | 2024-01-06T00:02:57.800Z |
3201529 | 3201529 | 20231018052045_YbRNa | US002J | 2024-01-06T00:02:57.702Z | 2024-01-06T00:02:57.702Z |
3184765 | 3184765 | 20231016103246_tr0ab | US002J | 2024-01-06T00:02:52.034Z | 2024-01-06T00:02:52.034Z |
3184174 | 3184174 | 20231016091928_5UwBG | US002J | 2024-01-06T00:02:51.969Z | 2024-01-06T00:02:51.969Z |
3123456 | 3123456 | 20231010103335_pm6CM | US002J | 2024-01-06T00:02:36.345Z | 2024-01-06T00:02:36.345Z |
3116642 | 3116642 | 20231009101001_a3r8d | US002J | 2024-01-06T00:02:34.288Z | 2024-01-06T00:02:34.288Z |
3115530 | 3115530 | 20231009060910_GIr2A | US002J | 2024-01-06T00:02:34.154Z | 2024-01-06T00:02:34.154Z |
3097060 | 3097060 | 20231006053718_zoA7k | US002J | 2024-01-06T00:02:28.271Z | 2024-01-06T00:02:28.271Z |
3017307 | 3017307 | 20230918084138_sy84U | US002J | 2024-01-06T00:01:56.472Z | 2024-01-06T00:01:56.472Z |
3017163 | 3017163 | 20230918081400_etHC7 | US002J | 2024-01-06T00:01:56.456Z | 2024-01-06T00:01:56.456Z |
3016502 | 3016502 | 20230918053451_22Sdu | US002J | 2024-01-06T00:01:56.381Z | 2024-01-06T00:01:56.381Z |
2964539 | 2964539 | 20230909065642_5kvGL | US002J | 2024-01-06T00:01:40.273Z | 2024-01-06T00:01:40.273Z |
2925043 | 2925043 | 20230904020025_AglLc | US002J | 2024-01-06T00:01:28.126Z | 2024-01-06T00:01:28.126Z |
2889564 | 2889564 | 20230824091531_I2FBY | US002J | 2024-01-06T00:01:12.108Z | 2024-01-06T00:01:12.108Z |
2889298 | 2889298 | 20230824060305_18vRa | US002J | 2024-01-06T00:01:12.066Z | 2024-01-06T00:01:12.066Z |
2877238 | 2877238 | 20230822080417_isbzK | US002J | 2024-01-06T00:01:08.170Z | 2024-01-06T00:01:08.170Z |
2678031 | 2678031 | 20230730064139_0Jwql | US002J | 2024-01-06T00:00:05.647Z | 2024-01-06T00:00:05.647Z |
2642479 | 2642479 | 20230722072913_3s09d | US002J | 2024-01-05T23:59:43.436Z | 2024-01-05T23:59:43.436Z |
2607664 | 2607664 | 20230714063721_pNnac | US002J | 2024-01-05T23:59:30.731Z | 2024-01-05T23:59:30.731Z |
2464943 | 2464943 | 20230517065433_VBgrd | US002J | 2024-01-05T23:57:47.884Z | 2024-01-05T23:57:47.884Z |
2430682 | 2430682 | 20230430074126_1vVHI | US002J | 2024-01-05T23:57:20.463Z | 2024-01-05T23:57:20.463Z |
2382461 | 2382461 | 20230414100317_6Z6Ql | US002J | 2024-01-05T23:56:52.879Z | 2024-01-05T23:56:52.879Z |
2336945 | 2336945 | 20230319094626_CMrbf | US002J | 2024-01-05T23:56:14.566Z | 2024-01-05T23:56:14.566Z |
2287595 | 2287595 | 20230219105852_dO5SU | US002J | 2024-01-05T23:55:32.552Z | 2024-01-05T23:55:32.552Z |
2017358 | 2017358 | 20221203114719_UIt89 | US002J | 2024-01-05T23:53:04.537Z | 2024-01-05T23:53:04.537Z |
2012885 | 2012885 | 20221201113554_sGp4p | US002J | 2024-01-05T23:53:01.462Z | 2024-01-05T23:53:01.462Z |
1970573 | 1970573 | 20221123094558_3GW4b | US002J | 2024-01-05T23:52:41.616Z | 2024-01-05T23:52:41.616Z |
1966451 | 1966451 | 20221122111927_X8rVJ | US002J | 2024-01-05T23:52:39.838Z | 2024-01-05T23:52:39.838Z |
1966102 | 1966102 | 20221122090241_497pl | US002J | 2024-01-05T23:52:39.775Z | 2024-01-05T23:52:39.775Z |
1954949 | 1954949 | 20221120101759_dGMLg | US002J | 2024-01-05T23:52:33.612Z | 2024-01-05T23:52:33.612Z |
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);