participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,316 rows where station_code = "HR001U" 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 |
---|---|---|---|---|---|
2983783 | 2983783 | 20230912213619_wSd1U | HR001U | 2024-01-06T00:01:46.603Z | 2024-01-06T00:01:46.603Z |
2983739 | 2983739 | 20230912212526_WOGi3 | HR001U | 2024-01-06T00:01:46.598Z | 2024-01-06T00:01:46.598Z |
2983651 | 2983651 | 20230912205745_qZqQ4 | HR001U | 2024-01-06T00:01:46.587Z | 2024-01-06T00:01:46.587Z |
2983546 | 2983546 | 20230912201259_yQ2sq | HR001U | 2024-01-06T00:01:46.572Z | 2024-01-06T00:01:46.572Z |
2981495 | 2981495 | 20230912024805_sIoar | HR001U | 2024-01-06T00:01:45.076Z | 2024-01-06T00:01:45.076Z |
2981442 | 2981442 | 20230912023511_TmdCN | HR001U | 2024-01-06T00:01:45.069Z | 2024-01-06T00:01:45.069Z |
2981381 | 2981381 | 20230912021739_3Wr0e | HR001U | 2024-01-06T00:01:45.060Z | 2024-01-06T00:01:45.060Z |
2981048 | 2981048 | 20230912005946_0CWSP | HR001U | 2024-01-06T00:01:45.015Z | 2024-01-06T00:01:45.015Z |
2980034 | 2980034 | 20230911201700_C9u4r | HR001U | 2024-01-06T00:01:44.877Z | 2024-01-06T00:01:44.877Z |
2979924 | 2979924 | 20230911193150_0vp9X | HR001U | 2024-01-06T00:01:44.862Z | 2024-01-06T00:01:44.862Z |
2979840 | 2979840 | 20230911182723_k7IDC | HR001U | 2024-01-06T00:01:44.850Z | 2024-01-06T00:01:44.850Z |
2977478 | 2977478 | 20230911021925_xEihv | HR001U | 2024-01-06T00:01:43.339Z | 2024-01-06T00:01:43.339Z |
2976544 | 2976544 | 20230911005738_o4Bt2 | HR001U | 2024-01-06T00:01:43.241Z | 2024-01-06T00:01:43.241Z |
2976323 | 2976323 | 20230911003845_2wgT2 | HR001U | 2024-01-06T00:01:43.218Z | 2024-01-06T00:01:43.218Z |
2975663 | 2975663 | 20230910233002_MGKie | HR001U | 2024-01-06T00:01:43.147Z | 2024-01-06T00:01:43.147Z |
2974051 | 2974051 | 20230910184031_zJK1U | HR001U | 2024-01-06T00:01:42.961Z | 2024-01-06T00:01:42.961Z |
2972691 | 2972691 | 20230910033508_Bm60d | HR001U | 2024-01-06T00:01:41.523Z | 2024-01-06T00:01:41.523Z |
2971589 | 2971589 | 20230910021810_9OC5a | HR001U | 2024-01-06T00:01:41.419Z | 2024-01-06T00:01:41.419Z |
2971292 | 2971292 | 20230910015911_vAhqI | HR001U | 2024-01-06T00:01:41.389Z | 2024-01-06T00:01:41.389Z |
2968762 | 2968762 | 20230909230409_Svu4C | HR001U | 2024-01-06T00:01:41.051Z | 2024-01-06T00:01:41.051Z |
2967125 | 2967125 | 20230909194937_Gzdm8 | HR001U | 2024-01-06T00:01:40.876Z | 2024-01-06T00:01:40.876Z |
2966934 | 2966934 | 20230909185307_PQSjY | HR001U | 2024-01-06T00:01:40.844Z | 2024-01-06T00:01:40.844Z |
2962253 | 2962253 | 20230909014424_e4pJB | HR001U | 2024-01-06T00:01:38.672Z | 2024-01-06T00:01:38.672Z |
2962255 | 2962255 | 20230909014457_pRm4d | HR001U | 2024-01-06T00:01:38.672Z | 2024-01-06T00:01:38.672Z |
2961955 | 2961955 | 20230909011824_xdzZ4 | HR001U | 2024-01-06T00:01:38.638Z | 2024-01-06T00:01:38.638Z |
2960634 | 2960634 | 20230908225902_qXzOn | HR001U | 2024-01-06T00:01:38.487Z | 2024-01-06T00:01:38.487Z |
2959252 | 2959252 | 20230908190143_j7cFe | HR001U | 2024-01-06T00:01:38.324Z | 2024-01-06T00:01:38.324Z |
2955113 | 2955113 | 20230908024207_l4hKw | HR001U | 2024-01-06T00:01:36.567Z | 2024-01-06T00:01:36.567Z |
2953605 | 2953605 | 20230908000404_S6NSw | HR001U | 2024-01-06T00:01:36.400Z | 2024-01-06T00:01:36.400Z |
2953141 | 2953141 | 20230907230209_8obh5 | HR001U | 2024-01-06T00:01:36.349Z | 2024-01-06T00:01:36.349Z |
2946231 | 2946231 | 20230907011347_v2GYr | HR001U | 2024-01-06T00:01:34.267Z | 2024-01-06T00:01:34.267Z |
2945962 | 2945962 | 20230907004308_wwX8d | HR001U | 2024-01-06T00:01:34.236Z | 2024-01-06T00:01:34.236Z |
2945097 | 2945097 | 20230906230530_IrvRa | HR001U | 2024-01-06T00:01:34.142Z | 2024-01-06T00:01:34.142Z |
2944889 | 2944889 | 20230906222439_bkW7K | HR001U | 2024-01-06T00:01:34.115Z | 2024-01-06T00:01:34.115Z |
2944773 | 2944773 | 20230906221116_rI3C6 | HR001U | 2024-01-06T00:01:34.102Z | 2024-01-06T00:01:34.102Z |
2944596 | 2944596 | 20230906214443_bXVG7 | HR001U | 2024-01-06T00:01:34.083Z | 2024-01-06T00:01:34.083Z |
2944546 | 2944546 | 20230906213720_1CBht | HR001U | 2024-01-06T00:01:34.077Z | 2024-01-06T00:01:34.077Z |
2943701 | 2943701 | 20230906191914_2cJ2o | HR001U | 2024-01-06T00:01:33.973Z | 2024-01-06T00:01:33.973Z |
2939942 | 2939942 | 20230906022222_TAEzF | HR001U | 2024-01-06T00:01:32.231Z | 2024-01-06T00:01:32.231Z |
2939680 | 2939680 | 20230906014927_wPvPy | HR001U | 2024-01-06T00:01:32.200Z | 2024-01-06T00:01:32.200Z |
2939633 | 2939633 | 20230906014311_y42mU | HR001U | 2024-01-06T00:01:32.197Z | 2024-01-06T00:01:32.197Z |
2938363 | 2938363 | 20230905231429_loWzT | HR001U | 2024-01-06T00:01:32.067Z | 2024-01-06T00:01:32.067Z |
2938098 | 2938098 | 20230905224434_uWFk2 | HR001U | 2024-01-06T00:01:32.039Z | 2024-01-06T00:01:32.039Z |
2929542 | 2929542 | 20230904230434_7ebk2 | HR001U | 2024-01-06T00:01:29.934Z | 2024-01-06T00:01:29.934Z |
2927731 | 2927731 | 20230904201238_XQI9K | HR001U | 2024-01-06T00:01:29.773Z | 2024-01-06T00:01:29.773Z |
2927530 | 2927530 | 20230904194125_Hxn2I | HR001U | 2024-01-06T00:01:29.755Z | 2024-01-06T00:01:29.755Z |
2927460 | 2927460 | 20230904190453_Wclnb | HR001U | 2024-01-06T00:01:29.746Z | 2024-01-06T00:01:29.746Z |
2921948 | 2921948 | 20230903025717_97z4u | HR001U | 2024-01-06T00:01:27.836Z | 2024-01-06T00:01:27.836Z |
2921897 | 2921897 | 20230903023516_a1boo | HR001U | 2024-01-06T00:01:27.829Z | 2024-01-06T00:01:27.829Z |
2921765 | 2921765 | 20230903014944_Szdnc | HR001U | 2024-01-06T00:01:27.812Z | 2024-01-06T00:01:27.812Z |
2921401 | 2921401 | 20230903001432_jMIyU | HR001U | 2024-01-06T00:01:26.563Z | 2024-01-06T00:01:26.563Z |
2920954 | 2920954 | 20230902222139_HwIhQ | HR001U | 2024-01-06T00:01:26.526Z | 2024-01-06T00:01:26.526Z |
2920239 | 2920239 | 20230902194837_LZ3IS | HR001U | 2024-01-06T00:01:26.468Z | 2024-01-06T00:01:26.468Z |
2920192 | 2920192 | 20230902190848_ZxJT0 | HR001U | 2024-01-06T00:01:26.461Z | 2024-01-06T00:01:26.461Z |
2919643 | 2919643 | 20230902032623_UQ22F | HR001U | 2024-01-06T00:01:26.389Z | 2024-01-06T00:01:26.389Z |
2919113 | 2919113 | 20230902004318_6SgIC | HR001U | 2024-01-06T00:01:25.015Z | 2024-01-06T00:01:25.015Z |
2919009 | 2919009 | 20230902001650_Hx3Ox | HR001U | 2024-01-06T00:01:25.004Z | 2024-01-06T00:01:25.004Z |
2918929 | 2918929 | 20230901234351_khA5F | HR001U | 2024-01-06T00:01:24.995Z | 2024-01-06T00:01:24.995Z |
2918683 | 2918683 | 20230901214002_beOMD | HR001U | 2024-01-06T00:01:24.966Z | 2024-01-06T00:01:24.966Z |
2918662 | 2918662 | 20230901211620_f5WEz | HR001U | 2024-01-06T00:01:24.963Z | 2024-01-06T00:01:24.963Z |
2918645 | 2918645 | 20230901210256_EbJVI | HR001U | 2024-01-06T00:01:24.961Z | 2024-01-06T00:01:24.961Z |
2918642 | 2918642 | 20230901210231_k9hzc | HR001U | 2024-01-06T00:01:24.960Z | 2024-01-06T00:01:24.960Z |
2918581 | 2918581 | 20230901201022_r7q9X | HR001U | 2024-01-06T00:01:24.952Z | 2024-01-06T00:01:24.952Z |
2917632 | 2917632 | 20230831215521_8TC5D | HR001U | 2024-01-06T00:01:23.597Z | 2024-01-06T00:01:23.597Z |
2917567 | 2917567 | 20230831193049_KStUA | HR001U | 2024-01-06T00:01:23.587Z | 2024-01-06T00:01:23.587Z |
2916613 | 2916613 | 20230831030033_VKPGb | HR001U | 2024-01-06T00:01:23.462Z | 2024-01-06T00:01:23.462Z |
2916490 | 2916490 | 20230831012415_KPcWG | HR001U | 2024-01-06T00:01:23.448Z | 2024-01-06T00:01:23.448Z |
2904171 | 2904171 | 20230827013542_NJoLd | HR001U | 2024-01-06T00:01:17.354Z | 2024-01-06T00:01:17.354Z |
2903296 | 2903296 | 20230827001648_mO29f | HR001U | 2024-01-06T00:01:17.283Z | 2024-01-06T00:01:17.283Z |
2903274 | 2903274 | 20230827001435_T6ub1 | HR001U | 2024-01-06T00:01:17.281Z | 2024-01-06T00:01:17.281Z |
2902716 | 2902716 | 20230826225849_lsRp6 | HR001U | 2024-01-06T00:01:17.232Z | 2024-01-06T00:01:17.232Z |
2902282 | 2902282 | 20230826213742_NA1tH | HR001U | 2024-01-06T00:01:17.190Z | 2024-01-06T00:01:17.190Z |
2901758 | 2901758 | 20230826194941_TCMvC | HR001U | 2024-01-06T00:01:17.136Z | 2024-01-06T00:01:17.136Z |
2901668 | 2901668 | 20230826185435_soazh | HR001U | 2024-01-06T00:01:15.912Z | 2024-01-06T00:01:15.912Z |
2899611 | 2899611 | 20230826015614_mz2vB | HR001U | 2024-01-06T00:01:15.683Z | 2024-01-06T00:01:15.683Z |
2898980 | 2898980 | 20230826010353_XLDUX | HR001U | 2024-01-06T00:01:15.631Z | 2024-01-06T00:01:15.631Z |
2898831 | 2898831 | 20230826004931_GgmcG | HR001U | 2024-01-06T00:01:15.618Z | 2024-01-06T00:01:15.618Z |
2898034 | 2898034 | 20230825234946_nl09D | HR001U | 2024-01-06T00:01:15.552Z | 2024-01-06T00:01:15.552Z |
2897430 | 2897430 | 20230825220647_Gdu2q | HR001U | 2024-01-06T00:01:15.495Z | 2024-01-06T00:01:15.495Z |
2897341 | 2897341 | 20230825215006_3Y4ws | HR001U | 2024-01-06T00:01:15.484Z | 2024-01-06T00:01:15.484Z |
2894903 | 2894903 | 20230825030639_0YsCf | HR001U | 2024-01-06T00:01:13.940Z | 2024-01-06T00:01:13.940Z |
2894810 | 2894810 | 20230825025109_6IL2s | HR001U | 2024-01-06T00:01:13.930Z | 2024-01-06T00:01:13.930Z |
2894804 | 2894804 | 20230825024952_6p7MZ | HR001U | 2024-01-06T00:01:13.929Z | 2024-01-06T00:01:13.929Z |
2894336 | 2894336 | 20230825015837_8efK9 | HR001U | 2024-01-06T00:01:13.887Z | 2024-01-06T00:01:13.887Z |
2893573 | 2893573 | 20230825005821_ke99G | HR001U | 2024-01-06T00:01:13.826Z | 2024-01-06T00:01:13.826Z |
2892822 | 2892822 | 20230824235601_PZZ0i | HR001U | 2024-01-06T00:01:13.765Z | 2024-01-06T00:01:13.765Z |
2891800 | 2891800 | 20230824222346_m3WFe | HR001U | 2024-01-06T00:01:13.681Z | 2024-01-06T00:01:13.681Z |
2891352 | 2891352 | 20230824213753_uUiPH | HR001U | 2024-01-06T00:01:13.646Z | 2024-01-06T00:01:13.646Z |
2887409 | 2887409 | 20230823232539_AJkwf | HR001U | 2024-01-06T00:01:11.841Z | 2024-01-06T00:01:11.841Z |
2887171 | 2887171 | 20230823225905_D7bZ5 | HR001U | 2024-01-06T00:01:11.821Z | 2024-01-06T00:01:11.821Z |
2886536 | 2886536 | 20230823211946_XfiaT | HR001U | 2024-01-06T00:01:11.760Z | 2024-01-06T00:01:11.760Z |
2884046 | 2884046 | 20230823030140_vLdrn | HR001U | 2024-01-06T00:01:10.173Z | 2024-01-06T00:01:10.173Z |
2883785 | 2883785 | 20230823024259_uTURp | HR001U | 2024-01-06T00:01:10.148Z | 2024-01-06T00:01:10.148Z |
2883192 | 2883192 | 20230823020534_whxM9 | HR001U | 2024-01-06T00:01:10.083Z | 2024-01-06T00:01:10.083Z |
2880347 | 2880347 | 20230822223718_MPFLb | HR001U | 2024-01-06T00:01:09.809Z | 2024-01-06T00:01:09.809Z |
2879295 | 2879295 | 20230822205308_K6gY3 | HR001U | 2024-01-06T00:01:09.716Z | 2024-01-06T00:01:09.716Z |
2876699 | 2876699 | 20230822030624_GrfRb | HR001U | 2024-01-06T00:01:08.095Z | 2024-01-06T00:01:08.095Z |
2876528 | 2876528 | 20230822024537_bqAHo | HR001U | 2024-01-06T00:01:08.076Z | 2024-01-06T00:01:08.076Z |
2875355 | 2875355 | 20230822010528_yR7pB | HR001U | 2024-01-06T00:01:07.952Z | 2024-01-06T00:01:07.952Z |
2875074 | 2875074 | 20230822004557_gnR1C | HR001U | 2024-01-06T00:01:07.924Z | 2024-01-06T00:01:07.924Z |
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);