participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000M" 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 |
---|---|---|---|---|---|
5491227 | 5491227 | 20241106023007_I26L4 | US000M | 2024-11-07T14:15:34.505Z | 2024-11-09T14:20:05.743Z |
5486470 | 5486470 | 20241106114823_Kr099 | US000M | 2024-11-07T14:03:06.887Z | 2024-11-09T14:16:47.468Z |
5486416 | 5486416 | 20241106112724_PMEWe | US000M | 2024-11-07T14:02:54.671Z | 2024-11-09T14:16:45.765Z |
5486395 | 5486395 | 20241106111959_3Y1ym | US000M | 2024-11-07T14:02:47.946Z | 2024-11-09T14:16:44.442Z |
5486247 | 5486247 | 20241106101357_aF2nS | US000M | 2024-11-07T14:02:19.322Z | 2024-11-09T14:16:40.204Z |
5486235 | 5486235 | 20241106100956_Q6bJF | US000M | 2024-11-07T14:02:17.088Z | 2024-11-09T14:16:40.047Z |
5485873 | 5485873 | 20241106080756_iEnlm | US000M | 2024-11-07T14:00:54.782Z | 2024-11-09T14:16:33.792Z |
5485696 | 5485696 | 20241106064607_Qq7ae | US000M | 2024-11-07T14:00:17.703Z | 2024-11-09T14:16:30.780Z |
5485679 | 5485679 | 20241106063826_FuFW2 | US000M | 2024-11-07T14:00:12.932Z | 2024-11-09T14:16:30.453Z |
5485547 | 5485547 | 20241105063211_KnTry | US000M | 2024-11-06T14:18:28.517Z | 2024-11-09T14:21:22.831Z |
5485526 | 5485526 | 20241105061754_tGP1f | US000M | 2024-11-06T14:18:24.986Z | 2024-11-09T14:21:22.595Z |
5485464 | 5485464 | 20241105054945_Mzq2g | US000M | 2024-11-06T14:18:19.978Z | 2024-11-09T14:21:21.801Z |
5485443 | 5485443 | 20241105054010_gv8pi | US000M | 2024-11-06T14:18:18.266Z | 2024-11-09T14:21:21.610Z |
5480319 | 5480319 | 20241105122141_RTKqc | US000M | 2024-11-06T14:05:14.349Z | 2024-11-09T14:19:22.561Z |
5480284 | 5480284 | 20241105121705_83TaO | US000M | 2024-11-06T14:05:08.759Z | 2024-11-09T14:19:22.062Z |
5480230 | 5480230 | 20241105120407_U7Il9 | US000M | 2024-11-06T14:05:00.287Z | 2024-11-09T14:19:20.629Z |
5480094 | 5480094 | 20241105113508_BJqpd | US000M | 2024-11-06T14:04:29.671Z | 2024-11-09T14:19:17.316Z |
5480057 | 5480057 | 20241105112753_pa6Eo | US000M | 2024-11-06T14:04:24.479Z | 2024-11-09T14:19:16.318Z |
5479980 | 5479980 | 20241105111328_72yBQ | US000M | 2024-11-06T14:04:14.956Z | 2024-11-09T14:19:14.732Z |
5479962 | 5479962 | 20241105110957_fB5YM | US000M | 2024-11-06T14:04:06.569Z | 2024-11-09T14:19:14.490Z |
5479933 | 5479933 | 20241105110159_JqrbE | US000M | 2024-11-06T14:03:57.869Z | 2024-11-09T14:19:14.136Z |
5479865 | 5479865 | 20241105105414_dpKbH | US000M | 2024-11-06T14:03:46.255Z | 2024-11-09T14:19:13.319Z |
5479858 | 5479858 | 20241105105359_6eHBi | US000M | 2024-11-06T14:03:45.777Z | 2024-11-09T14:19:13.281Z |
5479763 | 5479763 | 20241105103434_6acCo | US000M | 2024-11-06T14:03:30.791Z | 2024-11-09T14:19:11.795Z |
5479757 | 5479757 | 20241105103348_teW5S | US000M | 2024-11-06T14:03:29.815Z | 2024-11-09T14:19:11.630Z |
5479724 | 5479724 | 20241105102556_dTLSY | US000M | 2024-11-06T14:03:16.647Z | 2024-11-09T14:19:10.794Z |
5479602 | 5479602 | 20241105100359_7wLQ8 | US000M | 2024-11-06T14:02:51.967Z | 2024-11-09T14:19:09.613Z |
5479525 | 5479525 | 20241105094935_ULLun | US000M | 2024-11-06T14:02:41.033Z | 2024-11-09T14:19:08.408Z |
5479501 | 5479501 | 20241105094359_uUBTe | US000M | 2024-11-06T14:02:28.344Z | 2024-11-09T14:19:07.216Z |
5479478 | 5479478 | 20241105093732_MlENT | US000M | 2024-11-06T14:02:23.110Z | 2024-11-09T14:19:06.708Z |
5479457 | 5479457 | 20241105093333_1SZFe | US000M | 2024-11-06T14:02:20.286Z | 2024-11-09T14:19:06.386Z |
5479382 | 5479382 | 20241105091506_ikF9a | US000M | 2024-11-06T14:02:09.458Z | 2024-11-09T14:19:05.344Z |
5479339 | 5479339 | 20241105090638_u6vLF | US000M | 2024-11-06T14:02:03.735Z | 2024-11-09T14:19:04.598Z |
5479264 | 5479264 | 20241105084827_EbGf7 | US000M | 2024-11-06T14:01:40.007Z | 2024-11-09T14:19:02.967Z |
5479251 | 5479251 | 20241105084646_0FvK2 | US000M | 2024-11-06T14:01:36.479Z | 2024-11-09T14:19:02.440Z |
5479238 | 5479238 | 20241105083846_6sH9o | US000M | 2024-11-06T14:01:35.287Z | 2024-11-09T14:19:02.262Z |
5479223 | 5479223 | 20241105083409_MHEIj | US000M | 2024-11-06T14:01:32.588Z | 2024-11-09T14:19:01.994Z |
5479167 | 5479167 | 20241105081926_PKEGB | US000M | 2024-11-06T14:01:16.863Z | 2024-11-09T14:19:00.565Z |
5479141 | 5479141 | 20241105081631_fbcyU | US000M | 2024-11-06T14:01:13.351Z | 2024-11-09T14:19:00.119Z |
5478950 | 5478950 | 20241105070158_VSSc2 | US000M | 2024-11-06T14:00:26.751Z | 2024-11-09T14:18:57.064Z |
5478912 | 5478912 | 20241105065230_nin5a | US000M | 2024-11-06T14:00:19.967Z | 2024-11-09T14:18:56.784Z |
5469576 | 5469576 | 20241103034647_TSGr3 | US000M | 2024-11-04T14:16:37.164Z | 2024-11-09T14:23:03.105Z |
5469445 | 5469445 | 20241103032818_T8lBQ | US000M | 2024-11-04T14:16:28.526Z | 2024-11-09T14:23:02.594Z |
5468622 | 5468622 | 20241103010908_q3YAT | US000M | 2024-11-04T14:14:36.710Z | 2024-11-09T14:22:59.006Z |
5465520 | 5465520 | 20241102073319_kHz6L | US000M | 2024-11-04T14:04:14.229Z | 2024-11-09T14:22:35.113Z |
5465509 | 5465509 | 20241103123148_otlt4 | US000M | 2024-11-04T14:03:51.092Z | 2024-11-09T14:21:34.467Z |
5465507 | 5465507 | 20241103122320_3CfXt | US000M | 2024-11-04T14:03:50.666Z | 2024-11-09T14:21:34.000Z |
5464040 | 5464040 | 20241102064334_qRDSn | US000M | 2024-11-03T14:19:30.864Z | 2024-11-09T14:23:45.405Z |
5464038 | 5464038 | 20241102064057_U2UHa | US000M | 2024-11-03T14:19:30.619Z | 2024-11-09T14:23:45.402Z |
5464018 | 5464018 | 20241102063428_MREPP | US000M | 2024-11-03T14:19:29.449Z | 2024-11-09T14:23:45.306Z |
5463969 | 5463969 | 20241102062158_YJzpO | US000M | 2024-11-03T14:19:27.138Z | 2024-11-09T14:23:45.032Z |
5463962 | 5463962 | 20241102062120_9S0NX | US000M | 2024-11-03T14:19:27.035Z | 2024-11-09T14:23:45.007Z |
5463866 | 5463866 | 20241102055432_QZmV2 | US000M | 2024-11-03T14:19:21.427Z | 2024-11-09T14:23:44.313Z |
5463850 | 5463850 | 20241102054249_UEPED | US000M | 2024-11-03T14:19:20.509Z | 2024-11-09T14:23:44.163Z |
5463836 | 5463836 | 20241102053428_h2K3J | US000M | 2024-11-03T14:19:19.329Z | 2024-11-09T14:23:44.128Z |
5463831 | 5463831 | 20241102052900_p8nZK | US000M | 2024-11-03T14:19:19.138Z | 2024-11-09T14:23:44.112Z |
5463762 | 5463762 | 20241102045756_0Poa7 | US000M | 2024-11-03T14:19:15.191Z | 2024-11-09T14:23:43.785Z |
5460002 | 5460002 | 20241101122847_dircv | US000M | 2024-11-03T14:13:04.892Z | 2024-11-09T14:23:21.953Z |
5459687 | 5459687 | 20241101113726_Q6G8y | US000M | 2024-11-03T14:12:28.112Z | 2024-11-09T14:23:20.194Z |
5459596 | 5459596 | 20241101112156_YrA6S | US000M | 2024-11-03T14:12:21.038Z | 2024-11-09T14:23:19.957Z |
5459591 | 5459591 | 20241101112135_LJQBc | US000M | 2024-11-03T14:12:20.746Z | 2024-11-09T14:23:19.933Z |
5459503 | 5459503 | 20241101110912_YCAtC | US000M | 2024-11-03T14:12:02.561Z | 2024-11-09T14:23:18.588Z |
5459445 | 5459445 | 20241101110121_oaR5j | US000M | 2024-11-03T14:11:56.007Z | 2024-11-09T14:23:18.000Z |
5459303 | 5459303 | 20241101104011_8L77t | US000M | 2024-11-03T14:11:38.758Z | 2024-11-09T14:23:17.346Z |
5459249 | 5459249 | 20241101103032_AswXv | US000M | 2024-11-03T14:11:33.823Z | 2024-11-09T14:23:17.123Z |
5459208 | 5459208 | 20241101102331_zps8t | US000M | 2024-11-03T14:11:29.918Z | 2024-11-09T14:23:16.948Z |
5459165 | 5459165 | 20241101101904_6KQK7 | US000M | 2024-11-03T14:11:26.271Z | 2024-11-09T14:23:16.848Z |
5459120 | 5459120 | 20241101101059_vaFr3 | US000M | 2024-11-03T14:11:21.464Z | 2024-11-09T14:23:16.480Z |
5459004 | 5459004 | 20241101095704_bNb1C | US000M | 2024-11-03T14:10:57.706Z | 2024-11-09T14:23:15.648Z |
5458985 | 5458985 | 20241101095259_mWroP | US000M | 2024-11-03T14:10:54.747Z | 2024-11-09T14:23:15.604Z |
5458914 | 5458914 | 20241101094121_OsZF2 | US000M | 2024-11-03T14:10:48.696Z | 2024-11-09T14:23:15.087Z |
5458788 | 5458788 | 20241101091856_ou8s2 | US000M | 2024-11-03T14:10:37.247Z | 2024-11-09T14:23:14.484Z |
5458738 | 5458738 | 20241101090813_rStqO | US000M | 2024-11-03T14:10:32.601Z | 2024-11-09T14:23:14.087Z |
5458706 | 5458706 | 20241101090506_LW13c | US000M | 2024-11-03T14:10:29.444Z | 2024-11-09T14:23:13.842Z |
5458653 | 5458653 | 20241101085726_UVeN4 | US000M | 2024-11-03T14:10:16.654Z | 2024-11-09T14:23:13.377Z |
5458629 | 5458629 | 20241101085046_sTLso | US000M | 2024-11-03T14:10:10.977Z | 2024-11-09T14:23:13.274Z |
5458624 | 5458624 | 20241101085000_lBdo3 | US000M | 2024-11-03T14:10:09.078Z | 2024-11-09T14:23:13.263Z |
5458406 | 5458406 | 20241101082349_7lbq2 | US000M | 2024-11-03T14:09:43.622Z | 2024-11-09T14:23:11.946Z |
5458350 | 5458350 | 20241101081448_4Fl78 | US000M | 2024-11-03T14:09:37.993Z | 2024-11-09T14:23:11.606Z |
5458338 | 5458338 | 20241101081146_VGQgP | US000M | 2024-11-03T14:09:36.700Z | 2024-11-09T14:23:11.552Z |
5458275 | 5458275 | 20241101075914_cDV5x | US000M | 2024-11-03T14:09:26.147Z | 2024-11-09T14:23:11.231Z |
5456845 | 5456845 | 20241102123808_J1wNa | US000M | 2024-11-03T14:05:48.652Z | 2024-11-09T14:22:45.833Z |
5456807 | 5456807 | 20241102122935_K8lg8 | US000M | 2024-11-03T14:05:43.613Z | 2024-11-09T14:22:45.669Z |
5456781 | 5456781 | 20241102122229_A529F | US000M | 2024-11-03T14:05:40.390Z | 2024-11-09T14:22:45.594Z |
5456770 | 5456770 | 20241102121953_d1ru4 | US000M | 2024-11-03T14:05:39.458Z | 2024-11-09T14:22:45.583Z |
5456614 | 5456614 | 20241102115111_GvDAL | US000M | 2024-11-03T14:05:07.139Z | 2024-11-09T14:22:44.697Z |
5456512 | 5456512 | 20241102113645_J3iTi | US000M | 2024-11-03T14:04:53.204Z | 2024-11-09T14:22:44.278Z |
5456495 | 5456495 | 20241102113407_ZXw6W | US000M | 2024-11-03T14:04:50.599Z | 2024-11-09T14:22:44.120Z |
5456396 | 5456396 | 20241102111251_62pwx | US000M | 2024-11-03T14:04:23.862Z | 2024-11-09T14:22:43.630Z |
5456225 | 5456225 | 20241102104432_K8RXI | US000M | 2024-11-03T14:03:50.661Z | 2024-11-09T14:22:42.489Z |
5456166 | 5456166 | 20241102103409_o5SQ7 | US000M | 2024-11-03T14:03:37.499Z | 2024-11-09T14:22:42.241Z |
5456110 | 5456110 | 20241102102234_Z0jHi | US000M | 2024-11-03T14:03:21.863Z | 2024-11-09T14:22:41.970Z |
5456104 | 5456104 | 20241102102133_IjelU | US000M | 2024-11-03T14:03:21.529Z | 2024-11-09T14:22:41.950Z |
5456098 | 5456098 | 20241102102122_CNs2j | US000M | 2024-11-03T14:03:20.245Z | 2024-11-09T14:22:41.901Z |
5456081 | 5456081 | 20241102101851_9oE3k | US000M | 2024-11-03T14:03:17.622Z | 2024-11-09T14:22:41.786Z |
5456048 | 5456048 | 20241102101106_qI5v3 | US000M | 2024-11-03T14:03:11.592Z | 2024-11-09T14:22:41.525Z |
5455906 | 5455906 | 20241102094519_sCqVC | US000M | 2024-11-03T14:02:40.141Z | 2024-11-09T14:22:40.741Z |
5455781 | 5455781 | 20241102091537_tLXMo | US000M | 2024-11-03T14:02:17.797Z | 2024-11-09T14:22:39.413Z |
5455679 | 5455679 | 20241102085528_XEkBl | US000M | 2024-11-03T14:01:53.162Z | 2024-11-09T14:22:37.921Z |
5455657 | 5455657 | 20241102085201_Jepnx | US000M | 2024-11-03T14:01:48.337Z | 2024-11-09T14:22:37.710Z |
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);