participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,781 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 |
---|---|---|---|---|---|
5491689 | 5491689 | 20241106042813_jwce5 | CH0004 | 2024-11-07T14:16:45.927Z | 2024-11-09T14:20:12.892Z |
5491397 | 5491397 | 20241106031156_KzfrX | CH0004 | 2024-11-07T14:16:03.391Z | 2024-11-09T14:20:07.365Z |
5491344 | 5491344 | 20241106030133_GGnBP | CH0004 | 2024-11-07T14:15:55.269Z | 2024-11-09T14:20:06.988Z |
5491148 | 5491148 | 20241106021040_N5RNz | CH0004 | 2024-11-07T14:15:22.789Z | 2024-11-09T14:20:04.528Z |
5491098 | 5491098 | 20241106015502_q0r3u | CH0004 | 2024-11-07T14:15:18.941Z | 2024-11-09T14:20:03.973Z |
5491027 | 5491027 | 20241106014016_e5Fv8 | CH0004 | 2024-11-07T14:15:13.801Z | 2024-11-09T14:20:03.174Z |
5491006 | 5491006 | 20241106013409_oobQn | CH0004 | 2024-11-07T14:15:11.926Z | 2024-11-09T14:20:02.873Z |
5490935 | 5490935 | 20241106011947_knwft | CH0004 | 2024-11-07T14:15:06.095Z | 2024-11-09T14:20:02.017Z |
5490895 | 5490895 | 20241106010724_xIYAe | CH0004 | 2024-11-07T14:15:03.663Z | 2024-11-09T14:20:01.200Z |
5490803 | 5490803 | 20241106004301_KFTEL | CH0004 | 2024-11-07T14:14:56.854Z | 2024-11-09T14:19:59.692Z |
5490164 | 5490164 | 20241105212727_xy5IY | CH0004 | 2024-11-07T14:13:23.645Z | 2024-11-09T14:19:51.630Z |
5476374 | 5476374 | 20241103231734_2AKe1 | CH0004 | 2024-11-05T14:15:12.501Z | 2024-11-09T14:22:08.980Z |
5476350 | 5476350 | 20241103231130_Mq1hp | CH0004 | 2024-11-05T14:15:08.407Z | 2024-11-09T14:22:08.632Z |
5475670 | 5475670 | 20241103205830_9ceKW | CH0004 | 2024-11-05T14:13:59.003Z | 2024-11-09T14:22:00.886Z |
5463532 | 5463532 | 20241102035457_tzBMk | CH0004 | 2024-11-03T14:18:55.220Z | 2024-11-09T14:23:41.882Z |
5463495 | 5463495 | 20241102034714_vh8Fy | CH0004 | 2024-11-03T14:18:50.686Z | 2024-11-09T14:23:41.344Z |
5463375 | 5463375 | 20241102032954_kBv9C | CH0004 | 2024-11-03T14:18:40.240Z | 2024-11-09T14:23:40.298Z |
5463291 | 5463291 | 20241102031104_NSiOp | CH0004 | 2024-11-03T14:18:30.904Z | 2024-11-09T14:23:39.766Z |
5463236 | 5463236 | 20241102025914_B5tdR | CH0004 | 2024-11-03T14:18:27.315Z | 2024-11-09T14:23:38.883Z |
5463107 | 5463107 | 20241102023526_pW5h1 | CH0004 | 2024-11-03T14:18:18.971Z | 2024-11-09T14:23:37.991Z |
5463091 | 5463091 | 20241102023324_TVlM0 | CH0004 | 2024-11-03T14:18:17.852Z | 2024-11-09T14:23:37.674Z |
5463066 | 5463066 | 20241102022926_JbEiY | CH0004 | 2024-11-03T14:18:16.801Z | 2024-11-09T14:23:37.433Z |
5462982 | 5462982 | 20241102021027_nw2YO | CH0004 | 2024-11-03T14:18:13.199Z | 2024-11-09T14:23:37.062Z |
5462980 | 5462980 | 20241102021021_g8lRX | CH0004 | 2024-11-03T14:18:13.058Z | 2024-11-09T14:23:37.026Z |
5462924 | 5462924 | 20241102015712_AeiRJ | CH0004 | 2024-11-03T14:18:10.059Z | 2024-11-09T14:23:36.841Z |
5462833 | 5462833 | 20241102014204_QVuES | CH0004 | 2024-11-03T14:18:07.033Z | 2024-11-09T14:23:36.459Z |
5462656 | 5462656 | 20241102010318_xIIU5 | CH0004 | 2024-11-03T14:17:52.157Z | 2024-11-09T14:23:34.987Z |
5462645 | 5462645 | 20241102010050_N4Ckn | CH0004 | 2024-11-03T14:17:50.611Z | 2024-11-09T14:23:34.928Z |
5462614 | 5462614 | 20241102005445_Ee3dY | CH0004 | 2024-11-03T14:17:47.635Z | 2024-11-09T14:23:34.760Z |
5462545 | 5462545 | 20241102004241_3ezCL | CH0004 | 2024-11-03T14:17:39.030Z | 2024-11-09T14:23:34.658Z |
5462407 | 5462407 | 20241102001353_hyMEC | CH0004 | 2024-11-03T14:17:24.414Z | 2024-11-09T14:23:34.276Z |
5462361 | 5462361 | 20241101235753_7HOO3 | CH0004 | 2024-11-03T14:17:19.588Z | 2024-11-09T14:23:33.971Z |
5462262 | 5462262 | 20241101233454_ct25I | CH0004 | 2024-11-03T14:17:06.792Z | 2024-11-09T14:23:33.531Z |
5462259 | 5462259 | 20241101233408_8VNCx | CH0004 | 2024-11-03T14:17:06.657Z | 2024-11-09T14:23:33.519Z |
5462218 | 5462218 | 20241101232657_42QzF | CH0004 | 2024-11-03T14:17:04.304Z | 2024-11-09T14:23:33.226Z |
5462135 | 5462135 | 20241101230819_pyc2d | CH0004 | 2024-11-03T14:16:58.976Z | 2024-11-09T14:23:32.606Z |
5461954 | 5461954 | 20241101222338_ts7Nj | CH0004 | 2024-11-03T14:16:49.016Z | 2024-11-09T14:23:32.055Z |
5461532 | 5461532 | 20241101194506_RxWW1 | CH0004 | 2024-11-03T14:15:53.641Z | 2024-11-09T14:23:29.763Z |
5461453 | 5461453 | 20241101190446_I9jQi | CH0004 | 2024-11-03T14:15:46.502Z | 2024-11-09T14:23:29.438Z |
5461353 | 5461353 | 20241101181442_uBL6K | CH0004 | 2024-11-03T14:15:16.494Z | 2024-11-09T14:23:27.986Z |
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 |
5306365 | 5306365 | 20241014020928_Vx0Y6 | CH0004 | 2024-10-15T12:07:15.777Z | 2024-10-22T12:24:38.556Z |
5306355 | 5306355 | 20241014020814_t2uu4 | CH0004 | 2024-10-15T12:07:14.968Z | 2024-10-22T12:24:38.511Z |
5306037 | 5306037 | 20241014003743_W2Vuk | CH0004 | 2024-10-15T12:06:19.981Z | 2024-10-22T12:24:33.931Z |
5306001 | 5306001 | 20241014000656_k6bEP | CH0004 | 2024-10-15T12:06:14.727Z | 2024-10-22T12:24:33.440Z |
5305993 | 5305993 | 20241013235505_62wGD | CH0004 | 2024-10-15T12:06:13.513Z | 2024-10-22T12:24:33.404Z |
5294484 | 5294484 | 20241012041956_v1GBl | CH0004 | 2024-10-13T12:18:39.623Z | 2024-10-20T12:25:13.483Z |
5294461 | 5294461 | 20241012041402_8b1lJ | CH0004 | 2024-10-13T12:18:38.224Z | 2024-10-20T12:25:13.314Z |
5294441 | 5294441 | 20241012041056_5uDa3 | CH0004 | 2024-10-13T12:18:37.175Z | 2024-10-20T12:25:13.042Z |
5294357 | 5294357 | 20241012035134_9Bmgm | CH0004 | 2024-10-13T12:18:32.473Z | 2024-10-20T12:25:10.613Z |
5294149 | 5294149 | 20241012031253_uJB23 | CH0004 | 2024-10-13T12:18:19.067Z | 2024-10-20T12:25:08.222Z |
5294096 | 5294096 | 20241012030145_aF58H | CH0004 | 2024-10-13T12:18:15.757Z | 2024-10-20T12:25:07.320Z |
5294004 | 5294004 | 20241012024800_PWgRS | CH0004 | 2024-10-13T12:18:07.263Z | 2024-10-20T12:25:06.000Z |
5293882 | 5293882 | 20241012023341_0wMFm | CH0004 | 2024-10-13T12:17:57.695Z | 2024-10-20T12:25:04.949Z |
5293877 | 5293877 | 20241012023232_bdb6d | CH0004 | 2024-10-13T12:17:57.623Z | 2024-10-20T12:25:04.910Z |
5293712 | 5293712 | 20241012021000_NFH32 | CH0004 | 2024-10-13T12:17:47.043Z | 2024-10-20T12:25:03.237Z |
5293700 | 5293700 | 20241012020823_1SP2B | CH0004 | 2024-10-13T12:17:46.518Z | 2024-10-20T12:25:03.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);