participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,545 rows where station_code = "NL000C" 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 |
---|---|---|---|---|---|
5133624 | 5133624 | 20240916034836_0supi | NL000C | 2024-09-19T12:17:04.263Z | 2024-09-19T12:17:04.263Z |
5133196 | 5133196 | 20240916030635_NyQ6D | NL000C | 2024-09-19T12:16:48.470Z | 2024-09-19T12:16:48.470Z |
5133138 | 5133138 | 20240916030017_42j2k | NL000C | 2024-09-19T12:16:45.354Z | 2024-09-19T12:16:45.354Z |
5133136 | 5133136 | 20240916030007_IktC8 | NL000C | 2024-09-19T12:16:45.199Z | 2024-09-19T12:16:45.199Z |
5133110 | 5133110 | 20240916025742_hjNZS | NL000C | 2024-09-19T12:16:44.364Z | 2024-09-19T12:16:44.364Z |
5133096 | 5133096 | 20240916025128_51E1q | NL000C | 2024-09-19T12:16:44.223Z | 2024-09-19T12:16:44.223Z |
5132647 | 5132647 | 20240916014943_VQIj2 | NL000C | 2024-09-19T12:16:24.686Z | 2024-09-19T12:16:24.686Z |
5128124 | 5128124 | 20240917004426_ceRgw | NL000C | 2024-09-19T12:10:07.097Z | 2024-09-19T12:10:07.097Z |
5128122 | 5128122 | 20240917004420_bwLAG | NL000C | 2024-09-19T12:10:06.514Z | 2024-09-19T12:10:06.514Z |
5128120 | 5128120 | 20240917004335_RbHiL | NL000C | 2024-09-19T12:10:06.113Z | 2024-09-19T12:10:06.113Z |
5128083 | 5128083 | 20240917003411_AqYOW | NL000C | 2024-09-19T12:10:02.396Z | 2024-09-19T12:10:02.396Z |
5128033 | 5128033 | 20240917002452_Mtvn2 | NL000C | 2024-09-19T12:09:55.547Z | 2024-09-19T12:09:55.547Z |
5128025 | 5128025 | 20240917002211_2pyxk | NL000C | 2024-09-19T12:09:54.588Z | 2024-09-19T12:09:54.588Z |
5127957 | 5127957 | 20240917001034_DHbPk | NL000C | 2024-09-19T12:09:48.768Z | 2024-09-19T12:09:48.768Z |
5127941 | 5127941 | 20240917000555_7kSbZ | NL000C | 2024-09-19T12:09:47.430Z | 2024-09-19T12:09:47.430Z |
5127871 | 5127871 | 20240916235317_Na87l | NL000C | 2024-09-19T12:09:44.597Z | 2024-09-19T12:09:44.597Z |
5127828 | 5127828 | 20240916234224_ES8XG | NL000C | 2024-09-19T12:09:41.582Z | 2024-09-19T12:09:41.582Z |
5127669 | 5127669 | 20240916224909_8heT1 | NL000C | 2024-09-19T12:09:30.966Z | 2024-09-19T12:09:30.966Z |
5127246 | 5127246 | 20240916210944_imXQr | NL000C | 2024-09-19T12:08:41.260Z | 2024-09-19T12:08:41.260Z |
5127078 | 5127078 | 20240916202241_x4RMa | NL000C | 2024-09-19T12:08:05.439Z | 2024-09-19T12:08:05.439Z |
5126950 | 5126950 | 20240916200115_sZ3jP | NL000C | 2024-09-19T12:07:48.205Z | 2024-09-19T12:07:48.205Z |
5126941 | 5126941 | 20240916195848_pCFOg | NL000C | 2024-09-19T12:07:46.207Z | 2024-09-19T12:07:46.207Z |
5126784 | 5126784 | 20240916191925_312Vh | NL000C | 2024-09-19T12:07:12.652Z | 2024-09-19T12:07:12.652Z |
5126763 | 5126763 | 20240916190845_4JclA | NL000C | 2024-09-19T12:07:05.208Z | 2024-09-19T12:07:05.208Z |
5121078 | 5121078 | 20240914035138_TPfEl | NL000C | 2024-09-18T12:10:50.527Z | 2024-09-19T12:20:01.287Z |
5120798 | 5120798 | 20240914033549_HftPa | NL000C | 2024-09-18T12:10:47.080Z | 2024-09-19T12:20:00.901Z |
5120743 | 5120743 | 20240914033326_sPBhJ | NL000C | 2024-09-18T12:10:46.462Z | 2024-09-19T12:20:00.837Z |
5120707 | 5120707 | 20240914033248_cvgVK | NL000C | 2024-09-18T12:10:46.018Z | 2024-09-19T12:20:00.782Z |
5120482 | 5120482 | 20240914032421_NbCde | NL000C | 2024-09-18T12:10:41.836Z | 2024-09-19T12:20:00.491Z |
5120364 | 5120364 | 20240914031800_RofvF | NL000C | 2024-09-18T12:10:38.476Z | 2024-09-19T12:20:00.067Z |
5120336 | 5120336 | 20240914031605_VHtcv | NL000C | 2024-09-18T12:10:37.805Z | 2024-09-19T12:19:59.946Z |
5120192 | 5120192 | 20240914030407_SADvz | NL000C | 2024-09-18T12:10:33.885Z | 2024-09-19T12:19:59.545Z |
5120133 | 5120133 | 20240914030105_elny2 | NL000C | 2024-09-18T12:10:32.543Z | 2024-09-19T12:19:59.459Z |
5119974 | 5119974 | 20240914025455_3BQCa | NL000C | 2024-09-18T12:10:30.155Z | 2024-09-19T12:19:59.203Z |
5119912 | 5119912 | 20240914025244_JqXZf | NL000C | 2024-09-18T12:10:29.055Z | 2024-09-19T12:19:59.139Z |
5119497 | 5119497 | 20240914023630_ovrgr | NL000C | 2024-09-18T12:10:21.722Z | 2024-09-19T12:19:58.390Z |
5119309 | 5119309 | 20240914022254_xGikP | NL000C | 2024-09-18T12:10:19.770Z | 2024-09-19T12:19:57.900Z |
5119222 | 5119222 | 20240914021831_2SKUF | NL000C | 2024-09-18T12:10:18.739Z | 2024-09-19T12:19:57.469Z |
5119053 | 5119053 | 20240914020655_FjWQZ | NL000C | 2024-09-18T12:10:15.391Z | 2024-09-19T12:19:56.984Z |
5116969 | 5116969 | 20240915035126_J6UzA | NL000C | 2024-09-18T12:07:26.689Z | 2024-09-19T12:19:12.820Z |
5116567 | 5116567 | 20240915033153_3XlN3 | NL000C | 2024-09-18T12:07:10.274Z | 2024-09-19T12:19:11.533Z |
5116461 | 5116461 | 20240915032737_v9bEu | NL000C | 2024-09-18T12:07:04.281Z | 2024-09-19T12:19:11.230Z |
5116338 | 5116338 | 20240915032229_XoNvt | NL000C | 2024-09-18T12:06:58.647Z | 2024-09-19T12:19:10.560Z |
5116301 | 5116301 | 20240915032028_uaig5 | NL000C | 2024-09-18T12:06:55.917Z | 2024-09-19T12:19:10.268Z |
5116256 | 5116256 | 20240915031855_FXFzg | NL000C | 2024-09-18T12:06:51.540Z | 2024-09-19T12:19:09.990Z |
5115697 | 5115697 | 20240915024906_jGfsX | NL000C | 2024-09-18T12:06:21.372Z | 2024-09-19T12:19:06.400Z |
5115642 | 5115642 | 20240915024658_cR5HB | NL000C | 2024-09-18T12:06:20.081Z | 2024-09-19T12:19:05.887Z |
5115470 | 5115470 | 20240915024039_Rj2ao | NL000C | 2024-09-18T12:06:15.738Z | 2024-09-19T12:19:04.988Z |
5115422 | 5115422 | 20240915023704_NwXmI | NL000C | 2024-09-18T12:06:13.459Z | 2024-09-19T12:19:04.590Z |
5115326 | 5115326 | 20240915023243_FQFUI | NL000C | 2024-09-18T12:06:10.958Z | 2024-09-19T12:19:03.945Z |
5115284 | 5115284 | 20240915023107_bECW7 | NL000C | 2024-09-18T12:06:09.850Z | 2024-09-19T12:19:03.679Z |
5115223 | 5115223 | 20240915022749_7b2Yt | NL000C | 2024-09-18T12:06:07.153Z | 2024-09-19T12:19:03.118Z |
5115207 | 5115207 | 20240915022722_49TUe | NL000C | 2024-09-18T12:06:06.338Z | 2024-09-19T12:19:03.002Z |
5114951 | 5114951 | 20240915020943_Al6mZ | NL000C | 2024-09-18T12:05:45.693Z | 2024-09-19T12:19:00.770Z |
5114604 | 5114604 | 20240915015220_ONqNF | NL000C | 2024-09-18T12:05:24.760Z | 2024-09-19T12:18:59.076Z |
5114590 | 5114590 | 20240915015112_u049m | NL000C | 2024-09-18T12:05:23.326Z | 2024-09-19T12:18:59.014Z |
5114354 | 5114354 | 20240915013855_A2HEJ | NL000C | 2024-09-18T12:05:12.681Z | 2024-09-19T12:18:57.743Z |
5114331 | 5114331 | 20240915013646_5qu8d | NL000C | 2024-09-18T12:05:11.005Z | 2024-09-19T12:18:57.575Z |
5113878 | 5113878 | 20240915011658_z6hId | NL000C | 2024-09-18T12:04:54.367Z | 2024-09-19T12:18:54.015Z |
5113781 | 5113781 | 20240915011345_bBvbi | NL000C | 2024-09-18T12:04:50.455Z | 2024-09-19T12:18:52.628Z |
5113674 | 5113674 | 20240915010501_KMGKK | NL000C | 2024-09-18T12:04:39.142Z | 2024-09-19T12:18:50.977Z |
5112757 | 5112757 | 20240914234935_M3oSO | NL000C | 2024-09-18T12:03:28.126Z | 2024-09-19T12:18:44.291Z |
5112619 | 5112619 | 20240914233558_r21AQ | NL000C | 2024-09-18T12:03:17.207Z | 2024-09-19T12:18:41.654Z |
5112287 | 5112287 | 20240914225106_wZgfh | NL000C | 2024-09-18T12:02:58.448Z | 2024-09-19T12:18:40.373Z |
5112086 | 5112086 | 20240914221019_3S3Do | NL000C | 2024-09-18T12:02:46.997Z | 2024-09-19T12:18:38.026Z |
5112031 | 5112031 | 20240914220038_ELi9g | NL000C | 2024-09-18T12:02:42.532Z | 2024-09-19T12:18:36.633Z |
5112025 | 5112025 | 20240914215815_L1UF2 | NL000C | 2024-09-18T12:02:41.562Z | 2024-09-19T12:18:36.617Z |
5112006 | 5112006 | 20240914215341_2ltFY | NL000C | 2024-09-18T12:02:38.299Z | 2024-09-19T12:18:36.387Z |
5111904 | 5111904 | 20240914213713_hVKEe | NL000C | 2024-09-18T12:02:30.112Z | 2024-09-19T12:18:35.144Z |
5111779 | 5111779 | 20240914211600_8dG4M | NL000C | 2024-09-18T12:02:16.544Z | 2024-09-19T12:18:33.956Z |
5111313 | 5111313 | 20240914202056_Nl12i | NL000C | 2024-09-18T12:01:48.534Z | 2024-09-19T12:18:28.851Z |
5111210 | 5111210 | 20240914201038_DK8LV | NL000C | 2024-09-18T12:01:43.319Z | 2024-09-19T12:18:27.414Z |
5111128 | 5111128 | 20240914200336_MS7yM | NL000C | 2024-09-18T12:01:37.245Z | 2024-09-19T12:18:26.894Z |
5111107 | 5111107 | 20240914195847_VlcjR | NL000C | 2024-09-18T12:01:33.417Z | 2024-09-19T12:18:26.675Z |
5110980 | 5110980 | 20240914193758_rHsnA | NL000C | 2024-09-18T12:01:17.671Z | 2024-09-19T12:18:25.222Z |
5110898 | 5110898 | 20240914192019_Zfj9F | NL000C | 2024-09-18T12:01:09.568Z | 2024-09-19T12:18:24.582Z |
5110832 | 5110832 | 20240914190140_lHdGy | NL000C | 2024-09-18T12:01:03.321Z | 2024-09-19T12:18:24.094Z |
5106918 | 5106918 | 20240913033834_Q8NT4 | NL000C | 2024-09-17T12:13:03.954Z | 2024-09-19T12:20:46.516Z |
5106913 | 5106913 | 20240913033812_3ZHcF | NL000C | 2024-09-17T12:13:03.820Z | 2024-09-19T12:20:46.515Z |
5106346 | 5106346 | 20240913032037_lvQyi | NL000C | 2024-09-17T12:12:50.777Z | 2024-09-19T12:20:45.978Z |
5106306 | 5106306 | 20240913031804_p70Da | NL000C | 2024-09-17T12:12:48.895Z | 2024-09-19T12:20:45.760Z |
5106270 | 5106270 | 20240913031648_y9XF3 | NL000C | 2024-09-17T12:12:47.768Z | 2024-09-19T12:20:45.738Z |
5106196 | 5106196 | 20240913031543_p23zy | NL000C | 2024-09-17T12:12:44.854Z | 2024-09-19T12:20:45.634Z |
5106057 | 5106057 | 20240913030740_8xrC3 | NL000C | 2024-09-17T12:12:39.651Z | 2024-09-19T12:20:45.393Z |
5106012 | 5106012 | 20240913030631_h3UBP | NL000C | 2024-09-17T12:12:37.706Z | 2024-09-19T12:20:45.141Z |
5105986 | 5105986 | 20240913030509_R2EMQ | NL000C | 2024-09-17T12:12:34.822Z | 2024-09-19T12:20:45.103Z |
5105714 | 5105714 | 20240913025533_38VWk | NL000C | 2024-09-17T12:12:27.423Z | 2024-09-19T12:20:44.834Z |
5105689 | 5105689 | 20240913025456_EPvtD | NL000C | 2024-09-17T12:12:26.225Z | 2024-09-19T12:20:44.793Z |
5105613 | 5105613 | 20240913025306_fY3iE | NL000C | 2024-09-17T12:12:23.558Z | 2024-09-19T12:20:44.726Z |
5105143 | 5105143 | 20240913023221_7w3a7 | NL000C | 2024-09-17T12:11:58.177Z | 2024-09-19T12:20:43.750Z |
5105115 | 5105115 | 20240913023138_864BY | NL000C | 2024-09-17T12:11:56.664Z | 2024-09-19T12:20:43.711Z |
5105089 | 5105089 | 20240913023005_SZnmf | NL000C | 2024-09-17T12:11:54.465Z | 2024-09-19T12:20:43.504Z |
5105065 | 5105065 | 20240913022848_6a7M7 | NL000C | 2024-09-17T12:11:52.113Z | 2024-09-19T12:20:43.460Z |
5104497 | 5104497 | 20240913021213_VcAEg | NL000C | 2024-09-17T12:11:37.234Z | 2024-09-19T12:20:41.554Z |
5104292 | 5104292 | 20240913020205_0ErMY | NL000C | 2024-09-17T12:11:31.768Z | 2024-09-19T12:20:41.331Z |
5104287 | 5104287 | 20240913020205_fYYyh | NL000C | 2024-09-17T12:11:31.677Z | 2024-09-19T12:20:41.314Z |
5103929 | 5103929 | 20240913014503_RWEvO | NL000C | 2024-09-17T12:11:19.061Z | 2024-09-19T12:20:40.679Z |
5103401 | 5103401 | 20240913012946_dnm7z | NL000C | 2024-09-17T12:10:56.415Z | 2024-09-19T12:20:40.158Z |
5102870 | 5102870 | 20240914015030_hdgkO | NL000C | 2024-09-17T12:07:41.449Z | 2024-09-19T12:19:55.997Z |
5102805 | 5102805 | 20240914014543_TEoYZ | NL000C | 2024-09-17T12:07:37.609Z | 2024-09-19T12:19:55.734Z |
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);