participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,803 rows where station_code = "DE000X" 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 |
---|---|---|---|---|---|
5571368 | 5571368 | 20241120233246_XH6tu | DE000X | 2024-11-22T14:16:58.115Z | 2024-11-22T14:19:22.112Z |
5571080 | 5571080 | 20241120221817_XzMTF | DE000X | 2024-11-22T14:16:21.843Z | 2024-11-22T14:19:22.037Z |
5570833 | 5570833 | 20241120211225_7UkG9 | DE000X | 2024-11-22T14:16:08.239Z | 2024-11-22T14:19:21.991Z |
5563170 | 5563170 | 20241120010036_suut4 | DE000X | 2024-11-21T14:15:39.086Z | 2024-11-22T14:21:10.375Z |
5563144 | 5563144 | 20241120005630_j7Vwz | DE000X | 2024-11-21T14:15:38.229Z | 2024-11-22T14:21:09.966Z |
5556412 | 5556412 | 20241118210709_UhDk2 | DE000X | 2024-11-20T14:10:26.733Z | 2024-11-22T14:22:17.232Z |
5556330 | 5556330 | 20241118185447_c4SQ9 | DE000X | 2024-11-20T14:09:57.292Z | 2024-11-22T14:22:15.539Z |
5556300 | 5556300 | 20241118181419_52fMG | DE000X | 2024-11-20T14:09:49.591Z | 2024-11-22T14:22:14.808Z |
5556266 | 5556266 | 20241118171940_Ucjog | DE000X | 2024-11-20T14:09:42.107Z | 2024-11-22T14:22:13.973Z |
5476256 | 5476256 | 20241103225357_CrzNe | DE000X | 2024-11-05T14:14:58.721Z | 2024-11-12T14:28:04.578Z |
5476164 | 5476164 | 20241103223646_wmVWz | DE000X | 2024-11-05T14:14:49.240Z | 2024-11-12T14:28:03.598Z |
5476138 | 5476138 | 20241103223221_EjVSh | DE000X | 2024-11-05T14:14:47.751Z | 2024-11-12T14:28:03.363Z |
5476061 | 5476061 | 20241103221430_NsZoy | DE000X | 2024-11-05T14:14:42.159Z | 2024-11-12T14:28:02.534Z |
5475980 | 5475980 | 20241103220332_SH3jZ | DE000X | 2024-11-05T14:14:36.967Z | 2024-11-12T14:28:02.003Z |
5475928 | 5475928 | 20241103215454_otizR | DE000X | 2024-11-05T14:14:34.233Z | 2024-11-12T14:28:01.838Z |
5475848 | 5475848 | 20241103213725_5QWHi | DE000X | 2024-11-05T14:14:22.162Z | 2024-11-12T14:28:01.340Z |
5475844 | 5475844 | 20241103213604_FN7Rs | DE000X | 2024-11-05T14:14:22.029Z | 2024-11-12T14:28:01.328Z |
5475711 | 5475711 | 20241103210859_IJ8kH | DE000X | 2024-11-05T14:14:02.846Z | 2024-11-12T14:28:00.604Z |
5475663 | 5475663 | 20241103205632_3ylMy | DE000X | 2024-11-05T14:13:57.966Z | 2024-11-12T14:28:00.215Z |
5475241 | 5475241 | 20241103193417_93jgQ | DE000X | 2024-11-05T14:12:51.806Z | 2024-11-12T14:27:57.830Z |
5475035 | 5475035 | 20241103185310_mMsIl | DE000X | 2024-11-05T14:12:26.235Z | 2024-11-12T14:27:56.520Z |
5474987 | 5474987 | 20241103184703_1T2Ui | DE000X | 2024-11-05T14:12:22.144Z | 2024-11-12T14:27:55.977Z |
5474927 | 5474927 | 20241103183731_FaUAS | DE000X | 2024-11-05T14:12:17.376Z | 2024-11-12T14:27:55.604Z |
5474799 | 5474799 | 20241103181837_iAGXL | DE000X | 2024-11-05T14:12:02.776Z | 2024-11-12T14:27:54.751Z |
5474593 | 5474593 | 20241103174350_UKcxk | DE000X | 2024-11-05T14:11:20.114Z | 2024-11-12T14:27:53.390Z |
5474399 | 5474399 | 20241103171007_pzkpG | DE000X | 2024-11-05T14:11:02.327Z | 2024-11-12T14:27:51.599Z |
5474395 | 5474395 | 20241103171007_Ztate | DE000X | 2024-11-05T14:11:02.050Z | 2024-11-12T14:27:51.221Z |
5470070 | 5470070 | 20241103052152_1h6UH | DE000X | 2024-11-04T14:17:44.702Z | 2024-11-11T14:23:04.064Z |
5469998 | 5469998 | 20241103050456_Qj0tb | DE000X | 2024-11-04T14:17:32.485Z | 2024-11-11T14:23:03.450Z |
5469872 | 5469872 | 20241103043204_jeO19 | DE000X | 2024-11-04T14:17:12.988Z | 2024-11-11T14:23:02.592Z |
5469801 | 5469801 | 20241103042156_YEhya | DE000X | 2024-11-04T14:17:04.520Z | 2024-11-11T14:23:02.268Z |
5469795 | 5469795 | 20241103042034_jXaeZ | DE000X | 2024-11-04T14:17:03.668Z | 2024-11-11T14:23:02.245Z |
5469756 | 5469756 | 20241103041403_0Uldg | DE000X | 2024-11-04T14:16:59.809Z | 2024-11-11T14:23:02.185Z |
5469721 | 5469721 | 20241103040623_h0GjE | DE000X | 2024-11-04T14:16:56.519Z | 2024-11-11T14:23:02.076Z |
5469692 | 5469692 | 20241103040325_wwVb7 | DE000X | 2024-11-04T14:16:52.868Z | 2024-11-11T14:23:02.003Z |
5469671 | 5469671 | 20241103035943_W5CmV | DE000X | 2024-11-04T14:16:46.065Z | 2024-11-11T14:23:01.903Z |
5469647 | 5469647 | 20241103035546_8u0M1 | DE000X | 2024-11-04T14:16:43.217Z | 2024-11-11T14:23:01.837Z |
5469505 | 5469505 | 20241103033809_mK24F | DE000X | 2024-11-04T14:16:32.775Z | 2024-11-11T14:23:00.733Z |
5469490 | 5469490 | 20241103033621_lTfHD | DE000X | 2024-11-04T14:16:31.803Z | 2024-11-11T14:23:00.706Z |
5469451 | 5469451 | 20241103033035_JF7IV | DE000X | 2024-11-04T14:16:29.249Z | 2024-11-11T14:23:00.410Z |
5469157 | 5469157 | 20241103024240_yptYX | DE000X | 2024-11-04T14:15:46.871Z | 2024-11-11T14:22:58.706Z |
5469067 | 5469067 | 20241103022912_7qxXD | DE000X | 2024-11-04T14:15:33.492Z | 2024-11-11T14:22:57.662Z |
5469010 | 5469010 | 20241103022239_tALpC | DE000X | 2024-11-04T14:15:22.420Z | 2024-11-11T14:22:57.350Z |
5468894 | 5468894 | 20241103020608_R8Ef6 | DE000X | 2024-11-04T14:15:12.260Z | 2024-11-11T14:22:56.883Z |
5468776 | 5468776 | 20241103014509_WPo2k | DE000X | 2024-11-04T14:15:03.033Z | 2024-11-11T14:22:55.564Z |
5468676 | 5468676 | 20241103012225_QUZut | DE000X | 2024-11-04T14:14:54.006Z | 2024-11-11T14:22:54.640Z |
5468647 | 5468647 | 20241103011519_mwMBk | DE000X | 2024-11-04T14:14:46.166Z | 2024-11-11T14:22:54.512Z |
5468002 | 5468002 | 20241102231325_TXNAu | DE000X | 2024-11-04T14:13:06.285Z | 2024-11-11T14:22:50.778Z |
5467912 | 5467912 | 20241102225623_39Uud | DE000X | 2024-11-04T14:12:57.185Z | 2024-11-11T14:22:50.321Z |
5467858 | 5467858 | 20241102224738_Rw4u9 | DE000X | 2024-11-04T14:12:44.591Z | 2024-11-11T14:22:50.078Z |
5467778 | 5467778 | 20241102223559_omkug | DE000X | 2024-11-04T14:12:30.780Z | 2024-11-11T14:22:49.631Z |
5467728 | 5467728 | 20241102222522_cZyh9 | DE000X | 2024-11-04T14:12:24.920Z | 2024-11-11T14:22:49.157Z |
5467705 | 5467705 | 20241102222209_nf3cM | DE000X | 2024-11-04T14:12:23.018Z | 2024-11-11T14:22:49.017Z |
5467600 | 5467600 | 20241102220242_fBoW3 | DE000X | 2024-11-04T14:12:13.295Z | 2024-11-11T14:22:47.809Z |
5467592 | 5467592 | 20241102220220_mhNX0 | DE000X | 2024-11-04T14:12:08.672Z | 2024-11-11T14:22:47.696Z |
5467588 | 5467588 | 20241102220211_ovlpz | DE000X | 2024-11-04T14:12:08.025Z | 2024-11-11T14:22:47.689Z |
5467218 | 5467218 | 20241102202506_9ZQ8l | DE000X | 2024-11-04T14:11:07.031Z | 2024-11-11T14:22:45.723Z |
5467206 | 5467206 | 20241102202420_NVzUG | DE000X | 2024-11-04T14:11:06.077Z | 2024-11-11T14:22:45.596Z |
5467033 | 5467033 | 20241102194910_qw4wo | DE000X | 2024-11-04T14:10:29.887Z | 2024-11-11T14:22:44.961Z |
5466976 | 5466976 | 20241102193834_yTwNK | DE000X | 2024-11-04T14:10:25.082Z | 2024-11-11T14:22:44.748Z |
5466856 | 5466856 | 20241102191058_dWJ38 | DE000X | 2024-11-04T14:10:08.146Z | 2024-11-11T14:22:43.873Z |
5466576 | 5466576 | 20241102180551_2mtit | DE000X | 2024-11-04T14:09:21.382Z | 2024-11-11T14:22:41.388Z |
5466302 | 5466302 | 20241102170724_iuEwX | DE000X | 2024-11-04T14:08:35.047Z | 2024-11-11T14:22:40.198Z |
5444135 | 5444135 | 20241031005140_hotw3 | DE000X | 2024-11-01T12:21:07.662Z | 2024-11-08T14:23:14.006Z |
5444024 | 5444024 | 20241031003923_uaytd | DE000X | 2024-11-01T12:21:01.870Z | 2024-11-08T14:23:13.559Z |
5443684 | 5443684 | 20241031000500_7fqjd | DE000X | 2024-11-01T12:20:46.344Z | 2024-11-08T14:23:11.988Z |
5440629 | 5440629 | 20241030223709_rFoew | DE000X | 2024-11-01T12:15:40.342Z | 2024-11-08T14:23:10.112Z |
5440500 | 5440500 | 20241030222105_iC7CS | DE000X | 2024-11-01T12:15:33.607Z | 2024-11-08T14:23:09.730Z |
5440400 | 5440400 | 20241030220746_IKgFQ | DE000X | 2024-11-01T12:15:29.009Z | 2024-11-08T14:23:09.352Z |
5440002 | 5440002 | 20241030210454_e2Pd3 | DE000X | 2024-11-01T12:14:43.715Z | 2024-11-08T14:23:06.702Z |
5439476 | 5439476 | 20241030195701_1eEQE | DE000X | 2024-11-01T12:13:52.401Z | 2024-11-08T14:23:03.499Z |
5422942 | 5422942 | 20241026212238_mUIjI | DE000X | 2024-10-30T12:22:04.530Z | 2024-11-04T14:28:47.799Z |
5422810 | 5422810 | 20241026173325_6ScMy | DE000X | 2024-10-30T12:21:30.586Z | 2024-11-04T14:28:39.359Z |
5419473 | 5419473 | 20241028000533_iw9xd | DE000X | 2024-10-30T12:17:28.774Z | 2024-11-05T14:27:13.159Z |
5419246 | 5419246 | 20241027232410_vvz9F | DE000X | 2024-10-30T12:17:16.708Z | 2024-11-05T14:27:12.589Z |
5419190 | 5419190 | 20241027231255_2MvXv | DE000X | 2024-10-30T12:17:14.211Z | 2024-11-05T14:27:12.513Z |
5419023 | 5419023 | 20241027224630_23vTi | DE000X | 2024-10-30T12:16:53.732Z | 2024-11-05T14:27:12.233Z |
5419005 | 5419005 | 20241027224508_MCS6L | DE000X | 2024-10-30T12:16:51.623Z | 2024-11-05T14:27:12.056Z |
5418992 | 5418992 | 20241027224109_p9XdK | DE000X | 2024-10-30T12:16:49.211Z | 2024-11-05T14:27:11.910Z |
5418946 | 5418946 | 20241027223154_XLupS | DE000X | 2024-10-30T12:16:42.611Z | 2024-11-05T14:27:11.805Z |
5418920 | 5418920 | 20241027222617_dmawv | DE000X | 2024-10-30T12:16:37.200Z | 2024-11-05T14:27:11.767Z |
5418902 | 5418902 | 20241027222225_GmU5k | DE000X | 2024-10-30T12:16:31.029Z | 2024-11-05T14:27:11.690Z |
5418883 | 5418883 | 20241027221942_ZPi4Q | DE000X | 2024-10-30T12:16:27.288Z | 2024-11-05T14:27:11.660Z |
5418428 | 5418428 | 20241027204436_S3YOG | DE000X | 2024-10-30T12:15:40.709Z | 2024-11-05T14:27:10.011Z |
5418403 | 5418403 | 20241027204033_iVgro | DE000X | 2024-10-30T12:15:39.050Z | 2024-11-05T14:27:09.963Z |
5418340 | 5418340 | 20241027202635_dGeJq | DE000X | 2024-10-30T12:15:31.750Z | 2024-11-05T14:27:09.710Z |
5418119 | 5418119 | 20241027195655_AkAMN | DE000X | 2024-10-30T12:14:56.840Z | 2024-11-05T14:27:09.156Z |
5418011 | 5418011 | 20241027194013_MWgZ5 | DE000X | 2024-10-30T12:14:44.781Z | 2024-11-05T14:27:08.866Z |
5417773 | 5417773 | 20241027191225_HgTAk | DE000X | 2024-10-30T12:14:27.342Z | 2024-11-05T14:27:08.215Z |
5417531 | 5417531 | 20241027184220_RgmTw | DE000X | 2024-10-30T12:13:46.626Z | 2024-11-05T14:27:07.487Z |
5406366 | 5406366 | 20241027013137_ZO4UU | DE000X | 2024-10-29T12:14:04.522Z | 2024-11-04T14:28:55.518Z |
5404424 | 5404424 | 20241026232502_PcNVD | DE000X | 2024-10-29T12:11:23.049Z | 2024-11-04T14:28:50.986Z |
5404418 | 5404418 | 20241026232445_K1md9 | DE000X | 2024-10-29T12:11:21.905Z | 2024-11-04T14:28:50.898Z |
5404320 | 5404320 | 20241026231754_Vi6Ov | DE000X | 2024-10-29T12:11:09.666Z | 2024-11-04T14:28:50.628Z |
5404100 | 5404100 | 20241026225813_cH2d8 | DE000X | 2024-10-29T12:10:53.571Z | 2024-11-04T14:28:50.330Z |
5404030 | 5404030 | 20241026225405_tgBCj | DE000X | 2024-10-29T12:10:48.949Z | 2024-11-04T14:28:50.254Z |
5403582 | 5403582 | 20241026221345_DzmPo | DE000X | 2024-10-29T12:09:59.596Z | 2024-11-04T14:28:49.245Z |
5403555 | 5403555 | 20241026220919_AGY0u | DE000X | 2024-10-29T12:09:53.023Z | 2024-11-04T14:28:49.146Z |
5403430 | 5403430 | 20241026215612_tp2nZ | DE000X | 2024-10-29T12:09:29.807Z | 2024-11-04T14:28:48.812Z |
5403402 | 5403402 | 20241026215131_zvb4q | DE000X | 2024-10-29T12:09:27.463Z | 2024-11-04T14:28:48.709Z |
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);