participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000E" 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 |
---|---|---|---|---|---|
5524855 | 5524855 | 20241111060248_FFT9R | US000E | 2024-11-12T14:18:03.636Z | 2024-11-12T14:18:08.803Z |
5524796 | 5524796 | 20241111054614_09LyR | US000E | 2024-11-12T14:18:01.807Z | 2024-11-12T14:18:08.784Z |
5524732 | 5524732 | 20241111052401_3bQg0 | US000E | 2024-11-12T14:17:58.500Z | 2024-11-12T14:18:08.754Z |
5524667 | 5524667 | 20241111050444_vNmha | US000E | 2024-11-12T14:17:52.702Z | 2024-11-12T14:18:08.729Z |
5524623 | 5524623 | 20241111044725_vI2zd | US000E | 2024-11-12T14:17:46.871Z | 2024-11-12T14:18:08.707Z |
5524018 | 5524018 | 20241111030219_qt2pQ | US000E | 2024-11-12T14:16:27.952Z | 2024-11-12T14:18:08.436Z |
5523989 | 5523989 | 20241111030013_Lx7xn | US000E | 2024-11-12T14:16:24.438Z | 2024-11-12T14:18:08.423Z |
5523979 | 5523979 | 20241111025819_QROaH | US000E | 2024-11-12T14:16:23.620Z | 2024-11-12T14:18:08.419Z |
5523403 | 5523403 | 20241111011806_4cKS7 | US000E | 2024-11-12T14:15:32.360Z | 2024-11-12T14:18:08.179Z |
5519679 | 5519679 | 20241111122734_1Cw9f | US000E | 2024-11-12T14:04:44.729Z | 2024-11-12T14:04:44.729Z |
5519579 | 5519579 | 20241111120419_u266d | US000E | 2024-11-12T14:04:32.615Z | 2024-11-12T14:04:32.615Z |
5519502 | 5519502 | 20241111114006_6Agcd | US000E | 2024-11-12T14:04:17.764Z | 2024-11-12T14:04:17.764Z |
5519120 | 5519120 | 20241111101859_23BAQ | US000E | 2024-11-12T14:03:07.651Z | 2024-11-12T14:03:07.651Z |
5519116 | 5519116 | 20241111101828_k1ga2 | US000E | 2024-11-12T14:03:07.205Z | 2024-11-12T14:03:07.205Z |
5519072 | 5519072 | 20241111100928_bZ2eV | US000E | 2024-11-12T14:02:59.834Z | 2024-11-12T14:02:59.834Z |
5519066 | 5519066 | 20241111100733_botyX | US000E | 2024-11-12T14:02:58.951Z | 2024-11-12T14:02:58.951Z |
5518850 | 5518850 | 20241111092148_xeZne | US000E | 2024-11-12T14:02:13.136Z | 2024-11-12T14:02:13.136Z |
5518841 | 5518841 | 20241111091858_1rShv | US000E | 2024-11-12T14:02:11.995Z | 2024-11-12T14:02:11.995Z |
5518823 | 5518823 | 20241111091743_7CTIt | US000E | 2024-11-12T14:02:10.249Z | 2024-11-12T14:02:10.249Z |
5518749 | 5518749 | 20241111090212_OBu8z | US000E | 2024-11-12T14:01:49.942Z | 2024-11-12T14:01:49.942Z |
5518647 | 5518647 | 20241111084406_AGBpP | US000E | 2024-11-12T14:01:35.083Z | 2024-11-12T14:01:35.083Z |
5518537 | 5518537 | 20241111081219_viL52 | US000E | 2024-11-12T14:01:14.438Z | 2024-11-12T14:01:14.438Z |
5518529 | 5518529 | 20241111081125_QXNfW | US000E | 2024-11-12T14:01:13.213Z | 2024-11-12T14:01:13.213Z |
5518491 | 5518491 | 20241111080530_bplSv | US000E | 2024-11-12T14:01:05.594Z | 2024-11-12T14:01:05.594Z |
5518477 | 5518477 | 20241111080200_jvker | US000E | 2024-11-12T14:01:04.524Z | 2024-11-12T14:01:04.524Z |
5518446 | 5518446 | 20241111075446_5EyLM | US000E | 2024-11-12T14:00:58.666Z | 2024-11-12T14:00:58.666Z |
5518412 | 5518412 | 20241111073430_Z4lxS | US000E | 2024-11-12T14:00:52.470Z | 2024-11-12T14:00:52.470Z |
5518390 | 5518390 | 20241111072418_xhxDP | US000E | 2024-11-12T14:00:49.132Z | 2024-11-12T14:00:49.132Z |
5518355 | 5518355 | 20241111071427_Yc0mS | US000E | 2024-11-12T14:00:42.142Z | 2024-11-12T14:00:42.142Z |
5518340 | 5518340 | 20241111071052_u7qME | US000E | 2024-11-12T14:00:39.754Z | 2024-11-12T14:00:39.754Z |
5518332 | 5518332 | 20241111071022_qFTpM | US000E | 2024-11-12T14:00:37.184Z | 2024-11-12T14:00:37.184Z |
5518296 | 5518296 | 20241111065900_gMvpN | US000E | 2024-11-12T14:00:29.479Z | 2024-11-12T14:00:29.479Z |
5518240 | 5518240 | 20241111063007_3B2iG | US000E | 2024-11-12T14:00:20.163Z | 2024-11-12T14:00:20.163Z |
5518123 | 5518123 | 20241110060444_DWf43 | US000E | 2024-11-11T14:15:14.589Z | 2024-11-12T14:22:02.476Z |
5518101 | 5518101 | 20241110060028_ZOgtL | US000E | 2024-11-11T14:15:13.151Z | 2024-11-12T14:22:02.035Z |
5518084 | 5518084 | 20241110055420_8e8x1 | US000E | 2024-11-11T14:15:11.969Z | 2024-11-12T14:22:01.744Z |
5518032 | 5518032 | 20241110054343_XPNOz | US000E | 2024-11-11T14:15:09.486Z | 2024-11-12T14:22:00.756Z |
5517979 | 5517979 | 20241110053007_jPu6a | US000E | 2024-11-11T14:15:06.101Z | 2024-11-12T14:21:59.842Z |
5517963 | 5517963 | 20241110052446_R5UI3 | US000E | 2024-11-11T14:15:05.317Z | 2024-11-12T14:21:59.653Z |
5517839 | 5517839 | 20241110050037_Fo3za | US000E | 2024-11-11T14:14:55.891Z | 2024-11-12T14:21:56.290Z |
5517741 | 5517741 | 20241110044036_HCjQz | US000E | 2024-11-11T14:14:48.970Z | 2024-11-12T14:21:53.837Z |
5517737 | 5517737 | 20241110043942_EFMNp | US000E | 2024-11-11T14:14:48.571Z | 2024-11-12T14:21:53.773Z |
5517679 | 5517679 | 20241110042712_jthDq | US000E | 2024-11-11T14:14:44.189Z | 2024-11-12T14:21:51.622Z |
5517660 | 5517660 | 20241110042252_ICWfs | US000E | 2024-11-11T14:14:42.803Z | 2024-11-12T14:21:50.766Z |
5517641 | 5517641 | 20241110041753_R2Iq5 | US000E | 2024-11-11T14:14:41.642Z | 2024-11-12T14:21:50.175Z |
5517496 | 5517496 | 20241110035424_UuVXL | US000E | 2024-11-11T14:14:30.220Z | 2024-11-12T14:21:44.041Z |
5517459 | 5517459 | 20241110034621_3KLgv | US000E | 2024-11-11T14:14:26.440Z | 2024-11-12T14:21:42.550Z |
5517437 | 5517437 | 20241110034352_YWNcY | US000E | 2024-11-11T14:14:24.239Z | 2024-11-12T14:21:41.664Z |
5517412 | 5517412 | 20241110033955_RRezU | US000E | 2024-11-11T14:14:22.696Z | 2024-11-12T14:21:41.072Z |
5517398 | 5517398 | 20241110033844_u3YkZ | US000E | 2024-11-11T14:14:21.687Z | 2024-11-12T14:21:40.532Z |
5517200 | 5517200 | 20241110030139_Ou4LJ | US000E | 2024-11-11T14:14:03.881Z | 2024-11-12T14:21:34.684Z |
5516960 | 5516960 | 20241110022657_H5E4U | US000E | 2024-11-11T14:13:38.040Z | 2024-11-12T14:21:25.311Z |
5516933 | 5516933 | 20241110022256_AzQG0 | US000E | 2024-11-11T14:13:33.723Z | 2024-11-12T14:21:24.536Z |
5516789 | 5516789 | 20241110020258_yf2tA | US000E | 2024-11-11T14:13:21.753Z | 2024-11-12T14:21:20.003Z |
5516735 | 5516735 | 20241110015121_izPZE | US000E | 2024-11-11T14:13:17.499Z | 2024-11-12T14:21:17.622Z |
5516635 | 5516635 | 20241110013145_zrvHg | US000E | 2024-11-11T14:13:12.458Z | 2024-11-12T14:21:14.646Z |
5513813 | 5513813 | 20241110122314_axUuM | US000E | 2024-11-11T14:05:30.118Z | 2024-11-12T14:18:06.654Z |
5513805 | 5513805 | 20241110122312_w2hzw | US000E | 2024-11-11T14:05:29.628Z | 2024-11-12T14:18:06.652Z |
5513741 | 5513741 | 20241110121641_OV9pO | US000E | 2024-11-11T14:05:24.610Z | 2024-11-12T14:18:06.628Z |
5513663 | 5513663 | 20241110120138_vTC8t | US000E | 2024-11-11T14:05:07.742Z | 2024-11-12T14:18:06.594Z |
5513621 | 5513621 | 20241110115742_nWmwV | US000E | 2024-11-11T14:04:59.829Z | 2024-11-12T14:18:06.577Z |
5513556 | 5513556 | 20241110114818_CHLHX | US000E | 2024-11-11T14:04:48.369Z | 2024-11-12T14:18:06.545Z |
5513489 | 5513489 | 20241110113639_LafOo | US000E | 2024-11-11T14:04:43.044Z | 2024-11-12T14:18:06.517Z |
5513260 | 5513260 | 20241110110630_sP3Se | US000E | 2024-11-11T14:04:15.984Z | 2024-11-12T14:18:06.415Z |
5513217 | 5513217 | 20241110105900_EREjF | US000E | 2024-11-11T14:04:10.164Z | 2024-11-12T14:18:06.398Z |
5513188 | 5513188 | 20241110105316_aRWxL | US000E | 2024-11-11T14:04:05.987Z | 2024-11-12T14:18:06.388Z |
5513108 | 5513108 | 20241110103752_uh4Od | US000E | 2024-11-11T14:03:53.715Z | 2024-11-12T14:18:06.350Z |
5513105 | 5513105 | 20241110103737_HLLUp | US000E | 2024-11-11T14:03:53.352Z | 2024-11-12T14:18:06.349Z |
5512996 | 5512996 | 20241110101829_3QDuf | US000E | 2024-11-11T14:03:43.345Z | 2024-11-12T14:18:06.299Z |
5512966 | 5512966 | 20241110101615_Vxm46 | US000E | 2024-11-11T14:03:40.953Z | 2024-11-12T14:18:06.289Z |
5512923 | 5512923 | 20241110101246_bphOi | US000E | 2024-11-11T14:03:37.542Z | 2024-11-12T14:18:06.274Z |
5512890 | 5512890 | 20241110100556_zQmkh | US000E | 2024-11-11T14:03:28.342Z | 2024-11-12T14:18:06.261Z |
5512815 | 5512815 | 20241110095253_wyDvT | US000E | 2024-11-11T14:03:12.471Z | 2024-11-12T14:18:06.232Z |
5512751 | 5512751 | 20241110094304_S23QW | US000E | 2024-11-11T14:03:04.852Z | 2024-11-12T14:18:06.209Z |
5512664 | 5512664 | 20241110092552_VM2Jc | US000E | 2024-11-11T14:02:55.199Z | 2024-11-12T14:18:06.169Z |
5512629 | 5512629 | 20241110091933_696is | US000E | 2024-11-11T14:02:51.791Z | 2024-11-12T14:18:06.150Z |
5512525 | 5512525 | 20241110090242_qkuL0 | US000E | 2024-11-11T14:02:31.036Z | 2024-11-12T14:18:06.107Z |
5512503 | 5512503 | 20241110090016_POJGf | US000E | 2024-11-11T14:02:26.231Z | 2024-11-12T14:18:06.099Z |
5512377 | 5512377 | 20241110083923_vvx3j | US000E | 2024-11-11T14:02:11.908Z | 2024-11-12T14:18:06.050Z |
5512365 | 5512365 | 20241110083737_aQj5H | US000E | 2024-11-11T14:02:10.667Z | 2024-11-12T14:18:06.046Z |
5512359 | 5512359 | 20241110083727_inu3v | US000E | 2024-11-11T14:02:10.323Z | 2024-11-12T14:18:06.045Z |
5512299 | 5512299 | 20241110082916_Q1ckt | US000E | 2024-11-11T14:02:03.729Z | 2024-11-12T14:18:06.021Z |
5512190 | 5512190 | 20241110081254_Foqcw | US000E | 2024-11-11T14:01:41.873Z | 2024-11-12T14:18:05.971Z |
5512157 | 5512157 | 20241110080652_hobxh | US000E | 2024-11-11T14:01:38.327Z | 2024-11-12T14:18:05.957Z |
5512090 | 5512090 | 20241110075503_aiwsL | US000E | 2024-11-11T14:01:31.681Z | 2024-11-12T14:18:05.930Z |
5512076 | 5512076 | 20241110075237_m2Q8z | US000E | 2024-11-11T14:01:29.368Z | 2024-11-12T14:18:05.923Z |
5512052 | 5512052 | 20241110074741_ryX9J | US000E | 2024-11-11T14:01:27.011Z | 2024-11-12T14:18:05.915Z |
5512035 | 5512035 | 20241110074646_BXMjz | US000E | 2024-11-11T14:01:25.449Z | 2024-11-12T14:18:05.909Z |
5511868 | 5511868 | 20241110071137_E7SwW | US000E | 2024-11-11T14:00:57.604Z | 2024-11-12T14:18:05.835Z |
5511861 | 5511861 | 20241110071120_5S3V2 | US000E | 2024-11-11T14:00:57.288Z | 2024-11-12T14:18:05.834Z |
5511819 | 5511819 | 20241110070441_nN9sW | US000E | 2024-11-11T14:00:52.832Z | 2024-11-12T14:18:05.817Z |
5511815 | 5511815 | 20241110070436_LEx5w | US000E | 2024-11-11T14:00:52.546Z | 2024-11-12T14:18:05.816Z |
5511793 | 5511793 | 20241110070111_A3ks3 | US000E | 2024-11-11T14:00:50.405Z | 2024-11-12T14:18:05.808Z |
5511715 | 5511715 | 20241110064422_MVmE0 | US000E | 2024-11-11T14:00:36.729Z | 2024-11-12T14:18:05.769Z |
5511631 | 5511631 | 20241110063028_3aY2w | US000E | 2024-11-11T14:00:22.412Z | 2024-11-12T14:18:05.728Z |
5511583 | 5511583 | 20241110061625_P2awA | US000E | 2024-11-11T14:00:13.658Z | 2024-11-12T14:18:05.699Z |
5511442 | 5511442 | 20241109061749_ueauN | US000E | 2024-11-10T14:16:48.957Z | 2024-11-12T14:23:50.308Z |
5511362 | 5511362 | 20241109055618_BP287 | US000E | 2024-11-10T14:16:43.083Z | 2024-11-12T14:23:48.828Z |
5511288 | 5511288 | 20241109053215_r7Yui | US000E | 2024-11-10T14:16:38.155Z | 2024-11-12T14:23:48.081Z |
5511268 | 5511268 | 20241109052806_qLCmX | US000E | 2024-11-10T14:16:37.080Z | 2024-11-12T14:23:47.602Z |
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);