participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
703 rows where station_code = "DE000Y" 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 |
---|---|---|---|---|---|
5119825 | 5119825 | 20240914025035_VMcYR | DE000Y | 2024-09-18T12:10:28.142Z | 2024-09-19T12:19:58.988Z |
5119342 | 5119342 | 20240914022615_mOUGc | DE000Y | 2024-09-18T12:10:20.358Z | 2024-09-19T12:19:58.026Z |
5115821 | 5115821 | 20240915025428_X1MiS | DE000Y | 2024-09-18T12:06:26.085Z | 2024-09-19T12:19:07.439Z |
5115660 | 5115660 | 20240915024717_I2UTw | DE000Y | 2024-09-18T12:06:20.608Z | 2024-09-19T12:19:06.072Z |
5115269 | 5115269 | 20240915023050_m7XB9 | DE000Y | 2024-09-18T12:06:09.080Z | 2024-09-19T12:19:03.557Z |
5115049 | 5115049 | 20240915021602_Hajv1 | DE000Y | 2024-09-18T12:05:54.423Z | 2024-09-19T12:19:01.251Z |
5114888 | 5114888 | 20240915020517_KrrX2 | DE000Y | 2024-09-18T12:05:39.758Z | 2024-09-19T12:19:00.476Z |
5114854 | 5114854 | 20240915020133_dfDRt | DE000Y | 2024-09-18T12:05:37.715Z | 2024-09-19T12:19:00.297Z |
5114650 | 5114650 | 20240915015305_z4vRc | DE000Y | 2024-09-18T12:05:27.241Z | 2024-09-19T12:18:59.182Z |
5114480 | 5114480 | 20240915014437_EtWeT | DE000Y | 2024-09-18T12:05:19.679Z | 2024-09-19T12:18:58.524Z |
5114460 | 5114460 | 20240915014304_Y6yv0 | DE000Y | 2024-09-18T12:05:18.863Z | 2024-09-19T12:18:58.349Z |
5114110 | 5114110 | 20240915012724_yAdUE | DE000Y | 2024-09-18T12:05:02.596Z | 2024-09-19T12:18:56.122Z |
5114102 | 5114102 | 20240915012708_kjWFz | DE000Y | 2024-09-18T12:05:02.114Z | 2024-09-19T12:18:56.083Z |
5113957 | 5113957 | 20240915012108_Z05Xk | DE000Y | 2024-09-18T12:04:56.516Z | 2024-09-19T12:18:54.752Z |
5113918 | 5113918 | 20240915012008_DJrpv | DE000Y | 2024-09-18T12:04:55.532Z | 2024-09-19T12:18:54.333Z |
5113915 | 5113915 | 20240915011835_0J2YK | DE000Y | 2024-09-18T12:04:55.309Z | 2024-09-19T12:18:54.272Z |
5113825 | 5113825 | 20240915011444_3QjzD | DE000Y | 2024-09-18T12:04:51.830Z | 2024-09-19T12:18:53.254Z |
5113540 | 5113540 | 20240915005659_GLCZI | DE000Y | 2024-09-18T12:04:27.361Z | 2024-09-19T12:18:50.095Z |
5113456 | 5113456 | 20240915005039_flhOx | DE000Y | 2024-09-18T12:04:19.061Z | 2024-09-19T12:18:49.347Z |
5113286 | 5113286 | 20240915003519_mMVqT | DE000Y | 2024-09-18T12:04:05.774Z | 2024-09-19T12:18:48.360Z |
5113259 | 5113259 | 20240915003422_qtdrB | DE000Y | 2024-09-18T12:04:04.861Z | 2024-09-19T12:18:48.283Z |
5113159 | 5113159 | 20240915002747_xoKXQ | DE000Y | 2024-09-18T12:04:00.113Z | 2024-09-19T12:18:47.692Z |
5113117 | 5113117 | 20240915002246_j2mmR | DE000Y | 2024-09-18T12:03:57.112Z | 2024-09-19T12:18:47.153Z |
5113074 | 5113074 | 20240915001756_zI6OH | DE000Y | 2024-09-18T12:03:54.647Z | 2024-09-19T12:18:46.881Z |
5112862 | 5112862 | 20240915000114_YIQ7L | DE000Y | 2024-09-18T12:03:43.758Z | 2024-09-19T12:18:45.414Z |
5112664 | 5112664 | 20240914233910_ohG1a | DE000Y | 2024-09-18T12:03:20.144Z | 2024-09-19T12:18:42.788Z |
5112538 | 5112538 | 20240914232801_1b033 | DE000Y | 2024-09-18T12:03:12.702Z | 2024-09-19T12:18:41.384Z |
5112238 | 5112238 | 20240914223928_gHwnq | DE000Y | 2024-09-18T12:02:55.137Z | 2024-09-19T12:18:39.911Z |
5112177 | 5112177 | 20240914223353_OCgDz | DE000Y | 2024-09-18T12:02:51.746Z | 2024-09-19T12:18:38.914Z |
5112036 | 5112036 | 20240914220144_Ls4to | DE000Y | 2024-09-18T12:02:42.964Z | 2024-09-19T12:18:36.943Z |
5111872 | 5111872 | 20240914212949_r4n2m | DE000Y | 2024-09-18T12:02:27.831Z | 2024-09-19T12:18:34.816Z |
5111626 | 5111626 | 20240914205504_4NEmT | DE000Y | 2024-09-18T12:02:08.352Z | 2024-09-19T12:18:32.619Z |
5111375 | 5111375 | 20240914202931_w1X3m | DE000Y | 2024-09-18T12:01:52.944Z | 2024-09-19T12:18:29.720Z |
5111122 | 5111122 | 20240914200100_VVB3B | DE000Y | 2024-09-18T12:01:35.759Z | 2024-09-19T12:18:26.836Z |
5092720 | 5092720 | 20240912025516_rBfLq | DE000Y | 2024-09-16T12:14:02.555Z | 2024-09-19T12:21:14.436Z |
5092668 | 5092668 | 20240912025410_OakrS | DE000Y | 2024-09-16T12:14:01.826Z | 2024-09-19T12:21:14.404Z |
5092444 | 5092444 | 20240912024626_7WkZw | DE000Y | 2024-09-16T12:13:55.370Z | 2024-09-19T12:21:14.113Z |
5092227 | 5092227 | 20240912024013_k925Q | DE000Y | 2024-09-16T12:13:44.099Z | 2024-09-19T12:21:13.710Z |
5092185 | 5092185 | 20240912023932_wQyAn | DE000Y | 2024-09-16T12:13:43.240Z | 2024-09-19T12:21:13.690Z |
5091693 | 5091693 | 20240912021906_2DeAM | DE000Y | 2024-09-16T12:13:18.974Z | 2024-09-19T12:21:13.352Z |
5091333 | 5091333 | 20240912020533_vhZQn | DE000Y | 2024-09-16T12:13:01.228Z | 2024-09-19T12:21:12.833Z |
5091072 | 5091072 | 20240912015640_JiNQd | DE000Y | 2024-09-16T12:12:47.748Z | 2024-09-19T12:21:12.515Z |
5090741 | 5090741 | 20240912014332_iXJLI | DE000Y | 2024-09-16T12:12:32.682Z | 2024-09-19T12:21:11.921Z |
5090242 | 5090242 | 20240912011728_RHp0o | DE000Y | 2024-09-16T12:12:08.382Z | 2024-09-19T12:21:11.104Z |
5089754 | 5089754 | 20240912005622_2ebjH | DE000Y | 2024-09-16T12:11:40.949Z | 2024-09-19T12:21:10.455Z |
5089199 | 5089199 | 20240912002846_YPJMp | DE000Y | 2024-09-16T12:11:17.379Z | 2024-09-19T12:21:09.829Z |
5089044 | 5089044 | 20240912002314_SmGCQ | DE000Y | 2024-09-16T12:11:14.113Z | 2024-09-19T12:21:09.720Z |
5088356 | 5088356 | 20240913000711_ShFxE | DE000Y | 2024-09-16T12:07:54.625Z | 2024-09-19T12:20:36.700Z |
5085712 | 5085712 | 20240912214655_ycYuO | DE000Y | 2024-09-16T12:04:48.042Z | 2024-09-19T12:20:29.553Z |
5085595 | 5085595 | 20240912213224_GH3Df | DE000Y | 2024-09-16T12:04:26.652Z | 2024-09-19T12:20:29.157Z |
5084912 | 5084912 | 20240912203240_V6cte | DE000Y | 2024-09-16T12:03:12.577Z | 2024-09-19T12:20:27.486Z |
5075762 | 5075762 | 20240912000540_Bp2a8 | DE000Y | 2024-09-15T12:10:11.954Z | 2024-09-19T12:21:09.480Z |
5074094 | 5074094 | 20240911221358_VuI33 | DE000Y | 2024-09-15T12:07:58.212Z | 2024-09-19T12:21:06.894Z |
5071978 | 5071978 | 20240911191436_SF2yr | DE000Y | 2024-09-15T12:04:11.207Z | 2024-09-19T12:21:03.190Z |
5064788 | 5064788 | 20240910020520_G4Puz | DE000Y | 2024-09-14T12:16:02.229Z | 2024-09-18T12:15:17.375Z |
5054463 | 5054463 | 20240908025444_9KAoq | DE000Y | 2024-09-13T12:16:42.633Z | 2024-09-16T12:21:15.650Z |
5054409 | 5054409 | 20240908024703_EEUAM | DE000Y | 2024-09-13T12:16:40.367Z | 2024-09-16T12:21:15.461Z |
5054349 | 5054349 | 20240908024146_90rSg | DE000Y | 2024-09-13T12:16:39.128Z | 2024-09-16T12:21:15.169Z |
5054254 | 5054254 | 20240908023251_6NILd | DE000Y | 2024-09-13T12:16:35.463Z | 2024-09-16T12:21:14.682Z |
5054248 | 5054248 | 20240908023157_FKXv3 | DE000Y | 2024-09-13T12:16:35.381Z | 2024-09-16T12:21:14.672Z |
5054161 | 5054161 | 20240908021721_uebq7 | DE000Y | 2024-09-13T12:16:31.746Z | 2024-09-16T12:21:14.170Z |
5054158 | 5054158 | 20240908021704_wpyJ1 | DE000Y | 2024-09-13T12:16:31.673Z | 2024-09-16T12:21:14.169Z |
5054067 | 5054067 | 20240908020630_tkkEn | DE000Y | 2024-09-13T12:16:28.085Z | 2024-09-16T12:21:13.872Z |
5054018 | 5054018 | 20240908020111_3MWRE | DE000Y | 2024-09-13T12:16:26.624Z | 2024-09-16T12:21:13.763Z |
5053945 | 5053945 | 20240908015236_x5tUd | DE000Y | 2024-09-13T12:16:23.781Z | 2024-09-16T12:21:13.354Z |
5053932 | 5053932 | 20240908015039_k1DlB | DE000Y | 2024-09-13T12:16:23.186Z | 2024-09-16T12:21:13.335Z |
5053909 | 5053909 | 20240908014751_Enw33 | DE000Y | 2024-09-13T12:16:22.577Z | 2024-09-16T12:21:13.140Z |
5053675 | 5053675 | 20240908011527_0DlQ6 | DE000Y | 2024-09-13T12:16:13.257Z | 2024-09-16T12:21:12.395Z |
5053656 | 5053656 | 20240908011307_gx8BI | DE000Y | 2024-09-13T12:16:11.571Z | 2024-09-16T12:21:12.294Z |
5053550 | 5053550 | 20240908005503_2oWXD | DE000Y | 2024-09-13T12:16:08.370Z | 2024-09-16T12:21:11.893Z |
5053469 | 5053469 | 20240908004204_BHzKu | DE000Y | 2024-09-13T12:16:05.342Z | 2024-09-16T12:21:11.467Z |
5053426 | 5053426 | 20240908003437_cR2Av | DE000Y | 2024-09-13T12:16:03.693Z | 2024-09-16T12:21:10.589Z |
5053343 | 5053343 | 20240908001618_MHqc5 | DE000Y | 2024-09-13T12:15:59.513Z | 2024-09-16T12:21:10.356Z |
5053317 | 5053317 | 20240908000940_3rSrs | DE000Y | 2024-09-13T12:15:58.634Z | 2024-09-16T12:21:10.323Z |
5053152 | 5053152 | 20240907233926_vsqkW | DE000Y | 2024-09-13T12:15:50.302Z | 2024-09-16T12:21:09.862Z |
5053115 | 5053115 | 20240907233015_P0eOy | DE000Y | 2024-09-13T12:15:47.162Z | 2024-09-16T12:21:09.517Z |
5052833 | 5052833 | 20240907221526_mIsFM | DE000Y | 2024-09-13T12:15:30.515Z | 2024-09-16T12:21:08.185Z |
5052829 | 5052829 | 20240907221319_mq6Nl | DE000Y | 2024-09-13T12:15:30.159Z | 2024-09-16T12:21:08.130Z |
5052712 | 5052712 | 20240907214332_TbzoU | DE000Y | 2024-09-13T12:15:22.446Z | 2024-09-16T12:21:07.319Z |
5052568 | 5052568 | 20240907210418_jfUOT | DE000Y | 2024-09-13T12:15:14.146Z | 2024-09-16T12:21:06.486Z |
5051993 | 5051993 | 20240907192142_gB2eP | DE000Y | 2024-09-13T12:14:52.127Z | 2024-09-16T12:21:02.757Z |
5046023 | 5046023 | 20240908204143_OUq3r | DE000Y | 2024-09-13T12:05:36.193Z | 2024-09-17T12:18:58.410Z |
5039724 | 5039724 | 20240906015634_kpUja | DE000Y | 2024-09-12T12:15:43.418Z | 2024-09-14T12:23:04.395Z |
5039703 | 5039703 | 20240906015405_QOmLQ | DE000Y | 2024-09-12T12:15:42.571Z | 2024-09-14T12:23:04.315Z |
5039575 | 5039575 | 20240906013011_BwuSy | DE000Y | 2024-09-12T12:15:37.918Z | 2024-09-14T12:23:03.565Z |
5039482 | 5039482 | 20240906010948_BZKSx | DE000Y | 2024-09-12T12:15:34.974Z | 2024-09-14T12:23:02.420Z |
5039155 | 5039155 | 20240905233556_2b5Fz | DE000Y | 2024-09-12T12:15:17.883Z | 2024-09-14T12:23:00.525Z |
5038886 | 5038886 | 20240905222740_CmWwX | DE000Y | 2024-09-12T12:15:06.029Z | 2024-09-14T12:22:59.128Z |
5038762 | 5038762 | 20240905214305_P9Lw2 | DE000Y | 2024-09-12T12:14:59.775Z | 2024-09-14T12:22:57.883Z |
5038572 | 5038572 | 20240905210119_AADdS | DE000Y | 2024-09-12T12:14:48.410Z | 2024-09-14T12:22:56.477Z |
5038531 | 5038531 | 20240905204604_5FrVe | DE000Y | 2024-09-12T12:14:45.754Z | 2024-09-14T12:22:56.360Z |
5033120 | 5033120 | 20240907022615_iYgU2 | DE000Y | 2024-09-12T12:08:50.767Z | 2024-09-15T12:21:29.030Z |
5032938 | 5032938 | 20240907020621_LHMpU | DE000Y | 2024-09-12T12:08:32.587Z | 2024-09-15T12:21:28.372Z |
5032812 | 5032812 | 20240907015106_xx334 | DE000Y | 2024-09-12T12:08:06.335Z | 2024-09-15T12:21:27.974Z |
5032785 | 5032785 | 20240907014734_7xPXo | DE000Y | 2024-09-12T12:08:01.224Z | 2024-09-15T12:21:27.837Z |
5032448 | 5032448 | 20240907010319_oTzh7 | DE000Y | 2024-09-12T12:07:19.207Z | 2024-09-15T12:21:26.467Z |
5032431 | 5032431 | 20240907010138_803LW | DE000Y | 2024-09-12T12:07:17.535Z | 2024-09-15T12:21:26.445Z |
5032386 | 5032386 | 20240907005608_RDKOR | DE000Y | 2024-09-12T12:07:13.430Z | 2024-09-15T12:21:26.310Z |
5032287 | 5032287 | 20240907004107_kE5IJ | DE000Y | 2024-09-12T12:07:03.821Z | 2024-09-15T12:21:25.805Z |
5032142 | 5032142 | 20240907001935_th6dl | DE000Y | 2024-09-12T12:06:37.267Z | 2024-09-15T12:21:25.346Z |
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);