participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
172 rows where station_code = "DK0009" 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 |
---|---|---|---|---|---|
5119343 | 5119343 | 20240914022615_mOUGc | DK0009 | 2024-09-18T12:10:20.358Z | 2024-09-19T12:19:58.026Z |
5115822 | 5115822 | 20240915025428_X1MiS | DK0009 | 2024-09-18T12:06:26.085Z | 2024-09-19T12:19:07.439Z |
5114111 | 5114111 | 20240915012724_yAdUE | DK0009 | 2024-09-18T12:05:02.596Z | 2024-09-19T12:18:56.122Z |
5113958 | 5113958 | 20240915012108_Z05Xk | DK0009 | 2024-09-18T12:04:56.516Z | 2024-09-19T12:18:54.752Z |
5113917 | 5113917 | 20240915011835_0J2YK | DK0009 | 2024-09-18T12:04:55.309Z | 2024-09-19T12:18:54.272Z |
5113260 | 5113260 | 20240915003422_qtdrB | DK0009 | 2024-09-18T12:04:04.861Z | 2024-09-19T12:18:48.283Z |
5113118 | 5113118 | 20240915002246_j2mmR | DK0009 | 2024-09-18T12:03:57.112Z | 2024-09-19T12:18:47.153Z |
5112080 | 5112080 | 20240914220917_0u520 | DK0009 | 2024-09-18T12:02:46.420Z | 2024-09-19T12:18:37.975Z |
5111627 | 5111627 | 20240914205504_4NEmT | DK0009 | 2024-09-18T12:02:08.352Z | 2024-09-19T12:18:32.619Z |
5092721 | 5092721 | 20240912025516_rBfLq | DK0009 | 2024-09-16T12:14:02.555Z | 2024-09-19T12:21:14.436Z |
5092228 | 5092228 | 20240912024013_k925Q | DK0009 | 2024-09-16T12:13:44.099Z | 2024-09-19T12:21:13.710Z |
5091695 | 5091695 | 20240912021906_2DeAM | DK0009 | 2024-09-16T12:13:18.974Z | 2024-09-19T12:21:13.352Z |
5089755 | 5089755 | 20240912005622_2ebjH | DK0009 | 2024-09-16T12:11:40.949Z | 2024-09-19T12:21:10.455Z |
5085596 | 5085596 | 20240912213224_GH3Df | DK0009 | 2024-09-16T12:04:26.652Z | 2024-09-19T12:20:29.157Z |
5084914 | 5084914 | 20240912203240_V6cte | DK0009 | 2024-09-16T12:03:12.577Z | 2024-09-19T12:20:27.486Z |
5075763 | 5075763 | 20240912000540_Bp2a8 | DK0009 | 2024-09-15T12:10:11.954Z | 2024-09-19T12:21:09.480Z |
5074095 | 5074095 | 20240911221358_VuI33 | DK0009 | 2024-09-15T12:07:58.212Z | 2024-09-19T12:21:06.894Z |
5054250 | 5054250 | 20240908023157_FKXv3 | DK0009 | 2024-09-13T12:16:35.381Z | 2024-09-16T12:21:14.672Z |
5054159 | 5054159 | 20240908021704_wpyJ1 | DK0009 | 2024-09-13T12:16:31.673Z | 2024-09-16T12:21:14.169Z |
5054019 | 5054019 | 20240908020111_3MWRE | DK0009 | 2024-09-13T12:16:26.624Z | 2024-09-16T12:21:13.763Z |
5039483 | 5039483 | 20240906010948_BZKSx | DK0009 | 2024-09-12T12:15:34.974Z | 2024-09-14T12:23:02.420Z |
5038532 | 5038532 | 20240905204604_5FrVe | DK0009 | 2024-09-12T12:14:45.754Z | 2024-09-14T12:22:56.360Z |
5038397 | 5038397 | 20240905195641_hHMNM | DK0009 | 2024-09-12T12:14:38.123Z | 2024-09-14T12:22:55.938Z |
5032813 | 5032813 | 20240907015106_xx334 | DK0009 | 2024-09-12T12:08:06.335Z | 2024-09-15T12:21:27.974Z |
5032143 | 5032143 | 20240907001935_th6dl | DK0009 | 2024-09-12T12:06:37.267Z | 2024-09-15T12:21:25.346Z |
5031926 | 5031926 | 20240906234246_oO2MP | DK0009 | 2024-09-12T12:06:06.185Z | 2024-09-15T12:21:24.691Z |
5031852 | 5031852 | 20240906233201_H1uP8 | DK0009 | 2024-09-12T12:05:56.558Z | 2024-09-15T12:21:24.434Z |
5031168 | 5031168 | 20240906204404_ruyrw | DK0009 | 2024-09-12T12:04:06.493Z | 2024-09-15T12:21:21.617Z |
5026174 | 5026174 | 20240905023124_bzcwh | DK0009 | 2024-09-11T12:12:01.342Z | 2024-09-13T12:19:57.063Z |
5026167 | 5026167 | 20240905023000_uPU9R | DK0009 | 2024-09-11T12:12:00.773Z | 2024-09-13T12:19:57.015Z |
5025901 | 5025901 | 20240905013728_tpDVq | DK0009 | 2024-09-11T12:11:26.842Z | 2024-09-13T12:19:56.119Z |
5025839 | 5025839 | 20240905012640_GGe3H | DK0009 | 2024-09-11T12:11:13.022Z | 2024-09-13T12:19:55.884Z |
5025422 | 5025422 | 20240906015833_SdxJ0 | DK0009 | 2024-09-11T12:06:29.411Z | 2024-09-14T12:23:04.550Z |
5025135 | 5025135 | 20240906010948_j3REX | DK0009 | 2024-09-11T12:05:41.985Z | 2024-09-14T12:23:02.416Z |
5020611 | 5020611 | 20240905023124_RenBH | DK0009 | 2024-09-10T12:14:48.526Z | 2024-09-10T12:16:55.194Z |
5020601 | 5020601 | 20240905023000_0Pz1B | DK0009 | 2024-09-10T12:14:47.939Z | 2024-09-10T12:16:55.191Z |
5020343 | 5020343 | 20240905013728_rTsW5 | DK0009 | 2024-09-10T12:14:20.476Z | 2024-09-10T12:16:55.130Z |
5020275 | 5020275 | 20240905012640_o6u6i | DK0009 | 2024-09-10T12:14:12.990Z | 2024-09-10T12:16:55.115Z |
5020017 | 5020017 | 20240905003849_GtkTs | DK0009 | 2024-09-10T12:13:50.017Z | 2024-09-13T12:19:54.808Z |
5020013 | 5020013 | 20240905003702_mIWkF | DK0009 | 2024-09-10T12:13:49.735Z | 2024-09-13T12:19:54.805Z |
5019979 | 5019979 | 20240905003108_htVAl | DK0009 | 2024-09-10T12:13:47.189Z | 2024-09-13T12:19:54.726Z |
5019488 | 5019488 | 20240904225906_7AhEv | DK0009 | 2024-09-10T12:12:49.145Z | 2024-09-13T12:19:52.236Z |
5019345 | 5019345 | 20240904223620_TfWrI | DK0009 | 2024-09-10T12:12:39.024Z | 2024-09-13T12:19:51.496Z |
5019306 | 5019306 | 20240904222636_1z3oi | DK0009 | 2024-09-10T12:12:35.179Z | 2024-09-13T12:19:51.352Z |
5019184 | 5019184 | 20240904220441_3Knte | DK0009 | 2024-09-10T12:12:18.126Z | 2024-09-13T12:19:50.869Z |
5019088 | 5019088 | 20240904214629_QLjTY | DK0009 | 2024-09-10T12:12:04.964Z | 2024-09-13T12:19:50.386Z |
5018710 | 5018710 | 20240904194725_BmwSi | DK0009 | 2024-09-10T12:11:20.781Z | 2024-09-13T12:19:48.563Z |
5006855 | 5006855 | 20240903191252_5K5QT | DK0009 | 2024-09-09T12:05:08.879Z | 2024-09-12T12:19:10.392Z |
5000262 | 5000262 | 20240902015241_ItxJM | DK0009 | 2024-09-08T12:15:17.826Z | 2024-09-10T12:19:26.458Z |
4999643 | 4999643 | 20240902004348_rJ7Sa | DK0009 | 2024-09-08T12:14:39.053Z | 2024-09-10T12:19:21.386Z |
4999571 | 4999571 | 20240902003631_0qg7p | DK0009 | 2024-09-08T12:14:35.577Z | 2024-09-10T12:19:20.722Z |
4997638 | 4997638 | 20240903005539_u2R9i | DK0009 | 2024-09-08T12:06:32.531Z | 2024-09-11T12:21:06.924Z |
4997627 | 4997627 | 20240903005356_XFuul | DK0009 | 2024-09-08T12:06:31.494Z | 2024-09-11T12:21:06.657Z |
4997554 | 4997554 | 20240903004020_W4CW3 | DK0009 | 2024-09-08T12:06:26.137Z | 2024-09-11T12:21:05.609Z |
4997356 | 4997356 | 20240902235848_x2V6s | DK0009 | 2024-09-08T12:06:07.232Z | 2024-09-11T12:21:03.636Z |
4997078 | 4997078 | 20240902230036_Ba2VX | DK0009 | 2024-09-08T12:05:44.633Z | 2024-09-11T12:21:01.014Z |
4997034 | 4997034 | 20240902223948_Q25QG | DK0009 | 2024-09-08T12:05:37.434Z | 2024-09-11T12:21:00.423Z |
4990732 | 4990732 | 20240901010243_3kidy | DK0009 | 2024-09-07T12:10:59.633Z | 2024-09-09T12:26:34.211Z |
4990613 | 4990613 | 20240901004508_EzKCI | DK0009 | 2024-09-07T12:10:50.210Z | 2024-09-09T12:26:25.087Z |
4989776 | 4989776 | 20240831222800_8k2Br | DK0009 | 2024-09-07T12:09:31.025Z | 2024-09-09T12:25:46.588Z |
4989533 | 4989533 | 20240901234743_UhyqN | DK0009 | 2024-09-07T12:09:06.069Z | 2024-09-10T12:19:17.853Z |
4988979 | 4988979 | 20240901221356_TsWBx | DK0009 | 2024-09-07T12:08:17.573Z | 2024-09-10T12:19:16.277Z |
4881944 | 4881944 | 20240807015714_PeL3n | DK0009 | 2024-08-20T12:14:23.515Z | 2024-08-27T12:15:24.411Z |
4881649 | 4881649 | 20240807014941_IZmJC | DK0009 | 2024-08-20T12:14:17.321Z | 2024-08-27T12:15:19.039Z |
4879964 | 4879964 | 20240807010756_2YY0K | DK0009 | 2024-08-20T12:13:15.009Z | 2024-08-27T12:14:26.497Z |
4879801 | 4879801 | 20240807010339_a3hv2 | DK0009 | 2024-08-20T12:13:01.612Z | 2024-08-27T12:14:23.251Z |
4879377 | 4879377 | 20240807005311_0U5c3 | DK0009 | 2024-08-20T12:12:50.091Z | 2024-08-27T12:14:11.986Z |
4879366 | 4879366 | 20240807005236_oRJ3r | DK0009 | 2024-08-20T12:12:49.657Z | 2024-08-27T12:14:11.602Z |
4878116 | 4878116 | 20240807002048_ci8e1 | DK0009 | 2024-08-19T12:14:05.593Z | 2024-08-27T12:13:36.624Z |
4853313 | 4853313 | 20240805224819_q5KhS | DK0009 | 2024-08-17T12:17:13.717Z | 2024-08-19T12:24:52.486Z |
4852989 | 4852989 | 20240805222944_bnlMC | DK0009 | 2024-08-17T12:16:50.503Z | 2024-08-19T12:24:36.826Z |
4806156 | 4806156 | 20240803013227_73y3U | DK0009 | 2024-08-12T12:18:29.299Z | 2024-08-13T12:17:32.316Z |
4806035 | 4806035 | 20240803011831_NwfoL | DK0009 | 2024-08-12T12:18:20.234Z | 2024-08-13T12:17:29.831Z |
4806014 | 4806014 | 20240803011531_STEfj | DK0009 | 2024-08-12T12:18:19.030Z | 2024-08-13T12:17:29.286Z |
4805117 | 4805117 | 20240802233808_IC3Pz | DK0009 | 2024-08-12T12:17:25.364Z | 2024-08-13T12:17:09.201Z |
4805083 | 4805083 | 20240802233528_Q3FB2 | DK0009 | 2024-08-12T12:17:22.582Z | 2024-08-13T12:17:08.738Z |
4804963 | 4804963 | 20240802232500_1YoK1 | DK0009 | 2024-08-12T12:17:14.087Z | 2024-08-13T12:17:05.349Z |
4804923 | 4804923 | 20240802232021_ApqaP | DK0009 | 2024-08-12T12:17:11.625Z | 2024-08-13T12:17:04.677Z |
4804037 | 4804037 | 20240802215401_rRCIi | DK0009 | 2024-08-12T12:15:54.048Z | 2024-08-13T12:16:50.990Z |
4804009 | 4804009 | 20240802215156_dgVG2 | DK0009 | 2024-08-12T12:15:50.005Z | 2024-08-13T12:16:50.511Z |
4803658 | 4803658 | 20240802212433_nr4tW | DK0009 | 2024-08-12T12:15:30.717Z | 2024-08-13T12:16:44.658Z |
4803618 | 4803618 | 20240802212155_vjgOx | DK0009 | 2024-08-12T12:15:28.182Z | 2024-08-13T12:16:43.246Z |
4803569 | 4803569 | 20240802211753_C3anE | DK0009 | 2024-08-12T12:15:25.594Z | 2024-08-13T12:16:42.305Z |
4783447 | 4783447 | 20240801222858_472eD | DK0009 | 2024-08-10T12:13:53.170Z | 2024-08-11T12:14:11.807Z |
4779759 | 4779759 | 20240801011203_tPieV | DK0009 | 2024-08-07T12:14:40.591Z | 2024-08-10T12:21:38.837Z |
4779275 | 4779275 | 20240801002529_T1pvv | DK0009 | 2024-08-07T12:14:22.434Z | 2024-08-10T12:21:25.616Z |
4779243 | 4779243 | 20240801002234_pK9tt | DK0009 | 2024-08-07T12:14:21.697Z | 2024-08-10T12:21:25.091Z |
4778699 | 4778699 | 20240731232839_HVMMz | DK0009 | 2024-08-07T12:13:56.586Z | 2024-08-10T12:21:12.545Z |
4778670 | 4778670 | 20240731232518_UED1x | DK0009 | 2024-08-07T12:13:55.181Z | 2024-08-10T12:21:11.705Z |
4778592 | 4778592 | 20240731231416_c1UWf | DK0009 | 2024-08-07T12:13:51.902Z | 2024-08-10T12:21:09.431Z |
4778472 | 4778472 | 20240731225949_siTNx | DK0009 | 2024-08-07T12:13:46.248Z | 2024-08-10T12:21:06.068Z |
4778293 | 4778293 | 20240731223609_evKug | DK0009 | 2024-08-07T12:13:39.564Z | 2024-08-10T12:21:03.367Z |
4771324 | 4771324 | 20240731010652_qY2tU | DK0009 | 2024-08-06T12:14:13.635Z | 2024-08-08T12:25:21.502Z |
4771051 | 4771051 | 20240731005254_BvpDh | DK0009 | 2024-08-06T12:14:08.806Z | 2024-08-08T12:25:17.986Z |
4770260 | 4770260 | 20240731221939_YjOAs | DK0009 | 2024-08-06T12:11:42.889Z | 2024-08-10T12:20:59.111Z |
4770188 | 4770188 | 20240731221056_QGsp0 | DK0009 | 2024-08-06T12:11:37.329Z | 2024-08-10T12:20:56.505Z |
4770033 | 4770033 | 20240731215222_sUme9 | DK0009 | 2024-08-06T12:11:29.277Z | 2024-08-10T12:20:52.095Z |
4769567 | 4769567 | 20240731205931_1chg9 | DK0009 | 2024-08-06T12:11:00.476Z | 2024-08-10T12:20:39.784Z |
4761703 | 4761703 | 20240731012848_IjfGh | DK0009 | 2024-08-06T12:00:55.345Z | 2024-08-10T12:17:25.548Z |
4761676 | 4761676 | 20240731012640_llqKE | DK0009 | 2024-08-06T12:00:50.896Z | 2024-08-10T12:17:24.603Z |
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);