participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,111 rows where station_code = "NL000Q" 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 |
---|---|---|---|---|---|
5127986 | 5127986 | 20240917001647_96sD3 | NL000Q | 2024-09-19T12:09:52.605Z | 2024-09-19T12:09:52.605Z |
5127944 | 5127944 | 20240917000555_7kSbZ | NL000Q | 2024-09-19T12:09:47.430Z | 2024-09-19T12:09:47.430Z |
5127186 | 5127186 | 20240916204548_YJYVL | NL000Q | 2024-09-19T12:08:27.351Z | 2024-09-19T12:08:27.351Z |
5127164 | 5127164 | 20240916203754_GatFc | NL000Q | 2024-09-19T12:08:22.504Z | 2024-09-19T12:08:22.504Z |
5126943 | 5126943 | 20240916195848_pCFOg | NL000Q | 2024-09-19T12:07:46.207Z | 2024-09-19T12:07:46.207Z |
5121080 | 5121080 | 20240914035138_TPfEl | NL000Q | 2024-09-18T12:10:50.527Z | 2024-09-19T12:20:01.287Z |
5121022 | 5121022 | 20240914034817_JE0jN | NL000Q | 2024-09-18T12:10:49.512Z | 2024-09-19T12:20:01.164Z |
5120983 | 5120983 | 20240914034301_xFFKb | NL000Q | 2024-09-18T12:10:48.992Z | 2024-09-19T12:20:01.081Z |
5120745 | 5120745 | 20240914033326_sPBhJ | NL000Q | 2024-09-18T12:10:46.462Z | 2024-09-19T12:20:00.837Z |
5120709 | 5120709 | 20240914033248_cvgVK | NL000Q | 2024-09-18T12:10:46.018Z | 2024-09-19T12:20:00.782Z |
5120412 | 5120412 | 20240914032001_TD9ue | NL000Q | 2024-09-18T12:10:39.362Z | 2024-09-19T12:20:00.110Z |
5119814 | 5119814 | 20240914025015_aoAAh | NL000Q | 2024-09-18T12:10:27.658Z | 2024-09-19T12:19:58.973Z |
5116284 | 5116284 | 20240915032007_pQbk2 | NL000Q | 2024-09-18T12:06:54.654Z | 2024-09-19T12:19:10.241Z |
5116258 | 5116258 | 20240915031855_FXFzg | NL000Q | 2024-09-18T12:06:51.540Z | 2024-09-19T12:19:09.990Z |
5116104 | 5116104 | 20240915030859_mJL9F | NL000Q | 2024-09-18T12:06:40.270Z | 2024-09-19T12:19:08.730Z |
5115785 | 5115785 | 20240915025336_393oP | NL000Q | 2024-09-18T12:06:23.988Z | 2024-09-19T12:19:07.352Z |
5115643 | 5115643 | 20240915024658_cR5HB | NL000Q | 2024-09-18T12:06:20.081Z | 2024-09-19T12:19:05.887Z |
5115471 | 5115471 | 20240915024039_Rj2ao | NL000Q | 2024-09-18T12:06:15.738Z | 2024-09-19T12:19:04.988Z |
5115209 | 5115209 | 20240915022722_49TUe | NL000Q | 2024-09-18T12:06:06.338Z | 2024-09-19T12:19:03.002Z |
5114591 | 5114591 | 20240915015112_u049m | NL000Q | 2024-09-18T12:05:23.326Z | 2024-09-19T12:18:59.014Z |
5114519 | 5114519 | 20240915014554_gwQjF | NL000Q | 2024-09-18T12:05:20.308Z | 2024-09-19T12:18:58.648Z |
5113880 | 5113880 | 20240915011658_z6hId | NL000Q | 2024-09-18T12:04:54.367Z | 2024-09-19T12:18:54.015Z |
5113440 | 5113440 | 20240915004946_ibZ97 | NL000Q | 2024-09-18T12:04:17.279Z | 2024-09-19T12:18:49.129Z |
5112389 | 5112389 | 20240914230650_NwTjN | NL000Q | 2024-09-18T12:03:02.303Z | 2024-09-19T12:18:40.802Z |
5112289 | 5112289 | 20240914225106_wZgfh | NL000Q | 2024-09-18T12:02:58.448Z | 2024-09-19T12:18:40.373Z |
5111861 | 5111861 | 20240914212454_hVs9E | NL000Q | 2024-09-18T12:02:23.822Z | 2024-09-19T12:18:34.702Z |
5111780 | 5111780 | 20240914211600_8dG4M | NL000Q | 2024-09-18T12:02:16.544Z | 2024-09-19T12:18:33.956Z |
5111351 | 5111351 | 20240914202602_DYYpQ | NL000Q | 2024-09-18T12:01:51.560Z | 2024-09-19T12:18:29.299Z |
5111271 | 5111271 | 20240914201510_Ga6Id | NL000Q | 2024-09-18T12:01:46.358Z | 2024-09-19T12:18:28.269Z |
5111212 | 5111212 | 20240914201038_DK8LV | NL000Q | 2024-09-18T12:01:43.320Z | 2024-09-19T12:18:27.414Z |
5111181 | 5111181 | 20240914200946_Zebp7 | NL000Q | 2024-09-18T12:01:42.206Z | 2024-09-19T12:18:27.277Z |
5111130 | 5111130 | 20240914200336_MS7yM | NL000Q | 2024-09-18T12:01:37.245Z | 2024-09-19T12:18:26.894Z |
5110981 | 5110981 | 20240914193758_rHsnA | NL000Q | 2024-09-18T12:01:17.671Z | 2024-09-19T12:18:25.222Z |
5110874 | 5110874 | 20240914191710_KkI5m | NL000Q | 2024-09-18T12:01:07.477Z | 2024-09-19T12:18:24.424Z |
5106307 | 5106307 | 20240913031804_p70Da | NL000Q | 2024-09-17T12:12:48.895Z | 2024-09-19T12:20:45.760Z |
5106014 | 5106014 | 20240913030631_h3UBP | NL000Q | 2024-09-17T12:12:37.706Z | 2024-09-19T12:20:45.141Z |
5105144 | 5105144 | 20240913023221_7w3a7 | NL000Q | 2024-09-17T12:11:58.177Z | 2024-09-19T12:20:43.750Z |
5105066 | 5105066 | 20240913022848_6a7M7 | NL000Q | 2024-09-17T12:11:52.113Z | 2024-09-19T12:20:43.460Z |
5105054 | 5105054 | 20240913022825_LeKnw | NL000Q | 2024-09-17T12:11:51.163Z | 2024-09-19T12:20:43.437Z |
5104527 | 5104527 | 20240913021425_n0i2m | NL000Q | 2024-09-17T12:11:38.149Z | 2024-09-19T12:20:41.642Z |
5103798 | 5103798 | 20240913014026_7ArUt | NL000Q | 2024-09-17T12:11:10.924Z | 2024-09-19T12:20:40.566Z |
5102665 | 5102665 | 20240914013655_Q4aEV | NL000Q | 2024-09-17T12:07:30.178Z | 2024-09-19T12:19:55.365Z |
5102340 | 5102340 | 20240914012103_KwMxw | NL000Q | 2024-09-17T12:07:03.051Z | 2024-09-19T12:19:53.847Z |
5102311 | 5102311 | 20240914011724_tZwOf | NL000Q | 2024-09-17T12:06:59.915Z | 2024-09-19T12:19:53.405Z |
5102187 | 5102187 | 20240914011127_1wAby | NL000Q | 2024-09-17T12:06:53.755Z | 2024-09-19T12:19:52.724Z |
5102017 | 5102017 | 20240914010003_aSl9a | NL000Q | 2024-09-17T12:06:41.147Z | 2024-09-19T12:19:52.206Z |
5099573 | 5099573 | 20240913213713_bkiaG | NL000Q | 2024-09-17T12:03:10.716Z | 2024-09-19T12:19:45.328Z |
5099458 | 5099458 | 20240913211653_k9v3M | NL000Q | 2024-09-17T12:02:58.985Z | 2024-09-19T12:19:44.978Z |
5099445 | 5099445 | 20240913211450_a5DpI | NL000Q | 2024-09-17T12:02:57.706Z | 2024-09-19T12:19:44.919Z |
5099331 | 5099331 | 20240913210011_AlUPR | NL000Q | 2024-09-17T12:02:46.906Z | 2024-09-19T12:19:44.503Z |
5099079 | 5099079 | 20240913201901_24845 | NL000Q | 2024-09-17T12:02:17.949Z | 2024-09-19T12:19:43.357Z |
5098975 | 5098975 | 20240913200118_GkvFj | NL000Q | 2024-09-17T12:02:06.160Z | 2024-09-19T12:19:42.819Z |
5097980 | 5097980 | 20240913011120_B51r2 | NL000Q | 2024-09-16T12:17:17.738Z | 2024-09-19T12:20:39.243Z |
5097811 | 5097811 | 20240913010503_a09Bz | NL000Q | 2024-09-16T12:17:15.202Z | 2024-09-19T12:20:39.024Z |
5097593 | 5097593 | 20240913005611_I2vF8 | NL000Q | 2024-09-16T12:17:13.558Z | 2024-09-19T12:20:38.741Z |
5094202 | 5094202 | 20240912035242_IM6Gp | NL000Q | 2024-09-16T12:14:39.139Z | 2024-09-19T12:21:16.017Z |
5093792 | 5093792 | 20240912033547_krhUy | NL000Q | 2024-09-16T12:14:25.460Z | 2024-09-19T12:21:15.654Z |
5093482 | 5093482 | 20240912032348_nFmj9 | NL000Q | 2024-09-16T12:14:18.391Z | 2024-09-19T12:21:15.367Z |
5093267 | 5093267 | 20240912031536_tdyKp | NL000Q | 2024-09-16T12:14:13.919Z | 2024-09-19T12:21:15.073Z |
5093051 | 5093051 | 20240912030944_OR2dx | NL000Q | 2024-09-16T12:14:10.957Z | 2024-09-19T12:21:14.919Z |
5092454 | 5092454 | 20240912024634_WhyaY | NL000Q | 2024-09-16T12:13:56.797Z | 2024-09-19T12:21:14.117Z |
5092267 | 5092267 | 20240912024122_fTrl2 | NL000Q | 2024-09-16T12:13:45.211Z | 2024-09-19T12:21:13.755Z |
5092159 | 5092159 | 20240912023912_1zI9W | NL000Q | 2024-09-16T12:13:42.745Z | 2024-09-19T12:21:13.678Z |
5091890 | 5091890 | 20240912022653_qJ5Ai | NL000Q | 2024-09-16T12:13:29.757Z | 2024-09-19T12:21:13.458Z |
5091715 | 5091715 | 20240912021928_ZC3JI | NL000Q | 2024-09-16T12:13:19.772Z | 2024-09-19T12:21:13.359Z |
5091375 | 5091375 | 20240912020714_jUwlz | NL000Q | 2024-09-16T12:13:03.535Z | 2024-09-19T12:21:12.962Z |
5090959 | 5090959 | 20240912015455_2tRIV | NL000Q | 2024-09-16T12:12:45.854Z | 2024-09-19T12:21:12.434Z |
5090207 | 5090207 | 20240912011516_lRNxN | NL000Q | 2024-09-16T12:12:06.885Z | 2024-09-19T12:21:11.067Z |
5089498 | 5089498 | 20240912004615_X9Kmc | NL000Q | 2024-09-16T12:11:27.226Z | 2024-09-19T12:21:09.994Z |
5089294 | 5089294 | 20240912003356_YPr0u | NL000Q | 2024-09-16T12:11:19.521Z | 2024-09-19T12:21:09.880Z |
5089251 | 5089251 | 20240912003015_KCjmG | NL000Q | 2024-09-16T12:11:18.513Z | 2024-09-19T12:21:09.842Z |
5089197 | 5089197 | 20240912002844_1HUb3 | NL000Q | 2024-09-16T12:11:17.114Z | 2024-09-19T12:21:09.819Z |
5089129 | 5089129 | 20240912002714_f2w0o | NL000Q | 2024-09-16T12:11:15.750Z | 2024-09-19T12:21:09.763Z |
5089039 | 5089039 | 20240912002247_8AS9v | NL000Q | 2024-09-16T12:11:13.544Z | 2024-09-19T12:21:09.710Z |
5089006 | 5089006 | 20240912001804_AU2wa | NL000Q | 2024-09-16T12:11:11.532Z | 2024-09-19T12:21:09.648Z |
5088023 | 5088023 | 20240912235356_EvYgs | NL000Q | 2024-09-16T12:07:41.238Z | 2024-09-19T12:20:36.171Z |
5087729 | 5087729 | 20240912234116_W546Q | NL000Q | 2024-09-16T12:07:20.322Z | 2024-09-19T12:20:35.621Z |
5087691 | 5087691 | 20240912234008_H3aoS | NL000Q | 2024-09-16T12:07:14.769Z | 2024-09-19T12:20:35.560Z |
5087561 | 5087561 | 20240912233147_3Mn5W | NL000Q | 2024-09-16T12:07:04.294Z | 2024-09-19T12:20:35.467Z |
5087531 | 5087531 | 20240912233043_RvDwp | NL000Q | 2024-09-16T12:07:02.836Z | 2024-09-19T12:20:35.282Z |
5087078 | 5087078 | 20240912230735_sn6uE | NL000Q | 2024-09-16T12:06:34.627Z | 2024-09-19T12:20:34.012Z |
5086087 | 5086087 | 20240912220856_b3Y08 | NL000Q | 2024-09-16T12:05:13.248Z | 2024-09-19T12:20:30.154Z |
5085827 | 5085827 | 20240912215325_MiCMU | NL000Q | 2024-09-16T12:04:56.948Z | 2024-09-19T12:20:29.636Z |
5085497 | 5085497 | 20240912212333_Ofke2 | NL000Q | 2024-09-16T12:04:19.264Z | 2024-09-19T12:20:28.819Z |
5085327 | 5085327 | 20240912211024_lBuu2 | NL000Q | 2024-09-16T12:04:02.664Z | 2024-09-19T12:20:28.440Z |
5085105 | 5085105 | 20240912204549_aqNR9 | NL000Q | 2024-09-16T12:03:32.393Z | 2024-09-19T12:20:28.039Z |
5084989 | 5084989 | 20240912203821_B2lLn | NL000Q | 2024-09-16T12:03:22.814Z | 2024-09-19T12:20:27.632Z |
5084862 | 5084862 | 20240912202439_PnQO3 | NL000Q | 2024-09-16T12:03:03.855Z | 2024-09-19T12:20:27.364Z |
5084692 | 5084692 | 20240912200638_FC2YL | NL000Q | 2024-09-16T12:02:48.446Z | 2024-09-19T12:20:26.955Z |
5084606 | 5084606 | 20240912195543_U4v8E | NL000Q | 2024-09-16T12:02:38.451Z | 2024-09-19T12:20:26.488Z |
5084384 | 5084384 | 20240912193205_2HB2l | NL000Q | 2024-09-16T12:01:59.994Z | 2024-09-19T12:20:25.325Z |
5084338 | 5084338 | 20240912192459_IZ3Un | NL000Q | 2024-09-16T12:01:54.979Z | 2024-09-19T12:20:25.041Z |
5084314 | 5084314 | 20240912191800_i6tIo | NL000Q | 2024-09-16T12:01:51.388Z | 2024-09-19T12:20:24.923Z |
5080462 | 5080462 | 20240911040033_bPb67 | NL000Q | 2024-09-15T12:17:03.865Z | 2024-09-19T12:21:43.293Z |
5080033 | 5080033 | 20240911032829_syQyM | NL000Q | 2024-09-15T12:16:46.891Z | 2024-09-19T12:21:43.040Z |
5079936 | 5079936 | 20240911032125_sMXmU | NL000Q | 2024-09-15T12:16:42.421Z | 2024-09-19T12:21:42.866Z |
5079895 | 5079895 | 20240911031910_5DYCK | NL000Q | 2024-09-15T12:16:40.533Z | 2024-09-19T12:21:42.773Z |
5078950 | 5078950 | 20240911022317_TVVLO | NL000Q | 2024-09-15T12:15:59.681Z | 2024-09-19T12:21:40.899Z |
5078886 | 5078886 | 20240911021904_LLSPO | NL000Q | 2024-09-15T12:15:54.737Z | 2024-09-19T12:21:40.788Z |
5075736 | 5075736 | 20240912000347_3LGZD | NL000Q | 2024-09-15T12:10:10.295Z | 2024-09-19T12:21:09.456Z |
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);