participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,797 rows where station_code = "CH0004" 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 |
---|---|---|---|---|---|
5549459 | 5549459 | 20241117045616_geHbA | CH0004 | 2024-11-18T14:11:38.005Z | 2024-11-23T14:25:44.408Z |
5549283 | 5549283 | 20241117040930_x2N2m | CH0004 | 2024-11-18T14:11:24.950Z | 2024-11-23T14:25:43.932Z |
5549222 | 5549222 | 20241117035420_IlMme | CH0004 | 2024-11-18T14:11:18.982Z | 2024-11-23T14:25:43.500Z |
5549163 | 5549163 | 20241117033441_urbiQ | CH0004 | 2024-11-18T14:11:12.259Z | 2024-11-23T14:25:43.306Z |
5548497 | 5548497 | 20241116235733_j7cTv | CH0004 | 2024-11-18T14:09:21.133Z | 2024-11-23T14:25:40.476Z |
5545269 | 5545269 | 20241116035006_bn19W | CH0004 | 2024-11-17T14:04:21.937Z | 2024-11-23T14:25:58.369Z |
5545231 | 5545231 | 20241116030937_Aa7N7 | CH0004 | 2024-11-17T14:04:16.742Z | 2024-11-23T14:25:57.939Z |
5545195 | 5545195 | 20241116022518_2OxXo | CH0004 | 2024-11-17T14:04:03.513Z | 2024-11-23T14:25:57.322Z |
5545194 | 5545194 | 20241116022443_O7rX3 | CH0004 | 2024-11-17T14:04:02.982Z | 2024-11-23T14:25:57.303Z |
5543560 | 5543560 | 20241115020610_EDIWk | CH0004 | 2024-11-16T14:06:42.272Z | 2024-11-23T14:26:19.750Z |
5543504 | 5543504 | 20241115014927_Sdzzg | CH0004 | 2024-11-16T14:06:32.450Z | 2024-11-23T14:26:19.325Z |
5543420 | 5543420 | 20241115011652_OZBIq | CH0004 | 2024-11-16T14:06:16.902Z | 2024-11-23T14:26:18.886Z |
5543375 | 5543375 | 20241115004814_1XwMB | CH0004 | 2024-11-16T14:06:11.059Z | 2024-11-23T14:26:18.693Z |
5543374 | 5543374 | 20241115004715_WeFZ2 | CH0004 | 2024-11-16T14:06:10.667Z | 2024-11-23T14:26:18.673Z |
5543257 | 5543257 | 20241114233049_AQlBo | CH0004 | 2024-11-16T14:05:52.506Z | 2024-11-23T14:26:18.325Z |
5509033 | 5509033 | 20241108212150_98DOR | CH0004 | 2024-11-10T14:12:22.969Z | 2024-11-17T14:23:39.409Z |
5491689 | 5491689 | 20241106042813_jwce5 | CH0004 | 2024-11-07T14:16:45.927Z | 2024-11-14T14:23:26.425Z |
5491397 | 5491397 | 20241106031156_KzfrX | CH0004 | 2024-11-07T14:16:03.391Z | 2024-11-14T14:23:25.646Z |
5491344 | 5491344 | 20241106030133_GGnBP | CH0004 | 2024-11-07T14:15:55.269Z | 2024-11-14T14:23:25.249Z |
5491148 | 5491148 | 20241106021040_N5RNz | CH0004 | 2024-11-07T14:15:22.789Z | 2024-11-14T14:23:24.123Z |
5491098 | 5491098 | 20241106015502_q0r3u | CH0004 | 2024-11-07T14:15:18.941Z | 2024-11-14T14:23:23.742Z |
5491027 | 5491027 | 20241106014016_e5Fv8 | CH0004 | 2024-11-07T14:15:13.801Z | 2024-11-14T14:23:23.276Z |
5491006 | 5491006 | 20241106013409_oobQn | CH0004 | 2024-11-07T14:15:11.926Z | 2024-11-14T14:23:23.179Z |
5490935 | 5490935 | 20241106011947_knwft | CH0004 | 2024-11-07T14:15:06.095Z | 2024-11-14T14:23:22.962Z |
5490895 | 5490895 | 20241106010724_xIYAe | CH0004 | 2024-11-07T14:15:03.663Z | 2024-11-14T14:23:22.724Z |
5490803 | 5490803 | 20241106004301_KFTEL | CH0004 | 2024-11-07T14:14:56.854Z | 2024-11-14T14:23:21.991Z |
5490164 | 5490164 | 20241105212727_xy5IY | CH0004 | 2024-11-07T14:13:23.645Z | 2024-11-14T14:23:17.960Z |
5476374 | 5476374 | 20241103231734_2AKe1 | CH0004 | 2024-11-05T14:15:12.501Z | 2024-11-12T14:28:05.914Z |
5476350 | 5476350 | 20241103231130_Mq1hp | CH0004 | 2024-11-05T14:15:08.407Z | 2024-11-12T14:28:05.842Z |
5475670 | 5475670 | 20241103205830_9ceKW | CH0004 | 2024-11-05T14:13:59.003Z | 2024-11-12T14:28:00.380Z |
5463532 | 5463532 | 20241102035457_tzBMk | CH0004 | 2024-11-03T14:18:55.220Z | 2024-11-10T14:26:35.492Z |
5463495 | 5463495 | 20241102034714_vh8Fy | CH0004 | 2024-11-03T14:18:50.686Z | 2024-11-10T14:26:35.381Z |
5463375 | 5463375 | 20241102032954_kBv9C | CH0004 | 2024-11-03T14:18:40.240Z | 2024-11-10T14:26:35.045Z |
5463291 | 5463291 | 20241102031104_NSiOp | CH0004 | 2024-11-03T14:18:30.904Z | 2024-11-10T14:26:34.708Z |
5463236 | 5463236 | 20241102025914_B5tdR | CH0004 | 2024-11-03T14:18:27.315Z | 2024-11-10T14:26:34.604Z |
5463107 | 5463107 | 20241102023526_pW5h1 | CH0004 | 2024-11-03T14:18:18.971Z | 2024-11-10T14:26:34.268Z |
5463091 | 5463091 | 20241102023324_TVlM0 | CH0004 | 2024-11-03T14:18:17.852Z | 2024-11-10T14:26:34.259Z |
5463066 | 5463066 | 20241102022926_JbEiY | CH0004 | 2024-11-03T14:18:16.801Z | 2024-11-10T14:26:34.192Z |
5462982 | 5462982 | 20241102021027_nw2YO | CH0004 | 2024-11-03T14:18:13.199Z | 2024-11-10T14:26:33.903Z |
5462980 | 5462980 | 20241102021021_g8lRX | CH0004 | 2024-11-03T14:18:13.058Z | 2024-11-10T14:26:33.896Z |
5462924 | 5462924 | 20241102015712_AeiRJ | CH0004 | 2024-11-03T14:18:10.059Z | 2024-11-10T14:26:33.730Z |
5462833 | 5462833 | 20241102014204_QVuES | CH0004 | 2024-11-03T14:18:07.033Z | 2024-11-10T14:26:33.497Z |
5462656 | 5462656 | 20241102010318_xIIU5 | CH0004 | 2024-11-03T14:17:52.157Z | 2024-11-10T14:26:33.053Z |
5462645 | 5462645 | 20241102010050_N4Ckn | CH0004 | 2024-11-03T14:17:50.611Z | 2024-11-10T14:26:33.028Z |
5462614 | 5462614 | 20241102005445_Ee3dY | CH0004 | 2024-11-03T14:17:47.635Z | 2024-11-10T14:26:32.985Z |
5462545 | 5462545 | 20241102004241_3ezCL | CH0004 | 2024-11-03T14:17:39.030Z | 2024-11-10T14:26:32.802Z |
5462407 | 5462407 | 20241102001353_hyMEC | CH0004 | 2024-11-03T14:17:24.414Z | 2024-11-10T14:26:32.444Z |
5462361 | 5462361 | 20241101235753_7HOO3 | CH0004 | 2024-11-03T14:17:19.588Z | 2024-11-10T14:26:32.397Z |
5462262 | 5462262 | 20241101233454_ct25I | CH0004 | 2024-11-03T14:17:06.792Z | 2024-11-10T14:26:32.066Z |
5462259 | 5462259 | 20241101233408_8VNCx | CH0004 | 2024-11-03T14:17:06.657Z | 2024-11-10T14:26:32.060Z |
5462218 | 5462218 | 20241101232657_42QzF | CH0004 | 2024-11-03T14:17:04.304Z | 2024-11-10T14:26:32.005Z |
5462135 | 5462135 | 20241101230819_pyc2d | CH0004 | 2024-11-03T14:16:58.976Z | 2024-11-10T14:26:31.594Z |
5461954 | 5461954 | 20241101222338_ts7Nj | CH0004 | 2024-11-03T14:16:49.016Z | 2024-11-10T14:26:31.084Z |
5461532 | 5461532 | 20241101194506_RxWW1 | CH0004 | 2024-11-03T14:15:53.641Z | 2024-11-10T14:26:29.115Z |
5461453 | 5461453 | 20241101190446_I9jQi | CH0004 | 2024-11-03T14:15:46.502Z | 2024-11-10T14:26:28.869Z |
5461353 | 5461353 | 20241101181442_uBL6K | CH0004 | 2024-11-03T14:15:16.494Z | 2024-11-10T14:26:28.226Z |
5420384 | 5420384 | 20241028023550_ZVU11 | CH0004 | 2024-10-30T12:18:47.878Z | 2024-11-05T14:27:15.316Z |
5420369 | 5420369 | 20241028023446_6aWtm | CH0004 | 2024-10-30T12:18:46.067Z | 2024-11-05T14:27:15.286Z |
5420327 | 5420327 | 20241028023023_GtcRy | CH0004 | 2024-10-30T12:18:43.478Z | 2024-11-05T14:27:15.183Z |
5419984 | 5419984 | 20241028014030_EcKb1 | CH0004 | 2024-10-30T12:18:12.073Z | 2024-11-05T14:27:14.264Z |
5419980 | 5419980 | 20241028013956_Ci4nP | CH0004 | 2024-10-30T12:18:11.799Z | 2024-11-05T14:27:14.261Z |
5419875 | 5419875 | 20241028012423_1bEAB | CH0004 | 2024-10-30T12:17:59.988Z | 2024-11-05T14:27:14.061Z |
5419699 | 5419699 | 20241028004846_bWRG7 | CH0004 | 2024-10-30T12:17:44.543Z | 2024-11-05T14:27:13.745Z |
5419512 | 5419512 | 20241028001222_0K3It | CH0004 | 2024-10-30T12:17:31.014Z | 2024-11-05T14:27:13.309Z |
5419498 | 5419498 | 20241028001035_3Xok3 | CH0004 | 2024-10-30T12:17:30.193Z | 2024-11-05T14:27:13.270Z |
5419260 | 5419260 | 20241027232512_ndPok | CH0004 | 2024-10-30T12:17:17.346Z | 2024-11-05T14:27:12.638Z |
5418718 | 5418718 | 20241027214240_jS0ie | CH0004 | 2024-10-30T12:16:01.035Z | 2024-11-05T14:27:10.953Z |
5386458 | 5386458 | 20241025004523_hShE7 | CH0004 | 2024-10-27T12:20:06.260Z | 2024-11-02T12:28:31.263Z |
5385951 | 5385951 | 20241024234644_VcJOp | CH0004 | 2024-10-27T12:19:39.653Z | 2024-11-02T12:28:30.519Z |
5385437 | 5385437 | 20241024224541_FxbzO | CH0004 | 2024-10-27T12:18:55.853Z | 2024-11-02T12:28:29.834Z |
5385164 | 5385164 | 20241024220051_Ou9Cs | CH0004 | 2024-10-27T12:18:30.238Z | 2024-11-02T12:28:29.228Z |
5384942 | 5384942 | 20241024211845_HQZYW | CH0004 | 2024-10-27T12:18:02.288Z | 2024-11-02T12:28:28.776Z |
5384806 | 5384806 | 20241024205722_aJwCD | CH0004 | 2024-10-27T12:17:43.695Z | 2024-11-02T12:28:27.736Z |
5340521 | 5340521 | 20241022002536_s3Rrv | CH0004 | 2024-10-23T12:14:37.179Z | 2024-10-30T12:26:45.959Z |
5340201 | 5340201 | 20241021235451_NEk9X | CH0004 | 2024-10-23T12:14:23.282Z | 2024-10-30T12:26:45.506Z |
5340002 | 5340002 | 20241021233546_ACL3m | CH0004 | 2024-10-23T12:14:13.927Z | 2024-10-30T12:26:45.249Z |
5339997 | 5339997 | 20241021233509_MwLNl | CH0004 | 2024-10-23T12:14:13.315Z | 2024-10-30T12:26:45.219Z |
5339749 | 5339749 | 20241021231153_9l6Vh | CH0004 | 2024-10-23T12:13:44.370Z | 2024-10-30T12:26:44.846Z |
5339427 | 5339427 | 20241021223615_QwG6u | CH0004 | 2024-10-23T12:13:06.300Z | 2024-10-30T12:26:44.167Z |
5339284 | 5339284 | 20241021221826_hfjSR | CH0004 | 2024-10-23T12:12:57.148Z | 2024-10-30T12:26:43.936Z |
5334694 | 5334694 | 20241021030339_34FKx | CH0004 | 2024-10-22T12:17:18.487Z | 2024-10-29T12:26:35.456Z |
5334518 | 5334518 | 20241021024143_t92kP | CH0004 | 2024-10-22T12:16:58.693Z | 2024-10-29T12:26:35.315Z |
5334450 | 5334450 | 20241021023658_8DMeT | CH0004 | 2024-10-22T12:16:52.279Z | 2024-10-29T12:26:35.173Z |
5334087 | 5334087 | 20241021015553_m1V3F | CH0004 | 2024-10-22T12:16:19.570Z | 2024-10-29T12:26:34.805Z |
5334036 | 5334036 | 20241021015157_ruzMy | CH0004 | 2024-10-22T12:16:17.374Z | 2024-10-29T12:26:34.774Z |
5333928 | 5333928 | 20241021014023_gBeRe | CH0004 | 2024-10-22T12:16:12.729Z | 2024-10-29T12:26:34.693Z |
5333916 | 5333916 | 20241021013954_cEizi | CH0004 | 2024-10-22T12:16:12.378Z | 2024-10-29T12:26:34.688Z |
5333730 | 5333730 | 20241021011824_nuBwD | CH0004 | 2024-10-22T12:15:59.273Z | 2024-10-29T12:26:34.555Z |
5333633 | 5333633 | 20241021010336_m7KZo | CH0004 | 2024-10-22T12:15:43.116Z | 2024-10-29T12:26:34.476Z |
5313116 | 5313116 | 20241014030936_1jMBq | CH0004 | 2024-10-16T12:13:43.153Z | 2024-10-22T12:24:41.452Z |
5313112 | 5313112 | 20241014030403_Q4xiF | CH0004 | 2024-10-16T12:13:42.500Z | 2024-10-22T12:24:41.157Z |
5312592 | 5312592 | 20241015040417_rE7Bo | CH0004 | 2024-10-16T12:10:50.142Z | 2024-10-23T12:24:52.315Z |
5312437 | 5312437 | 20241015033819_8rSmC | CH0004 | 2024-10-16T12:10:40.505Z | 2024-10-23T12:24:50.991Z |
5312369 | 5312369 | 20241015032413_l1GqV | CH0004 | 2024-10-16T12:10:29.651Z | 2024-10-23T12:24:50.624Z |
5312223 | 5312223 | 20241015030228_VvLJt | CH0004 | 2024-10-16T12:10:13.840Z | 2024-10-23T12:24:49.596Z |
5306562 | 5306562 | 20241014025347_UCpyK | CH0004 | 2024-10-15T12:07:56.827Z | 2024-10-22T12:24:40.741Z |
5306548 | 5306548 | 20241014025138_XYFni | CH0004 | 2024-10-15T12:07:52.545Z | 2024-10-22T12:24:40.715Z |
5306536 | 5306536 | 20241014024604_9vvd3 | CH0004 | 2024-10-15T12:07:47.558Z | 2024-10-22T12:24:40.441Z |
5306534 | 5306534 | 20241014024602_JZ3pn | CH0004 | 2024-10-15T12:07:47.096Z | 2024-10-22T12:24:40.440Z |
5306377 | 5306377 | 20241014021156_TnbRF | CH0004 | 2024-10-15T12:07:17.408Z | 2024-10-22T12:24:38.595Z |
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);