participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,856 rows where station_code = "HU0001" 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 |
---|---|---|---|---|---|
5090926 | 5090926 | 20240912015104_0HKzU | HU0001 | 2024-09-16T12:12:42.737Z | 2024-09-19T12:21:12.362Z |
5090784 | 5090784 | 20240912014526_x4q39 | HU0001 | 2024-09-16T12:12:35.875Z | 2024-09-19T12:21:12.075Z |
5090386 | 5090386 | 20240912012349_0lsI1 | HU0001 | 2024-09-16T12:12:17.900Z | 2024-09-19T12:21:11.280Z |
5089861 | 5089861 | 20240912010000_uAbcu | HU0001 | 2024-09-16T12:11:46.639Z | 2024-09-19T12:21:10.585Z |
5089440 | 5089440 | 20240912004129_OVlWY | HU0001 | 2024-09-16T12:11:25.301Z | 2024-09-19T12:21:09.962Z |
5089345 | 5089345 | 20240912003700_vV2Jk | HU0001 | 2024-09-16T12:11:21.137Z | 2024-09-19T12:21:09.896Z |
5086565 | 5086565 | 20240912224124_Vfdvo | HU0001 | 2024-09-16T12:05:52.711Z | 2024-09-19T12:20:31.433Z |
5074835 | 5074835 | 20240911230814_P4OYB | HU0001 | 2024-09-15T12:09:02.431Z | 2024-09-19T12:21:07.825Z |
5074313 | 5074313 | 20240911222915_5DQRM | HU0001 | 2024-09-15T12:08:22.109Z | 2024-09-19T12:21:07.046Z |
5073030 | 5073030 | 20240911205307_wx9hr | HU0001 | 2024-09-15T12:06:29.295Z | 2024-09-19T12:21:05.086Z |
5054283 | 5054283 | 20240908023616_DQ12b | HU0001 | 2024-09-13T12:16:36.043Z | 2024-09-16T12:21:14.736Z |
5054151 | 5054151 | 20240908021626_QE6jS | HU0001 | 2024-09-13T12:16:31.408Z | 2024-09-16T12:21:14.146Z |
5054044 | 5054044 | 20240908020324_LVG9P | HU0001 | 2024-09-13T12:16:27.249Z | 2024-09-16T12:21:13.814Z |
5053986 | 5053986 | 20240908015750_5KSWp | HU0001 | 2024-09-13T12:16:25.250Z | 2024-09-16T12:21:13.436Z |
5053695 | 5053695 | 20240908011754_PIkp5 | HU0001 | 2024-09-13T12:16:13.585Z | 2024-09-16T12:21:12.445Z |
5053642 | 5053642 | 20240908011120_rZrak | HU0001 | 2024-09-13T12:16:11.185Z | 2024-09-16T12:21:12.221Z |
5053274 | 5053274 | 20240908000143_li7u7 | HU0001 | 2024-09-13T12:15:56.355Z | 2024-09-16T12:21:10.181Z |
5053230 | 5053230 | 20240907235442_MKMfb | HU0001 | 2024-09-13T12:15:54.420Z | 2024-09-16T12:21:10.046Z |
5053131 | 5053131 | 20240907233132_hSglb | HU0001 | 2024-09-13T12:15:48.200Z | 2024-09-16T12:21:09.710Z |
5053070 | 5053070 | 20240907231611_z1PMp | HU0001 | 2024-09-13T12:15:44.585Z | 2024-09-16T12:21:09.355Z |
5053040 | 5053040 | 20240907230824_idKD6 | HU0001 | 2024-09-13T12:15:43.303Z | 2024-09-16T12:21:09.170Z |
5052816 | 5052816 | 20240907221145_M8EJ5 | HU0001 | 2024-09-13T12:15:29.293Z | 2024-09-16T12:21:07.976Z |
5052693 | 5052693 | 20240907213858_5G5U7 | HU0001 | 2024-09-13T12:15:19.738Z | 2024-09-16T12:21:07.111Z |
5052686 | 5052686 | 20240907213443_rK28Y | HU0001 | 2024-09-13T12:15:19.573Z | 2024-09-16T12:21:07.105Z |
5052648 | 5052648 | 20240907212338_vDGbr | HU0001 | 2024-09-13T12:15:17.296Z | 2024-09-16T12:21:06.946Z |
5052526 | 5052526 | 20240907205932_a3saj | HU0001 | 2024-09-13T12:15:12.644Z | 2024-09-16T12:21:06.122Z |
5052470 | 5052470 | 20240907204858_pYPl3 | HU0001 | 2024-09-13T12:15:10.162Z | 2024-09-16T12:21:05.746Z |
5052317 | 5052317 | 20240907201558_NOEyO | HU0001 | 2024-09-13T12:15:04.005Z | 2024-09-16T12:21:05.107Z |
5052012 | 5052012 | 20240907192718_Q2glw | HU0001 | 2024-09-13T12:14:53.463Z | 2024-09-16T12:21:03.108Z |
5051756 | 5051756 | 20240907183158_Axu26 | HU0001 | 2024-09-13T12:14:32.706Z | 2024-09-16T12:21:01.823Z |
5051663 | 5051663 | 20240907181644_psGdl | HU0001 | 2024-09-13T12:14:28.378Z | 2024-09-16T12:21:01.516Z |
5047121 | 5047121 | 20240909024421_KAFmB | HU0001 | 2024-09-13T12:08:19.109Z | 2024-09-17T12:19:01.178Z |
5039286 | 5039286 | 20240906000951_dXYne | HU0001 | 2024-09-12T12:15:24.584Z | 2024-09-14T12:23:01.219Z |
5038760 | 5038760 | 20240905214137_PVVZC | HU0001 | 2024-09-12T12:14:59.623Z | 2024-09-14T12:22:57.833Z |
5032529 | 5032529 | 20240907011216_9AkCM | HU0001 | 2024-09-12T12:07:31.424Z | 2024-09-15T12:21:26.688Z |
5031785 | 5031785 | 20240906231727_EMnzi | HU0001 | 2024-09-12T12:05:48.057Z | 2024-09-15T12:21:24.294Z |
5031524 | 5031524 | 20240906221825_U3Ddn | HU0001 | 2024-09-12T12:05:06.213Z | 2024-09-15T12:21:22.794Z |
5031468 | 5031468 | 20240906220249_tDJ9J | HU0001 | 2024-09-12T12:04:59.797Z | 2024-09-15T12:21:22.644Z |
5031387 | 5031387 | 20240906213814_qEkzw | HU0001 | 2024-09-12T12:04:40.378Z | 2024-09-15T12:21:22.162Z |
5031169 | 5031169 | 20240906204424_L3SOM | HU0001 | 2024-09-12T12:04:08.269Z | 2024-09-15T12:21:21.619Z |
5026259 | 5026259 | 20240905024928_lY1HH | HU0001 | 2024-09-11T12:12:08.618Z | 2024-09-13T12:19:57.384Z |
5026137 | 5026137 | 20240905022220_ijYuv | HU0001 | 2024-09-11T12:11:58.070Z | 2024-09-13T12:19:56.952Z |
5026085 | 5026085 | 20240905021435_bFQpK | HU0001 | 2024-09-11T12:11:53.796Z | 2024-09-13T12:19:56.848Z |
5025882 | 5025882 | 20240905013259_dwtq3 | HU0001 | 2024-09-11T12:11:22.046Z | 2024-09-13T12:19:56.059Z |
5025789 | 5025789 | 20240905011632_B30eu | HU0001 | 2024-09-11T12:11:03.100Z | 2024-09-13T12:19:55.652Z |
5025225 | 5025225 | 20240906012909_UuTuI | HU0001 | 2024-09-11T12:06:02.077Z | 2024-09-14T12:23:03.541Z |
5024908 | 5024908 | 20240906000951_AymZ2 | HU0001 | 2024-09-11T12:05:06.524Z | 2024-09-11T12:16:32.374Z |
5024335 | 5024335 | 20240905214137_fp36w | HU0001 | 2024-09-11T12:03:22.835Z | 2024-09-11T12:16:32.080Z |
5020707 | 5020707 | 20240905024928_Sjo73 | HU0001 | 2024-09-10T12:14:57.489Z | 2024-09-13T12:19:57.385Z |
5020574 | 5020574 | 20240905022220_2mpB3 | HU0001 | 2024-09-10T12:14:44.799Z | 2024-09-10T12:16:55.183Z |
5020522 | 5020522 | 20240905021435_LzkRH | HU0001 | 2024-09-10T12:14:39.264Z | 2024-09-10T12:16:55.171Z |
5020324 | 5020324 | 20240905013259_AXgTl | HU0001 | 2024-09-10T12:14:18.739Z | 2024-09-13T12:19:56.061Z |
5020214 | 5020214 | 20240905011632_LyHgc | HU0001 | 2024-09-10T12:14:07.438Z | 2024-09-10T12:16:55.100Z |
5019549 | 5019549 | 20240904230843_o6GBf | HU0001 | 2024-09-10T12:12:54.588Z | 2024-09-13T12:19:52.393Z |
5019361 | 5019361 | 20240904223752_s7Tta | HU0001 | 2024-09-10T12:12:39.960Z | 2024-09-13T12:19:51.505Z |
5019315 | 5019315 | 20240904223027_XQeRp | HU0001 | 2024-09-10T12:12:36.435Z | 2024-09-13T12:19:51.363Z |
5019181 | 5019181 | 20240904220440_YYR3f | HU0001 | 2024-09-10T12:12:17.491Z | 2024-09-13T12:19:50.868Z |
5019139 | 5019139 | 20240904215607_NgAi7 | HU0001 | 2024-09-10T12:12:11.610Z | 2024-09-13T12:19:50.656Z |
5019091 | 5019091 | 20240904214829_Fm4S6 | HU0001 | 2024-09-10T12:12:05.483Z | 2024-09-13T12:19:50.391Z |
5018975 | 5018975 | 20240904211818_t1W0H | HU0001 | 2024-09-10T12:11:52.193Z | 2024-09-13T12:19:49.985Z |
5018933 | 5018933 | 20240904211022_qkcQw | HU0001 | 2024-09-10T12:11:46.949Z | 2024-09-13T12:19:49.846Z |
5009114 | 5009114 | 20240904005530_xKmpP | HU0001 | 2024-09-09T12:07:25.910Z | 2024-09-12T12:19:21.681Z |
5008739 | 5008739 | 20240904001549_2NYUS | HU0001 | 2024-09-09T12:07:01.929Z | 2024-09-12T12:19:19.026Z |
5008388 | 5008388 | 20240903233846_KyVhW | HU0001 | 2024-09-09T12:06:41.626Z | 2024-09-12T12:19:17.369Z |
5008329 | 5008329 | 20240903233349_ApEEE | HU0001 | 2024-09-09T12:06:37.779Z | 2024-09-12T12:19:17.118Z |
5007780 | 5007780 | 20240903222021_KCl09 | HU0001 | 2024-09-09T12:06:07.407Z | 2024-09-12T12:19:14.832Z |
5007718 | 5007718 | 20240903220514_V0wHI | HU0001 | 2024-09-09T12:06:03.805Z | 2024-09-12T12:19:14.589Z |
5007213 | 5007213 | 20240903202527_fvQBU | HU0001 | 2024-09-09T12:05:36.161Z | 2024-09-12T12:19:12.114Z |
5007152 | 5007152 | 20240903200921_48TlB | HU0001 | 2024-09-09T12:05:29.057Z | 2024-09-12T12:19:11.713Z |
5007065 | 5007065 | 20240903195358_GCbpb | HU0001 | 2024-09-09T12:05:22.596Z | 2024-09-12T12:19:11.235Z |
5007021 | 5007021 | 20240903194831_oINXk | HU0001 | 2024-09-09T12:05:20.234Z | 2024-09-12T12:19:11.152Z |
5000383 | 5000383 | 20240902020621_yMobb | HU0001 | 2024-09-08T12:15:22.324Z | 2024-09-10T12:19:26.830Z |
4998360 | 4998360 | 20240903025227_I8cuN | HU0001 | 2024-09-08T12:07:32.876Z | 2024-09-11T12:21:12.358Z |
4998239 | 4998239 | 20240903023318_ggpOw | HU0001 | 2024-09-08T12:07:24.924Z | 2024-09-11T12:21:11.609Z |
4998086 | 4998086 | 20240903021220_l32qA | HU0001 | 2024-09-08T12:07:11.084Z | 2024-09-11T12:21:10.915Z |
4997856 | 4997856 | 20240903013520_s0WN2 | HU0001 | 2024-09-08T12:06:53.483Z | 2024-09-11T12:21:09.527Z |
4997747 | 4997747 | 20240903012056_P8nRI | HU0001 | 2024-09-08T12:06:46.033Z | 2024-09-11T12:21:08.131Z |
4997549 | 4997549 | 20240903003949_fA3fV | HU0001 | 2024-09-08T12:06:25.990Z | 2024-09-11T12:21:05.536Z |
4997334 | 4997334 | 20240902235558_S018q | HU0001 | 2024-09-08T12:06:05.935Z | 2024-09-11T12:21:03.441Z |
4996442 | 4996442 | 20240902194038_2espn | HU0001 | 2024-09-08T12:04:49.417Z | 2024-09-11T12:20:54.375Z |
4996264 | 4996264 | 20240902190820_hdKC0 | HU0001 | 2024-09-08T12:04:39.058Z | 2024-09-11T12:20:52.507Z |
4991231 | 4991231 | 20240901020955_vrbNy | HU0001 | 2024-09-07T12:11:46.408Z | 2024-09-09T12:27:03.069Z |
4991066 | 4991066 | 20240901015456_bI0w6 | HU0001 | 2024-09-07T12:11:32.904Z | 2024-09-09T12:26:59.325Z |
4990818 | 4990818 | 20240901011601_bokr2 | HU0001 | 2024-09-07T12:11:10.013Z | 2024-09-09T12:26:45.722Z |
4990490 | 4990490 | 20240901002213_u4VEd | HU0001 | 2024-09-07T12:10:41.343Z | 2024-09-09T12:26:21.798Z |
4990365 | 4990365 | 20240901000750_zub31 | HU0001 | 2024-09-07T12:10:27.257Z | 2024-09-09T12:26:17.813Z |
4990198 | 4990198 | 20240831234104_Y1lBG | HU0001 | 2024-09-07T12:10:09.965Z | 2024-09-09T12:26:13.125Z |
4989592 | 4989592 | 20240901235544_zdehO | HU0001 | 2024-09-07T12:09:10.143Z | 2024-09-10T12:19:18.107Z |
4989513 | 4989513 | 20240901234349_2b3AR | HU0001 | 2024-09-07T12:09:04.864Z | 2024-09-10T12:19:17.816Z |
4989247 | 4989247 | 20240901225958_S7IF8 | HU0001 | 2024-09-07T12:08:41.414Z | 2024-09-10T12:19:17.198Z |
4988955 | 4988955 | 20240901220806_cQYQR | HU0001 | 2024-09-07T12:08:15.611Z | 2024-09-10T12:19:15.960Z |
4988273 | 4988273 | 20240901202301_MXCOh | HU0001 | 2024-09-07T12:07:10.811Z | 2024-09-10T12:19:13.323Z |
4983445 | 4983445 | 20240812004431_vVByG | HU0001 | 2024-09-06T12:15:33.365Z | 2024-09-06T12:15:33.365Z |
4982210 | 4982210 | 20240812003128_huXVm | HU0001 | 2024-09-06T12:14:47.120Z | 2024-09-06T12:14:47.120Z |
4982187 | 4982187 | 20240812003113_hDDgV | HU0001 | 2024-09-06T12:14:46.639Z | 2024-09-06T12:14:46.639Z |
4981983 | 4981983 | 20240812002852_q7r5X | HU0001 | 2024-09-06T12:14:41.168Z | 2024-09-06T12:14:41.168Z |
4980870 | 4980870 | 20240812001650_N9UGe | HU0001 | 2024-09-06T12:14:22.355Z | 2024-09-06T12:14:22.355Z |
4980727 | 4980727 | 20240812001507_127Ae | HU0001 | 2024-09-06T12:14:13.820Z | 2024-09-06T12:14:13.820Z |
4980613 | 4980613 | 20240812001420_KkbRb | HU0001 | 2024-09-06T12:14:08.489Z | 2024-09-06T12:14:08.489Z |
4978981 | 4978981 | 20240811235802_a47ma | HU0001 | 2024-09-06T12:12:48.818Z | 2024-09-06T12:12:48.818Z |
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);