participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,262 rows where station_code = "DE0008" 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 |
---|---|---|---|---|---|
5484975 | 5484975 | 20241105035007_T8aZc | DE0008 | 2024-11-06T14:17:34.823Z | 2024-11-09T14:21:18.368Z |
5484765 | 5484765 | 20241105032646_02q2i | DE0008 | 2024-11-06T14:17:14.371Z | 2024-11-09T14:21:16.282Z |
5484685 | 5484685 | 20241105032013_E3ojP | DE0008 | 2024-11-06T14:17:09.928Z | 2024-11-09T14:21:15.851Z |
5484395 | 5484395 | 20241105024334_4bq0T | DE0008 | 2024-11-06T14:16:52.513Z | 2024-11-09T14:21:13.708Z |
5484339 | 5484339 | 20241105023617_oaBYV | DE0008 | 2024-11-06T14:16:49.477Z | 2024-11-09T14:21:13.372Z |
5484169 | 5484169 | 20241105021739_0ss2c | DE0008 | 2024-11-06T14:16:24.817Z | 2024-11-09T14:21:11.567Z |
5484110 | 5484110 | 20241105021022_q9N3t | DE0008 | 2024-11-06T14:16:18.067Z | 2024-11-09T14:21:10.940Z |
5484048 | 5484048 | 20241105020509_hRP4h | DE0008 | 2024-11-06T14:16:08.468Z | 2024-11-09T14:21:10.314Z |
5483686 | 5483686 | 20241105011936_hEaOh | DE0008 | 2024-11-06T14:15:35.948Z | 2024-11-09T14:21:06.778Z |
5483354 | 5483354 | 20241105003011_7cCpR | DE0008 | 2024-11-06T14:15:01.535Z | 2024-11-09T14:21:04.958Z |
5483124 | 5483124 | 20241105000059_n3FFC | DE0008 | 2024-11-06T14:14:41.141Z | 2024-11-09T14:21:03.596Z |
5482910 | 5482910 | 20241104233250_9T3YE | DE0008 | 2024-11-06T14:14:18.654Z | 2024-11-09T14:21:02.328Z |
5482777 | 5482777 | 20241104231319_nglW2 | DE0008 | 2024-11-06T14:13:57.208Z | 2024-11-09T14:21:01.468Z |
5481980 | 5481980 | 20241104203517_txdy4 | DE0008 | 2024-11-06T14:12:12.376Z | 2024-11-09T14:20:53.689Z |
5481695 | 5481695 | 20241104191707_oJkd8 | DE0008 | 2024-11-06T14:11:24.953Z | 2024-11-09T14:20:49.578Z |
5481678 | 5481678 | 20241104191448_SPOIo | DE0008 | 2024-11-06T14:11:19.591Z | 2024-11-09T14:20:49.364Z |
5481639 | 5481639 | 20241104185658_lHlOE | DE0008 | 2024-11-06T14:11:03.158Z | 2024-11-09T14:20:48.520Z |
5478637 | 5478637 | 20241104044718_bYBhK | DE0008 | 2024-11-05T14:18:36.606Z | 2024-11-09T14:22:30.392Z |
5477629 | 5477629 | 20241104021610_54BT1 | DE0008 | 2024-11-05T14:17:10.547Z | 2024-11-09T14:22:20.219Z |
5477473 | 5477473 | 20241104020021_iEvBe | DE0008 | 2024-11-05T14:16:56.121Z | 2024-11-09T14:22:18.145Z |
5476947 | 5476947 | 20241104004508_lDG2I | DE0008 | 2024-11-05T14:16:13.530Z | 2024-11-09T14:22:13.470Z |
5476400 | 5476400 | 20241103232039_LVW7v | DE0008 | 2024-11-05T14:15:15.394Z | 2024-11-09T14:22:09.112Z |
5443268 | 5443268 | 20241030042445_JT1EZ | DE0008 | 2024-11-01T12:20:25.336Z | 2024-11-07T14:26:50.374Z |
5442958 | 5442958 | 20241030030306_9V5Bs | DE0008 | 2024-11-01T12:20:14.101Z | 2024-11-07T14:26:49.033Z |
5442669 | 5442669 | 20241030021242_x1XQC | DE0008 | 2024-11-01T12:20:04.710Z | 2024-11-07T14:26:47.645Z |
5442638 | 5442638 | 20241030020753_r1Yh6 | DE0008 | 2024-11-01T12:20:03.848Z | 2024-11-07T14:26:47.244Z |
5442609 | 5442609 | 20241030020327_e1kVL | DE0008 | 2024-11-01T12:20:03.192Z | 2024-11-07T14:26:47.169Z |
5442514 | 5442514 | 20241030014248_d3oyB | DE0008 | 2024-11-01T12:19:57.007Z | 2024-11-07T14:26:46.847Z |
5442405 | 5442405 | 20241030012551_cDWvu | DE0008 | 2024-11-01T12:19:46.680Z | 2024-11-07T14:26:46.539Z |
5442335 | 5442335 | 20241030011527_XLONH | DE0008 | 2024-11-01T12:19:42.785Z | 2024-11-07T14:26:46.289Z |
5442211 | 5442211 | 20241030005530_qCvxu | DE0008 | 2024-11-01T12:19:33.857Z | 2024-11-07T14:26:45.608Z |
5442199 | 5442199 | 20241030005441_t6ASs | DE0008 | 2024-11-01T12:19:33.265Z | 2024-11-07T14:26:45.560Z |
5432594 | 5432594 | 20241029035740_HBKbM | DE0008 | 2024-10-31T12:21:28.026Z | 2024-11-06T14:27:28.149Z |
5432556 | 5432556 | 20241029035306_i42nx | DE0008 | 2024-10-31T12:21:26.946Z | 2024-11-06T14:27:27.825Z |
5432502 | 5432502 | 20241029034214_cBpve | DE0008 | 2024-10-31T12:21:24.902Z | 2024-11-06T14:27:27.654Z |
5432375 | 5432375 | 20241029032416_2BqgG | DE0008 | 2024-10-31T12:21:20.023Z | 2024-11-06T14:27:26.773Z |
5432238 | 5432238 | 20241029030010_ZlfGw | DE0008 | 2024-10-31T12:21:14.832Z | 2024-11-06T14:27:26.344Z |
5432194 | 5432194 | 20241029025400_HH2Du | DE0008 | 2024-10-31T12:21:11.513Z | 2024-11-06T14:27:26.210Z |
5432107 | 5432107 | 20241029024325_j3Nwn | DE0008 | 2024-10-31T12:21:02.713Z | 2024-11-06T14:27:25.971Z |
5432099 | 5432099 | 20241029024212_7dhpg | DE0008 | 2024-10-31T12:21:02.499Z | 2024-11-06T14:27:25.959Z |
5431979 | 5431979 | 20241029022534_lnHm7 | DE0008 | 2024-10-31T12:20:54.961Z | 2024-11-06T14:27:25.652Z |
5431876 | 5431876 | 20241029021038_KgYUu | DE0008 | 2024-10-31T12:20:46.138Z | 2024-11-06T14:27:25.146Z |
5431531 | 5431531 | 20241029012646_KinHp | DE0008 | 2024-10-31T12:20:18.915Z | 2024-11-06T14:27:24.004Z |
5420192 | 5420192 | 20241028020922_sY0ud | DE0008 | 2024-10-30T12:18:30.221Z | 2024-11-05T14:27:14.764Z |
5420135 | 5420135 | 20241028020132_EMwhi | DE0008 | 2024-10-30T12:18:23.952Z | 2024-11-05T14:27:14.645Z |
5419563 | 5419563 | 20241028001841_HUaPI | DE0008 | 2024-10-30T12:17:33.464Z | 2024-11-05T14:27:13.414Z |
5419419 | 5419419 | 20241027235726_sHVRU | DE0008 | 2024-10-30T12:17:26.280Z | 2024-11-05T14:27:13.041Z |
5419365 | 5419365 | 20241027234240_GRDfA | DE0008 | 2024-10-30T12:17:22.848Z | 2024-11-05T14:27:12.873Z |
5419290 | 5419290 | 20241027233052_gyL7w | DE0008 | 2024-10-30T12:17:19.192Z | 2024-11-05T14:27:12.700Z |
5419267 | 5419267 | 20241027232602_Knzm6 | DE0008 | 2024-10-30T12:17:17.850Z | 2024-11-05T14:27:12.672Z |
5419208 | 5419208 | 20241027231636_2bQ8b | DE0008 | 2024-10-30T12:17:14.870Z | 2024-11-05T14:27:12.523Z |
5418976 | 5418976 | 20241027223725_YNgYK | DE0008 | 2024-10-30T12:16:47.451Z | 2024-11-05T14:27:11.882Z |
5418890 | 5418890 | 20241027222053_dguzJ | DE0008 | 2024-10-30T12:16:28.812Z | 2024-11-05T14:27:11.665Z |
5418862 | 5418862 | 20241027221526_8SlFl | DE0008 | 2024-10-30T12:16:24.481Z | 2024-11-05T14:27:11.511Z |
5418727 | 5418727 | 20241027214436_o13gI | DE0008 | 2024-10-30T12:16:01.550Z | 2024-11-05T14:27:11.003Z |
5418680 | 5418680 | 20241027213426_vlVxB | DE0008 | 2024-10-30T12:15:59.032Z | 2024-11-05T14:27:10.916Z |
5418649 | 5418649 | 20241027212852_gZB20 | DE0008 | 2024-10-30T12:15:57.250Z | 2024-11-05T14:27:10.887Z |
5418598 | 5418598 | 20241027211755_Fv1tM | DE0008 | 2024-10-30T12:15:52.493Z | 2024-11-05T14:27:10.753Z |
5418482 | 5418482 | 20241027205541_5Q39X | DE0008 | 2024-10-30T12:15:44.018Z | 2024-11-05T14:27:10.160Z |
5401977 | 5401977 | 20241026181514_pjuOk | DE0008 | 2024-10-29T12:05:57.613Z | 2024-11-04T14:28:41.178Z |
5398246 | 5398246 | 20241026023702_vOFcY | DE0008 | 2024-10-28T12:19:07.284Z | 2024-11-03T14:27:35.721Z |
5397116 | 5397116 | 20241026010303_jidR7 | DE0008 | 2024-10-28T12:18:08.525Z | 2024-11-03T14:27:32.051Z |
5396228 | 5396228 | 20241025234940_uzcCL | DE0008 | 2024-10-28T12:17:28.114Z | 2024-11-03T14:27:28.961Z |
5395864 | 5395864 | 20241025231642_0tlQb | DE0008 | 2024-10-28T12:17:01.724Z | 2024-11-03T14:27:27.436Z |
5395745 | 5395745 | 20241025230727_bp3AU | DE0008 | 2024-10-28T12:16:45.140Z | 2024-11-03T14:27:26.620Z |
5395410 | 5395410 | 20241025224128_euJiM | DE0008 | 2024-10-28T12:16:13.180Z | 2024-11-03T14:27:25.458Z |
5394678 | 5394678 | 20241025210642_22Ypr | DE0008 | 2024-10-28T12:15:13.127Z | 2024-11-03T14:27:22.156Z |
5394441 | 5394441 | 20241025203541_229rt | DE0008 | 2024-10-28T12:14:41.084Z | 2024-11-03T14:27:21.243Z |
5388087 | 5388087 | 20241025040103_GGIFP | DE0008 | 2024-10-27T12:21:58.725Z | 2024-11-02T12:28:33.741Z |
5386743 | 5386743 | 20241025012025_fEiY3 | DE0008 | 2024-10-27T12:20:24.753Z | 2024-11-02T12:28:31.542Z |
5386290 | 5386290 | 20241025002230_U31uA | DE0008 | 2024-10-27T12:19:58.815Z | 2024-11-02T12:28:30.935Z |
5385862 | 5385862 | 20241024233733_guQil | DE0008 | 2024-10-27T12:19:30.726Z | 2024-11-02T12:28:30.331Z |
5385338 | 5385338 | 20241024222630_evG7V | DE0008 | 2024-10-27T12:18:45.717Z | 2024-11-02T12:28:29.572Z |
5385251 | 5385251 | 20241024221324_COgXU | DE0008 | 2024-10-27T12:18:37.937Z | 2024-11-02T12:28:29.361Z |
5385099 | 5385099 | 20241024215032_wEOJm | DE0008 | 2024-10-27T12:18:23.160Z | 2024-11-02T12:28:29.134Z |
5366853 | 5366853 | 20241023042646_IiKiZ | DE0008 | 2024-10-25T12:21:33.557Z | 2024-10-31T12:30:09.066Z |
5366493 | 5366493 | 20241023022052_83UBh | DE0008 | 2024-10-25T12:21:09.895Z | 2024-10-31T12:30:05.652Z |
5365883 | 5365883 | 20241023235428_FLWXI | DE0008 | 2024-10-25T12:18:09.678Z | 2024-11-01T12:26:56.473Z |
5364900 | 5364900 | 20241023230021_ChOAH | DE0008 | 2024-10-25T12:17:39.422Z | 2024-11-01T12:26:55.745Z |
5364619 | 5364619 | 20241023224225_urQ8D | DE0008 | 2024-10-25T12:17:26.427Z | 2024-11-01T12:26:55.243Z |
5363145 | 5363145 | 20241023203113_L1lXJ | DE0008 | 2024-10-25T12:15:32.637Z | 2024-11-01T12:26:52.880Z |
5362467 | 5362467 | 20241023193500_y3Qk7 | DE0008 | 2024-10-25T12:14:31.912Z | 2024-11-01T12:26:51.751Z |
5354085 | 5354085 | 20241023020320_3MVFl | DE0008 | 2024-10-24T12:20:14.074Z | 2024-10-31T12:30:05.351Z |
5353440 | 5353440 | 20241023012537_K4clj | DE0008 | 2024-10-24T12:19:42.718Z | 2024-10-31T12:30:04.255Z |
5351896 | 5351896 | 20241022235801_FS1gn | DE0008 | 2024-10-24T12:18:08.026Z | 2024-10-31T12:30:01.205Z |
5351814 | 5351814 | 20241022235447_OFi3W | DE0008 | 2024-10-24T12:18:02.137Z | 2024-10-31T12:30:00.956Z |
5351459 | 5351459 | 20241022232933_qxfaX | DE0008 | 2024-10-24T12:17:32.725Z | 2024-10-31T12:30:00.388Z |
5327868 | 5327868 | 20241020043613_xhX2s | DE0008 | 2024-10-21T12:13:15.795Z | 2024-10-28T12:26:47.393Z |
5327826 | 5327826 | 20241020040902_vjV4i | DE0008 | 2024-10-21T12:13:12.064Z | 2024-10-28T12:26:46.875Z |
5327733 | 5327733 | 20241020033703_2I3tH | DE0008 | 2024-10-21T12:12:59.170Z | 2024-10-28T12:26:46.557Z |
5327541 | 5327541 | 20241020023633_SqE5Y | DE0008 | 2024-10-21T12:12:18.107Z | 2024-10-28T12:26:45.546Z |
5321811 | 5321811 | 20241013030442_BryvO | DE0008 | 2024-10-19T12:24:02.307Z | 2024-10-21T12:24:18.180Z |
5319944 | 5319944 | 20241017221932_p3yTQ | DE0008 | 2024-10-19T12:04:09.999Z | 2024-10-26T12:27:53.707Z |
5312663 | 5312663 | 20241015042120_zaEmV | DE0008 | 2024-10-16T12:10:53.925Z | 2024-10-23T12:24:52.603Z |
5312626 | 5312626 | 20241015041012_wyvsN | DE0008 | 2024-10-16T12:10:51.772Z | 2024-10-23T12:24:52.493Z |
5312606 | 5312606 | 20241015040604_OWAgD | DE0008 | 2024-10-16T12:10:50.805Z | 2024-10-23T12:24:52.422Z |
5312508 | 5312508 | 20241015034731_UnGDk | DE0008 | 2024-10-16T12:10:44.775Z | 2024-10-23T12:24:51.453Z |
5312502 | 5312502 | 20241015034716_A5f3P | DE0008 | 2024-10-16T12:10:44.510Z | 2024-10-23T12:24:51.448Z |
5305847 | 5305847 | 20241013201931_381b3 | DE0008 | 2024-10-15T12:05:33.669Z | 2024-10-22T12:24:29.964Z |
5294437 | 5294437 | 20241012040957_4e7C4 | DE0008 | 2024-10-13T12:18:36.872Z | 2024-10-20T12:25:12.570Z |
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);