participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,872 rows where station_code = "DE0004" 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 |
---|---|---|---|---|---|
5485294 | 5485294 | 20241105044021_tTYjO | DE0004 | 2024-11-06T14:18:04.077Z | 2024-11-09T14:21:20.628Z |
5485262 | 5485262 | 20241105043212_HiwW3 | DE0004 | 2024-11-06T14:18:00.214Z | 2024-11-09T14:21:20.347Z |
5485241 | 5485241 | 20241105042843_SDRbw | DE0004 | 2024-11-06T14:17:58.176Z | 2024-11-09T14:21:20.197Z |
5484631 | 5484631 | 20241105031521_fuOdN | DE0004 | 2024-11-06T14:17:07.289Z | 2024-11-09T14:21:15.487Z |
5484441 | 5484441 | 20241105025037_2mAhY | DE0004 | 2024-11-06T14:16:55.065Z | 2024-11-09T14:21:14.116Z |
5484023 | 5484023 | 20241105015942_ciOEc | DE0004 | 2024-11-06T14:16:04.257Z | 2024-11-09T14:21:10.138Z |
5483800 | 5483800 | 20241105013248_Q4im4 | DE0004 | 2024-11-06T14:15:43.761Z | 2024-11-09T14:21:07.837Z |
5483656 | 5483656 | 20241105011605_2ZT39 | DE0004 | 2024-11-06T14:15:33.962Z | 2024-11-09T14:21:06.526Z |
5483570 | 5483570 | 20241105005909_XxwbB | DE0004 | 2024-11-06T14:15:29.553Z | 2024-11-09T14:21:06.009Z |
5483378 | 5483378 | 20241105003350_1FnVe | DE0004 | 2024-11-06T14:15:05.456Z | 2024-11-09T14:21:05.086Z |
5482960 | 5482960 | 20241104234149_0wZu2 | DE0004 | 2024-11-06T14:14:31.476Z | 2024-11-09T14:21:02.649Z |
5482651 | 5482651 | 20241104225557_7FO5W | DE0004 | 2024-11-06T14:13:31.159Z | 2024-11-09T14:21:00.761Z |
5482576 | 5482576 | 20241104224352_zCUSp | DE0004 | 2024-11-06T14:13:23.724Z | 2024-11-09T14:21:00.330Z |
5482493 | 5482493 | 20241104222957_c39sh | DE0004 | 2024-11-06T14:13:16.100Z | 2024-11-09T14:20:59.880Z |
5482384 | 5482384 | 20241104220238_Nnhwb | DE0004 | 2024-11-06T14:13:06.819Z | 2024-11-09T14:20:58.836Z |
5482272 | 5482272 | 20241104214145_xM2nd | DE0004 | 2024-11-06T14:12:46.536Z | 2024-11-09T14:20:57.569Z |
5482109 | 5482109 | 20241104210835_dpHj4 | DE0004 | 2024-11-06T14:12:24.130Z | 2024-11-09T14:20:55.388Z |
5482006 | 5482006 | 20241104204713_SMKng | DE0004 | 2024-11-06T14:12:14.388Z | 2024-11-09T14:20:54.171Z |
5481923 | 5481923 | 20241104202038_WIywT | DE0004 | 2024-11-06T14:11:51.004Z | 2024-11-09T14:20:52.667Z |
5481788 | 5481788 | 20241104194230_uLkQv | DE0004 | 2024-11-06T14:11:35.039Z | 2024-11-09T14:20:51.050Z |
5478601 | 5478601 | 20241104044150_CPEMv | DE0004 | 2024-11-05T14:18:33.260Z | 2024-11-09T14:22:30.153Z |
5477547 | 5477547 | 20241104020659_B38IF | DE0004 | 2024-11-05T14:17:02.834Z | 2024-11-09T14:22:18.835Z |
5477128 | 5477128 | 20241104010401_ReGa8 | DE0004 | 2024-11-05T14:16:25.130Z | 2024-11-09T14:22:14.521Z |
5477053 | 5477053 | 20241104005457_zB6gH | DE0004 | 2024-11-05T14:16:19.551Z | 2024-11-09T14:22:14.045Z |
5477030 | 5477030 | 20241104005354_nlnOl | DE0004 | 2024-11-05T14:16:18.302Z | 2024-11-09T14:22:13.885Z |
5476974 | 5476974 | 20241104004657_9hkMr | DE0004 | 2024-11-05T14:16:15.277Z | 2024-11-09T14:22:13.600Z |
5476649 | 5476649 | 20241104000148_jiLUa | DE0004 | 2024-11-05T14:15:48.763Z | 2024-11-09T14:22:11.371Z |
5475872 | 5475872 | 20241103214331_pGqDl | DE0004 | 2024-11-05T14:14:28.095Z | 2024-11-09T14:22:03.416Z |
5475812 | 5475812 | 20241103212947_9mf9B | DE0004 | 2024-11-05T14:14:15.404Z | 2024-11-09T14:22:02.534Z |
5474856 | 5474856 | 20241103182615_o2tVR | DE0004 | 2024-11-05T14:12:11.286Z | 2024-11-09T14:21:53.593Z |
5474736 | 5474736 | 20241103180744_9gP3t | DE0004 | 2024-11-05T14:11:47.978Z | 2024-11-09T14:21:51.243Z |
5470052 | 5470052 | 20241103051719_OQZp8 | DE0004 | 2024-11-04T14:17:40.788Z | 2024-11-09T14:23:04.913Z |
5467603 | 5467603 | 20241102220247_4oNVS | DE0004 | 2024-11-04T14:12:13.568Z | 2024-11-09T14:22:55.166Z |
5442404 | 5442404 | 20241030012551_cDWvu | DE0004 | 2024-11-01T12:19:46.680Z | 2024-11-07T14:26:46.539Z |
5441968 | 5441968 | 20241030001204_uaJ2g | DE0004 | 2024-11-01T12:19:15.169Z | 2024-11-07T14:26:44.445Z |
5431708 | 5431708 | 20241029015032_VlACG | DE0004 | 2024-10-31T12:20:33.768Z | 2024-11-06T14:27:24.549Z |
5419207 | 5419207 | 20241027231636_2bQ8b | DE0004 | 2024-10-30T12:17:14.870Z | 2024-11-05T14:27:12.523Z |
5418617 | 5418617 | 20241027212413_vRaBX | DE0004 | 2024-10-30T12:15:53.914Z | 2024-11-05T14:27:10.786Z |
5402499 | 5402499 | 20241026194551_U6elv | DE0004 | 2024-10-29T12:07:24.891Z | 2024-11-04T14:28:44.931Z |
5401866 | 5401866 | 20241026175359_2KWKB | DE0004 | 2024-10-29T12:05:37.570Z | 2024-11-04T14:28:40.344Z |
5401832 | 5401832 | 20241026174257_r9Gsj | DE0004 | 2024-10-29T12:05:27.206Z | 2024-11-04T14:28:39.734Z |
5398180 | 5398180 | 20241026023233_JMpGN | DE0004 | 2024-10-28T12:19:05.290Z | 2024-11-03T14:27:35.637Z |
5397979 | 5397979 | 20241026021248_9O8yG | DE0004 | 2024-10-28T12:18:54.483Z | 2024-11-03T14:27:34.729Z |
5396824 | 5396824 | 20241026003846_bJ2Uw | DE0004 | 2024-10-28T12:17:56.607Z | 2024-11-03T14:27:30.998Z |
5396490 | 5396490 | 20241026000723_5KZaT | DE0004 | 2024-10-28T12:17:46.013Z | 2024-11-03T14:27:29.997Z |
5395975 | 5395975 | 20241025232659_dKtar | DE0004 | 2024-10-28T12:17:09.066Z | 2024-11-03T14:27:27.851Z |
5395491 | 5395491 | 20241025224640_1hjR2 | DE0004 | 2024-10-28T12:16:20.615Z | 2024-11-03T14:27:25.631Z |
5393695 | 5393695 | 20241025183028_o1Ynr | DE0004 | 2024-10-28T12:13:02.101Z | 2024-11-03T14:27:17.441Z |
5388086 | 5388086 | 20241025040103_GGIFP | DE0004 | 2024-10-27T12:21:58.725Z | 2024-11-02T12:28:33.741Z |
5387838 | 5387838 | 20241025032838_r2iKV | DE0004 | 2024-10-27T12:21:45.714Z | 2024-11-02T12:28:33.333Z |
5386719 | 5386719 | 20241025011827_p3Lgc | DE0004 | 2024-10-27T12:20:21.530Z | 2024-11-02T12:28:31.517Z |
5386427 | 5386427 | 20241025003959_fwXyH | DE0004 | 2024-10-27T12:20:04.346Z | 2024-11-02T12:28:31.248Z |
5385934 | 5385934 | 20241024234458_DyN7M | DE0004 | 2024-10-27T12:19:38.463Z | 2024-11-02T12:28:30.503Z |
5385599 | 5385599 | 20241024230606_Qm5wQ | DE0004 | 2024-10-27T12:19:09.035Z | 2024-11-02T12:28:29.953Z |
5385292 | 5385292 | 20241024221837_IWYFT | DE0004 | 2024-10-27T12:18:42.284Z | 2024-11-02T12:28:29.532Z |
5384591 | 5384591 | 20241024202539_pPent | DE0004 | 2024-10-27T12:17:15.534Z | 2024-11-02T12:28:27.375Z |
5366228 | 5366228 | 20241024000956_5JY0f | DE0004 | 2024-10-25T12:18:19.626Z | 2024-11-01T12:26:56.800Z |
5366122 | 5366122 | 20241024000604_SnvCN | DE0004 | 2024-10-25T12:18:17.248Z | 2024-11-01T12:26:56.760Z |
5365002 | 5365002 | 20241023230956_eQ5Sb | DE0004 | 2024-10-25T12:17:43.471Z | 2024-11-01T12:26:55.825Z |
5363924 | 5363924 | 20241023215825_YoUrC | DE0004 | 2024-10-25T12:17:02.305Z | 2024-11-01T12:26:54.207Z |
5363651 | 5363651 | 20241023213123_5cIhp | DE0004 | 2024-10-25T12:16:32.295Z | 2024-11-01T12:26:53.481Z |
5362963 | 5362963 | 20241023201416_3pyU5 | DE0004 | 2024-10-25T12:15:19.904Z | 2024-11-01T12:26:52.699Z |
5355633 | 5355633 | 20241023035727_eB1pc | DE0004 | 2024-10-24T12:21:28.914Z | 2024-10-31T12:30:08.130Z |
5355382 | 5355382 | 20241023033622_K5MVt | DE0004 | 2024-10-24T12:21:17.450Z | 2024-10-31T12:30:07.576Z |
5355332 | 5355332 | 20241023033219_5VTBm | DE0004 | 2024-10-24T12:21:14.954Z | 2024-10-31T12:30:07.541Z |
5355295 | 5355295 | 20241023032815_HWJ16 | DE0004 | 2024-10-24T12:21:13.495Z | 2024-10-31T12:30:07.499Z |
5355074 | 5355074 | 20241023031314_yEyro | DE0004 | 2024-10-24T12:21:04.227Z | 2024-10-31T12:30:07.261Z |
5354944 | 5354944 | 20241023025824_JcvsV | DE0004 | 2024-10-24T12:20:58.568Z | 2024-10-31T12:30:06.785Z |
5354780 | 5354780 | 20241023024515_FYoYN | DE0004 | 2024-10-24T12:20:50.371Z | 2024-10-31T12:30:06.320Z |
5354741 | 5354741 | 20241023024317_YN5Nr | DE0004 | 2024-10-24T12:20:48.213Z | 2024-10-31T12:30:06.292Z |
5354307 | 5354307 | 20241023021928_YU2o7 | DE0004 | 2024-10-24T12:20:27.884Z | 2024-10-31T12:30:05.635Z |
5353556 | 5353556 | 20241023013105_AAyYB | DE0004 | 2024-10-24T12:19:46.548Z | 2024-10-31T12:30:04.365Z |
5353410 | 5353410 | 20241023012401_6sngT | DE0004 | 2024-10-24T12:19:41.710Z | 2024-10-31T12:30:04.230Z |
5353330 | 5353330 | 20241023012027_HCpve | DE0004 | 2024-10-24T12:19:39.364Z | 2024-10-31T12:30:04.147Z |
5353040 | 5353040 | 20241023010348_gTL4K | DE0004 | 2024-10-24T12:19:30.227Z | 2024-10-31T12:30:03.724Z |
5352961 | 5352961 | 20241023005803_gObHw | DE0004 | 2024-10-24T12:19:28.011Z | 2024-10-31T12:30:03.588Z |
5352431 | 5352431 | 20241023003223_1qNI9 | DE0004 | 2024-10-24T12:18:47.431Z | 2024-10-31T12:30:02.627Z |
5352411 | 5352411 | 20241023003148_Z0QxH | DE0004 | 2024-10-24T12:18:45.879Z | 2024-10-31T12:30:02.613Z |
5352063 | 5352063 | 20241023000830_8BefS | DE0004 | 2024-10-24T12:18:18.282Z | 2024-10-31T12:30:01.737Z |
5351930 | 5351930 | 20241023000029_5z1fE | DE0004 | 2024-10-24T12:18:09.711Z | 2024-10-31T12:30:01.265Z |
5351895 | 5351895 | 20241022235801_FS1gn | DE0004 | 2024-10-24T12:18:08.026Z | 2024-10-31T12:30:01.205Z |
5351737 | 5351737 | 20241022235015_U23W3 | DE0004 | 2024-10-24T12:17:55.507Z | 2024-10-31T12:30:00.852Z |
5351682 | 5351682 | 20241022234651_PhUfr | DE0004 | 2024-10-24T12:17:49.515Z | 2024-10-31T12:30:00.770Z |
5351491 | 5351491 | 20241022233341_0fZvW | DE0004 | 2024-10-24T12:17:36.201Z | 2024-10-31T12:30:00.469Z |
5351222 | 5351222 | 20241022230928_IhnSa | DE0004 | 2024-10-24T12:17:21.095Z | 2024-10-31T12:29:59.629Z |
5351024 | 5351024 | 20241022224845_2Csc6 | DE0004 | 2024-10-24T12:17:04.022Z | 2024-10-31T12:29:59.279Z |
5350946 | 5350946 | 20241022224416_Rht0f | DE0004 | 2024-10-24T12:16:54.539Z | 2024-10-31T12:29:59.132Z |
5350593 | 5350593 | 20241022220643_Yt0pY | DE0004 | 2024-10-24T12:16:03.030Z | 2024-10-31T12:29:58.527Z |
5350327 | 5350327 | 20241022213550_X3e3y | DE0004 | 2024-10-24T12:15:36.707Z | 2024-10-31T12:29:57.940Z |
5350198 | 5350198 | 20241022212053_EJ4y5 | DE0004 | 2024-10-24T12:15:28.166Z | 2024-10-31T12:29:57.529Z |
5350043 | 5350043 | 20241022210440_92bgT | DE0004 | 2024-10-24T12:15:09.570Z | 2024-10-31T12:29:57.225Z |
5349869 | 5349869 | 20241022204344_8BnRS | DE0004 | 2024-10-24T12:14:44.679Z | 2024-10-31T12:29:56.804Z |
5348289 | 5348289 | 20241022175432_ACaoR | DE0004 | 2024-10-24T12:10:48.707Z | 2024-10-31T12:29:51.895Z |
5327830 | 5327830 | 20241020041137_KxWNG | DE0004 | 2024-10-21T12:13:12.516Z | 2024-10-28T12:26:46.884Z |
5327730 | 5327730 | 20241020033652_3AMf3 | DE0004 | 2024-10-21T12:12:58.732Z | 2024-10-28T12:26:46.554Z |
5327706 | 5327706 | 20241020032959_WAbjA | DE0004 | 2024-10-21T12:12:52.956Z | 2024-10-28T12:26:46.458Z |
5327565 | 5327565 | 20241020024335_z3hNQ | DE0004 | 2024-10-21T12:12:21.152Z | 2024-10-28T12:26:45.613Z |
5321820 | 5321820 | 20241013034636_984QR | DE0004 | 2024-10-19T12:24:11.946Z | 2024-10-21T12:24:21.590Z |
5321818 | 5321818 | 20241013034441_3pmlm | DE0004 | 2024-10-19T12:24:11.632Z | 2024-10-21T12:24:20.855Z |
5321810 | 5321810 | 20241013030442_BryvO | DE0004 | 2024-10-19T12:24:02.306Z | 2024-10-21T12:24:18.180Z |
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);