participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,253 rows where station_code = "DE000R" 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 |
---|---|---|---|---|---|
5112631 | 5112631 | 20240914233716_d1b35 | DE000R | 2024-09-18T12:03:17.979Z | 2024-09-19T12:18:42.470Z |
5092101 | 5092101 | 20240912023645_5yBeI | DE000R | 2024-09-16T12:13:40.790Z | 2024-09-19T12:21:13.652Z |
5091527 | 5091527 | 20240912021223_f9itn | DE000R | 2024-09-16T12:13:09.417Z | 2024-09-19T12:21:13.131Z |
5085716 | 5085716 | 20240912214657_UOI8U | DE000R | 2024-09-16T12:04:48.974Z | 2024-09-19T12:20:29.556Z |
5052478 | 5052478 | 20240907205101_MLE9D | DE000R | 2024-09-13T12:15:10.367Z | 2024-09-16T12:21:05.756Z |
5033282 | 5033282 | 20240907024349_9IPiZ | DE000R | 2024-09-12T12:09:04.605Z | 2024-09-15T12:21:29.502Z |
5033187 | 5033187 | 20240907023440_33b2r | DE000R | 2024-09-12T12:08:55.606Z | 2024-09-15T12:21:29.170Z |
5032658 | 5032658 | 20240907012625_g3jH2 | DE000R | 2024-09-12T12:07:48.866Z | 2024-09-15T12:21:27.289Z |
5032240 | 5032240 | 20240907003307_YLYA5 | DE000R | 2024-09-12T12:06:47.557Z | 2024-09-15T12:21:25.688Z |
5031906 | 5031906 | 20240906233931_72QkS | DE000R | 2024-09-12T12:06:02.130Z | 2024-09-15T12:21:24.646Z |
5031813 | 5031813 | 20240906232508_2wv3L | DE000R | 2024-09-12T12:05:51.457Z | 2024-09-15T12:21:24.347Z |
5031098 | 5031098 | 20240906202608_9Snar | DE000R | 2024-09-12T12:03:54.436Z | 2024-09-15T12:21:21.417Z |
5030974 | 5030974 | 20240906194515_Vbgh4 | DE000R | 2024-09-12T12:03:37.173Z | 2024-09-15T12:21:20.580Z |
5008411 | 5008411 | 20240903234103_fYmR1 | DE000R | 2024-09-09T12:06:43.074Z | 2024-09-12T12:19:17.501Z |
4999937 | 4999937 | 20240902011340_53Lw2 | DE000R | 2024-09-08T12:14:53.002Z | 2024-09-10T12:19:23.974Z |
4998584 | 4998584 | 20240903032125_FrygG | DE000R | 2024-09-08T12:07:53.945Z | 2024-09-11T12:21:13.766Z |
4998264 | 4998264 | 20240903023622_bl861 | DE000R | 2024-09-08T12:07:26.599Z | 2024-09-11T12:21:11.812Z |
4998223 | 4998223 | 20240903023157_t8jnS | DE000R | 2024-09-08T12:07:24.077Z | 2024-09-11T12:21:11.492Z |
4990830 | 4990830 | 20240901011647_3KbbM | DE000R | 2024-09-07T12:11:11.751Z | 2024-09-09T12:26:47.338Z |
4989322 | 4989322 | 20240901231143_7aav2 | DE000R | 2024-09-07T12:08:47.735Z | 2024-09-10T12:19:17.355Z |
4954052 | 4954052 | 20240811025006_4fVtq | DE000R | 2024-09-03T12:18:06.489Z | 2024-09-06T12:28:47.575Z |
4953883 | 4953883 | 20240811024753_4DqSD | DE000R | 2024-09-03T12:18:03.246Z | 2024-09-06T12:28:41.700Z |
4952749 | 4952749 | 20240811022640_6l2XZ | DE000R | 2024-09-03T12:17:05.042Z | 2024-09-06T12:28:08.038Z |
4952682 | 4952682 | 20240811022531_PPYCQ | DE000R | 2024-09-03T12:17:04.132Z | 2024-09-06T12:28:07.074Z |
4950608 | 4950608 | 20240811020940_NecYB | DE000R | 2024-09-02T12:16:32.389Z | 2024-09-06T12:27:46.338Z |
4950143 | 4950143 | 20240811020111_bWOe9 | DE000R | 2024-09-02T12:16:09.473Z | 2024-09-06T12:27:41.295Z |
4949871 | 4949871 | 20240811015659_fCTwo | DE000R | 2024-09-02T12:15:58.898Z | 2024-09-06T12:27:38.496Z |
4949167 | 4949167 | 20240811014625_uJkeP | DE000R | 2024-09-02T12:15:39.345Z | 2024-09-06T12:27:30.500Z |
4947913 | 4947913 | 20240811012631_YrBw6 | DE000R | 2024-09-02T12:14:50.159Z | 2024-09-06T12:27:03.992Z |
4947796 | 4947796 | 20240811012456_Lfv15 | DE000R | 2024-09-02T12:14:47.826Z | 2024-09-06T12:27:02.534Z |
4946397 | 4946397 | 20240811010042_l9GAQ | DE000R | 2024-09-02T12:13:53.338Z | 2024-09-06T12:26:22.059Z |
4945526 | 4945526 | 20240811004719_EjzjR | DE000R | 2024-09-02T12:13:19.373Z | 2024-09-06T12:25:58.529Z |
4945369 | 4945369 | 20240811004501_bhkNy | DE000R | 2024-09-02T12:13:15.939Z | 2024-09-06T12:25:54.003Z |
4945296 | 4945296 | 20240811004403_fZivY | DE000R | 2024-09-02T12:13:14.173Z | 2024-09-06T12:25:51.454Z |
4945067 | 4945067 | 20240811004022_hsdfn | DE000R | 2024-09-02T12:13:08.631Z | 2024-09-06T12:25:45.958Z |
4943800 | 4943800 | 20240811001720_eUaP0 | DE000R | 2024-09-02T12:12:09.335Z | 2024-09-06T12:25:03.944Z |
4943768 | 4943768 | 20240811001704_QGMRh | DE000R | 2024-09-02T12:12:07.610Z | 2024-09-06T12:25:03.080Z |
4943594 | 4943594 | 20240811001408_Zxa2D | DE000R | 2024-09-02T12:11:59.558Z | 2024-09-06T12:24:59.097Z |
4943440 | 4943440 | 20240811001141_pITj0 | DE000R | 2024-09-02T12:11:50.746Z | 2024-09-06T12:24:49.521Z |
4943201 | 4943201 | 20240811000755_28QBU | DE000R | 2024-09-02T12:11:44.481Z | 2024-09-06T12:24:40.794Z |
4943105 | 4943105 | 20240811000542_laKNE | DE000R | 2024-09-02T12:11:42.313Z | 2024-09-06T12:24:38.804Z |
4942756 | 4942756 | 20240810235633_QzHsT | DE000R | 2024-09-02T12:11:32.631Z | 2024-09-06T12:24:29.209Z |
4942202 | 4942202 | 20240810234810_v5iHi | DE000R | 2024-09-02T12:11:05.633Z | 2024-09-06T12:24:09.924Z |
4942079 | 4942079 | 20240810234541_2UD9g | DE000R | 2024-09-02T12:11:02.044Z | 2024-09-06T12:24:06.052Z |
4941390 | 4941390 | 20240810233240_hLPW5 | DE000R | 2024-09-02T12:10:28.040Z | 2024-09-06T12:23:47.879Z |
4939354 | 4939354 | 20240810224333_z8g3F | DE000R | 2024-09-01T12:09:45.751Z | 2024-09-06T12:23:21.668Z |
4939285 | 4939285 | 20240810224154_5ZLVB | DE000R | 2024-09-01T12:09:43.264Z | 2024-09-06T12:23:20.487Z |
4939178 | 4939178 | 20240810223931_vy9r9 | DE000R | 2024-09-01T12:09:39.724Z | 2024-09-06T12:23:15.771Z |
4938838 | 4938838 | 20240810223014_F6p3k | DE000R | 2024-09-01T12:09:27.079Z | 2024-09-06T12:23:05.045Z |
4938738 | 4938738 | 20240810222739_ng1MP | DE000R | 2024-09-01T12:09:18.868Z | 2024-09-06T12:23:02.164Z |
4937371 | 4937371 | 20240810214742_Y8CYO | DE000R | 2024-09-01T12:08:12.042Z | 2024-09-06T12:22:10.204Z |
4936605 | 4936605 | 20240810212402_ltTI6 | DE000R | 2024-09-01T12:07:37.892Z | 2024-09-06T12:21:41.613Z |
4936492 | 4936492 | 20240810212022_aFGaT | DE000R | 2024-09-01T12:07:34.030Z | 2024-09-06T12:21:36.838Z |
4936344 | 4936344 | 20240810211312_svOb3 | DE000R | 2024-09-01T12:07:26.822Z | 2024-09-06T12:21:29.381Z |
4935770 | 4935770 | 20240810204318_gGyo7 | DE000R | 2024-09-01T12:06:52.284Z | 2024-09-06T12:20:56.192Z |
4935479 | 4935479 | 20240810202223_FNtEX | DE000R | 2024-09-01T12:06:32.307Z | 2024-09-06T12:20:41.311Z |
4935466 | 4935466 | 20240810202120_Q0gKM | DE000R | 2024-09-01T12:06:31.552Z | 2024-09-06T12:20:40.881Z |
4935255 | 4935255 | 20240810195912_RbW01 | DE000R | 2024-09-01T12:06:18.855Z | 2024-09-06T12:20:33.166Z |
4929034 | 4929034 | 20240810030116_TMgtq | DE000R | 2024-08-31T12:21:49.431Z | 2024-09-02T12:29:25.748Z |
4928238 | 4928238 | 20240810023414_lW87Y | DE000R | 2024-08-31T12:21:15.972Z | 2024-09-02T12:29:05.317Z |
4927471 | 4927471 | 20240810021400_7EWU7 | DE000R | 2024-08-31T12:20:39.050Z | 2024-09-02T12:28:36.167Z |
4926567 | 4926567 | 20240810015227_tI3WG | DE000R | 2024-08-31T12:19:43.962Z | 2024-09-02T12:27:55.573Z |
4926315 | 4926315 | 20240810014540_eeQUU | DE000R | 2024-08-31T12:19:34.632Z | 2024-09-02T12:27:45.209Z |
4926111 | 4926111 | 20240810014039_vOHqu | DE000R | 2024-08-31T12:19:29.511Z | 2024-09-02T12:27:41.353Z |
4922326 | 4922326 | 20240810011449_5UCd8 | DE000R | 2024-08-30T12:14:47.691Z | 2024-09-02T12:27:25.686Z |
4922233 | 4922233 | 20240810011302_Ql3J7 | DE000R | 2024-08-30T12:14:44.461Z | 2024-09-02T12:27:24.414Z |
4920622 | 4920622 | 20240810003556_L006E | DE000R | 2024-08-30T12:13:34.279Z | 2024-09-02T12:26:31.778Z |
4920216 | 4920216 | 20240810002745_KgGX5 | DE000R | 2024-08-30T12:13:13.348Z | 2024-09-02T12:26:17.064Z |
4920032 | 4920032 | 20240810002318_Kh4f2 | DE000R | 2024-08-30T12:13:05.906Z | 2024-09-02T12:26:10.481Z |
4919007 | 4919007 | 20240810000221_HZa0e | DE000R | 2024-08-30T12:12:29.023Z | 2024-09-02T12:25:40.034Z |
4918872 | 4918872 | 20240810000014_2Ag3h | DE000R | 2024-08-30T12:12:21.292Z | 2024-09-02T12:25:38.094Z |
4916804 | 4916804 | 20240809232337_WYJzB | DE000R | 2024-08-30T12:11:00.554Z | 2024-09-02T12:24:41.059Z |
4916481 | 4916481 | 20240809231540_WTbWa | DE000R | 2024-08-30T12:10:50.440Z | 2024-09-02T12:24:29.665Z |
4916308 | 4916308 | 20240809231027_5DDiF | DE000R | 2024-08-30T12:10:45.224Z | 2024-09-02T12:24:21.713Z |
4916079 | 4916079 | 20240809230536_dT5X2 | DE000R | 2024-08-30T12:10:31.162Z | 2024-09-02T12:24:12.076Z |
4915998 | 4915998 | 20240809230315_Y7uBq | DE000R | 2024-08-30T12:10:25.597Z | 2024-09-02T12:24:08.249Z |
4915449 | 4915449 | 20240809224844_4CAZK | DE000R | 2024-08-30T12:09:54.328Z | 2024-09-02T12:23:56.014Z |
4915245 | 4915245 | 20240809224421_XSHjR | DE000R | 2024-08-30T12:09:47.866Z | 2024-09-02T12:23:52.946Z |
4915023 | 4915023 | 20240809223539_lGnqM | DE000R | 2024-08-30T12:09:39.037Z | 2024-09-02T12:23:49.065Z |
4912687 | 4912687 | 20240809212350_7vciz | DE000R | 2024-08-29T12:08:39.766Z | 2024-09-02T12:22:37.196Z |
4912645 | 4912645 | 20240809212251_SIMq2 | DE000R | 2024-08-29T12:08:36.661Z | 2024-09-02T12:22:36.115Z |
4892452 | 4892452 | 20240809025407_tpH7F | DE000R | 2024-08-28T12:10:14.692Z | 2024-08-30T12:22:09.460Z |
4892401 | 4892401 | 20240809024240_3ypQW | DE000R | 2024-08-28T12:10:11.635Z | 2024-08-30T12:22:04.446Z |
4892089 | 4892089 | 20240809020417_yH0Ez | DE000R | 2024-08-28T12:09:47.598Z | 2024-08-30T12:21:38.995Z |
4892066 | 4892066 | 20240809020304_uuV6l | DE000R | 2024-08-28T12:09:46.169Z | 2024-08-30T12:21:37.487Z |
4891931 | 4891931 | 20240809014902_u1I4V | DE000R | 2024-08-28T12:09:38.736Z | 2024-08-30T12:21:33.087Z |
4891810 | 4891810 | 20240809013926_JCKZC | DE000R | 2024-08-28T12:09:26.790Z | 2024-08-30T12:21:25.655Z |
4891745 | 4891745 | 20240809013329_tyd3o | DE000R | 2024-08-28T12:09:20.626Z | 2024-08-30T12:21:23.784Z |
4891149 | 4891149 | 20240809003106_hltLT | DE000R | 2024-08-28T12:08:39.208Z | 2024-08-30T12:20:59.107Z |
4891130 | 4891130 | 20240809002915_vmzoi | DE000R | 2024-08-28T12:08:38.020Z | 2024-08-30T12:20:58.271Z |
4891011 | 4891011 | 20240809001558_LcCdI | DE000R | 2024-08-28T12:08:29.231Z | 2024-08-30T12:20:48.128Z |
4890975 | 4890975 | 20240809001223_wdP7i | DE000R | 2024-08-28T12:08:23.710Z | 2024-08-30T12:20:45.052Z |
4890870 | 4890870 | 20240808235859_OoCri | DE000R | 2024-08-28T12:08:15.470Z | 2024-08-30T12:20:37.557Z |
4890742 | 4890742 | 20240808234651_8LjEp | DE000R | 2024-08-28T12:08:06.680Z | 2024-08-30T12:20:27.715Z |
4890404 | 4890404 | 20240808230706_tfbgx | DE000R | 2024-08-28T12:07:39.988Z | 2024-08-30T12:20:14.800Z |
4890372 | 4890372 | 20240808230249_6BTv5 | DE000R | 2024-08-28T12:07:37.125Z | 2024-08-30T12:20:13.609Z |
4890152 | 4890152 | 20240808223826_WYP42 | DE000R | 2024-08-28T12:07:16.513Z | 2024-08-30T12:20:05.550Z |
4889861 | 4889861 | 20240808215645_6j5CV | DE000R | 2024-08-28T12:06:51.083Z | 2024-08-30T12:19:42.059Z |
4889821 | 4889821 | 20240808215332_oSY2f | DE000R | 2024-08-28T12:06:48.222Z | 2024-08-30T12:19:40.492Z |
4889790 | 4889790 | 20240808214905_wRIoF | DE000R | 2024-08-28T12:06:45.430Z | 2024-08-30T12:19:38.999Z |
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);