participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
356 rows where station_code = "US004D" 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 |
---|---|---|---|---|---|
5517615 | 5517615 | 20241110041206_SL3b2 | US004D | 2024-11-11T14:14:40.299Z | 2024-11-12T14:21:48.492Z |
5516537 | 5516537 | 20241110011516_1aP8Z | US004D | 2024-11-11T14:13:07.022Z | 2024-11-12T14:21:09.865Z |
5516147 | 5516147 | 20241110000002_D8wOp | US004D | 2024-11-11T14:12:20.247Z | 2024-11-12T14:20:51.654Z |
5512311 | 5512311 | 20241110083157_131DC | US004D | 2024-11-11T14:02:05.246Z | 2024-11-12T14:18:06.026Z |
5510407 | 5510407 | 20241109023637_Kd3Y3 | US004D | 2024-11-10T14:15:10.016Z | 2024-11-12T14:23:35.749Z |
5506553 | 5506553 | 20241109085715_klJYJ | US004D | 2024-11-10T14:02:32.891Z | 2024-11-12T14:18:25.732Z |
5506464 | 5506464 | 20241109084306_QEeSi | US004D | 2024-11-10T14:02:20.420Z | 2024-11-12T14:18:24.265Z |
5505488 | 5505488 | 20241108053925_Vhwyr | US004D | 2024-11-09T14:16:20.428Z | 2024-11-12T14:25:18.366Z |
5505212 | 5505212 | 20241108040846_YBBeh | US004D | 2024-11-09T14:15:55.865Z | 2024-11-12T14:25:13.847Z |
5505177 | 5505177 | 20241108040409_8Lacc | US004D | 2024-11-09T14:15:53.245Z | 2024-11-12T14:25:13.566Z |
5498721 | 5498721 | 20241108094147_CgdJI | US004D | 2024-11-09T14:02:15.823Z | 2024-11-12T14:22:19.737Z |
5498571 | 5498571 | 20241108091017_zwxS1 | US004D | 2024-11-09T14:01:48.345Z | 2024-11-12T14:22:16.346Z |
5498564 | 5498564 | 20241108090857_kDsf7 | US004D | 2024-11-09T14:01:47.804Z | 2024-11-12T14:22:16.340Z |
5498562 | 5498562 | 20241108090732_RMkBo | US004D | 2024-11-09T14:01:47.427Z | 2024-11-12T14:22:16.311Z |
5498193 | 5498193 | 20241108072652_qm4XA | US004D | 2024-11-09T14:00:47.955Z | 2024-11-12T14:22:08.645Z |
5498090 | 5498090 | 20241108064630_Kj82n | US004D | 2024-11-09T14:00:26.473Z | 2024-11-12T14:22:06.406Z |
5490853 | 5490853 | 20241106005330_mNSQW | US004D | 2024-11-07T14:14:59.834Z | 2024-11-12T14:26:51.574Z |
5490795 | 5490795 | 20241106004118_4EHvq | US004D | 2024-11-07T14:14:56.338Z | 2024-11-12T14:26:51.494Z |
5486206 | 5486206 | 20241106100311_DP2Hh | US004D | 2024-11-07T14:02:13.295Z | 2024-11-12T14:25:27.675Z |
5486172 | 5486172 | 20241106095721_Ht6fz | US004D | 2024-11-07T14:02:07.751Z | 2024-11-12T14:25:27.135Z |
5485962 | 5485962 | 20241106085459_xh7Jr | US004D | 2024-11-07T14:01:17.086Z | 2024-11-12T14:25:25.094Z |
5485317 | 5485317 | 20241105044611_53eR3 | US004D | 2024-11-06T14:18:07.250Z | 2024-11-12T14:27:38.301Z |
5479353 | 5479353 | 20241105090810_ZSi3q | US004D | 2024-11-06T14:02:05.194Z | 2024-11-12T14:26:23.198Z |
5478960 | 5478960 | 20241105071237_aBDuw | US004D | 2024-11-06T14:00:28.251Z | 2024-11-12T14:26:18.827Z |
5478736 | 5478736 | 20241104053139_n70Co | US004D | 2024-11-05T14:18:45.964Z | 2024-11-12T14:28:16.873Z |
5478715 | 5478715 | 20241104051721_58Udt | US004D | 2024-11-05T14:18:43.884Z | 2024-11-12T14:28:16.746Z |
5478145 | 5478145 | 20241104032721_WgBSz | US004D | 2024-11-05T14:17:58.740Z | 2024-11-12T14:28:14.431Z |
5470156 | 5470156 | 20241103061159_kaKkv | US004D | 2024-11-04T14:17:51.960Z | 2024-11-11T14:23:04.692Z |
5470107 | 5470107 | 20241103053144_4ChlW | US004D | 2024-11-04T14:17:48.338Z | 2024-11-11T14:23:04.296Z |
5470105 | 5470105 | 20241103053053_3YyIc | US004D | 2024-11-04T14:17:48.155Z | 2024-11-11T14:23:04.290Z |
5470087 | 5470087 | 20241103052618_kDz9O | US004D | 2024-11-04T14:17:46.872Z | 2024-11-11T14:23:04.245Z |
5469770 | 5469770 | 20241103041729_Yc08r | US004D | 2024-11-04T14:17:02.001Z | 2024-11-11T14:23:02.197Z |
5469238 | 5469238 | 20241103025455_DDBvr | US004D | 2024-11-04T14:15:59.966Z | 2024-11-11T14:22:59.355Z |
5468133 | 5468133 | 20241102233624_w1Ekh | US004D | 2024-11-04T14:13:20.279Z | 2024-11-11T14:22:51.490Z |
5464750 | 5464750 | 20241103090636_2ZD8W | US004D | 2024-11-04T14:01:34.275Z | 2024-11-12T14:27:43.166Z |
5464633 | 5464633 | 20241103083937_ga3pI | US004D | 2024-11-04T14:01:10.538Z | 2024-11-12T14:27:42.700Z |
5464621 | 5464621 | 20241103083354_Rn42c | US004D | 2024-11-04T14:01:08.397Z | 2024-11-12T14:27:42.673Z |
5464598 | 5464598 | 20241103082835_81pl9 | US004D | 2024-11-04T14:01:04.391Z | 2024-11-12T14:27:42.646Z |
5464523 | 5464523 | 20241103080152_KOLnm | US004D | 2024-11-04T14:00:50.559Z | 2024-11-12T14:27:42.123Z |
5464479 | 5464479 | 20241103073453_yTpkY | US004D | 2024-11-04T14:00:37.520Z | 2024-11-12T14:27:41.969Z |
5464407 | 5464407 | 20241103070752_Rr2Xn | US004D | 2024-11-04T14:00:21.793Z | 2024-11-12T14:27:41.259Z |
5462731 | 5462731 | 20241102011914_vjIDk | US004D | 2024-11-03T14:17:59.991Z | 2024-11-10T14:26:33.203Z |
5455563 | 5455563 | 20241102082849_qHbmE | US004D | 2024-11-03T14:01:23.841Z | 2024-11-11T14:22:22.371Z |
5455132 | 5455132 | 20241031063636_5M7Lg | US004D | 2024-11-02T12:23:31.607Z | 2024-11-08T14:23:27.520Z |
5455046 | 5455046 | 20241031061158_N52px | US004D | 2024-11-02T12:23:30.030Z | 2024-11-08T14:23:27.130Z |
5454887 | 5454887 | 20241031054004_iNdkS | US004D | 2024-11-02T12:23:25.762Z | 2024-11-08T14:23:26.124Z |
5452879 | 5452879 | 20241101051352_DNuSF | US004D | 2024-11-02T12:19:31.393Z | 2024-11-09T14:24:35.402Z |
5446774 | 5446774 | 20241031102952_idFSR | US004D | 2024-11-02T12:06:15.266Z | 2024-11-09T14:23:56.373Z |
5446463 | 5446463 | 20241031100109_QkVsO | US004D | 2024-11-02T12:05:22.289Z | 2024-11-09T14:23:54.687Z |
5445088 | 5445088 | 20241031065253_aT6lU | US004D | 2024-11-02T12:00:54.279Z | 2024-11-09T14:23:47.360Z |
5434260 | 5434260 | 20241030085348_tQ48g | US004D | 2024-11-01T12:01:50.306Z | 2024-11-08T14:22:45.854Z |
5434235 | 5434235 | 20241030084530_H2rmy | US004D | 2024-11-01T12:01:39.980Z | 2024-11-08T14:22:45.678Z |
5433114 | 5433114 | 20241029064621_XeRLi | US004D | 2024-10-31T12:21:46.580Z | 2024-11-06T14:27:30.074Z |
5432840 | 5432840 | 20241029045355_q92u9 | US004D | 2024-10-31T12:21:36.451Z | 2024-11-06T14:27:28.906Z |
5432581 | 5432581 | 20241029035459_QdNBA | US004D | 2024-10-31T12:21:27.532Z | 2024-11-06T14:27:27.969Z |
5423366 | 5423366 | 20241029095937_prPMt | US004D | 2024-10-31T12:01:17.016Z | 2024-11-07T14:26:25.465Z |
5423183 | 5423183 | 20241029075036_rRL0p | US004D | 2024-10-31T12:00:30.784Z | 2024-11-07T14:26:24.265Z |
5421425 | 5421425 | 20241028063132_x3iJ2 | US004D | 2024-10-30T12:19:55.386Z | 2024-11-05T14:27:18.647Z |
5421371 | 5421371 | 20241028060834_59N28 | US004D | 2024-10-30T12:19:52.822Z | 2024-11-05T14:27:18.384Z |
5419843 | 5419843 | 20241028011904_GLpVN | US004D | 2024-10-30T12:17:57.858Z | 2024-11-05T14:27:13.994Z |
5419167 | 5419167 | 20241027231037_AHKSS | US004D | 2024-10-30T12:17:12.801Z | 2024-11-05T14:27:12.465Z |
5413725 | 5413725 | 20241027102154_e3y6f | US004D | 2024-10-30T12:05:40.723Z | 2024-11-05T14:26:58.113Z |
5411719 | 5411719 | 20241027091552_BR1ux | US004D | 2024-10-29T12:19:08.757Z | 2024-11-05T14:26:55.736Z |
5411576 | 5411576 | 20241027085607_wSDii | US004D | 2024-10-29T12:19:01.054Z | 2024-11-05T14:26:54.893Z |
5411435 | 5411435 | 20241027083841_3voy3 | US004D | 2024-10-29T12:18:52.026Z | 2024-11-05T14:26:54.243Z |
5411293 | 5411293 | 20241027082400_4SiZG | US004D | 2024-10-29T12:18:40.198Z | 2024-11-05T14:26:53.398Z |
5404564 | 5404564 | 20241026233703_MrAFi | US004D | 2024-10-29T12:11:42.968Z | 2024-11-04T14:28:51.333Z |
5401003 | 5401003 | 20241027065055_xi5WK | US004D | 2024-10-29T12:00:15.775Z | 2024-11-05T14:26:49.645Z |
5400216 | 5400216 | 20241026060740_jAv2t | US004D | 2024-10-28T12:20:27.677Z | 2024-11-03T14:27:41.653Z |
5399766 | 5399766 | 20241026050012_MSYtl | US004D | 2024-10-28T12:20:10.397Z | 2024-11-03T14:27:40.433Z |
5397708 | 5397708 | 20241026015024_zuiIZ | US004D | 2024-10-28T12:18:36.189Z | 2024-11-03T14:27:33.860Z |
5390738 | 5390738 | 20241026102656_hfYuO | US004D | 2024-10-28T12:03:54.856Z | 2024-11-04T14:28:31.274Z |
5390156 | 5390156 | 20241026090710_Ae3jY | US004D | 2024-10-28T12:02:12.956Z | 2024-11-04T14:28:26.402Z |
5389671 | 5389671 | 20241026074131_BHd1c | US004D | 2024-10-28T12:00:54.571Z | 2024-11-04T14:28:23.825Z |
5388515 | 5388515 | 20241025051453_DhWEV | US004D | 2024-10-27T12:22:18.211Z | 2024-11-02T12:28:34.332Z |
5388393 | 5388393 | 20241025044447_prq3b | US004D | 2024-10-27T12:22:11.739Z | 2024-11-02T12:28:34.048Z |
5388366 | 5388366 | 20241025043849_gg2Eq | US004D | 2024-10-27T12:22:10.959Z | 2024-11-02T12:28:34.035Z |
5388181 | 5388181 | 20241025041412_WlIvt | US004D | 2024-10-27T12:22:03.322Z | 2024-11-02T12:28:33.823Z |
5387278 | 5387278 | 20241025021843_2sdfE | US004D | 2024-10-27T12:21:07.558Z | 2024-11-02T12:28:32.333Z |
5380135 | 5380135 | 20241025100253_Ztr2H | US004D | 2024-10-27T12:05:12.642Z | 2024-11-03T14:27:10.186Z |
5379783 | 5379783 | 20241025091331_4fTjk | US004D | 2024-10-27T12:04:09.797Z | 2024-11-03T14:27:08.314Z |
5379706 | 5379706 | 20241025090207_4bgYE | US004D | 2024-10-27T12:03:46.507Z | 2024-11-03T14:27:08.143Z |
5379626 | 5379626 | 20241025085320_j2xLh | US004D | 2024-10-27T12:03:35.165Z | 2024-11-03T14:27:08.010Z |
5371941 | 5371941 | 20241024002351_p1Hp2 | US004D | 2024-10-26T12:18:59.472Z | 2024-11-01T12:26:57.006Z |
5368853 | 5368853 | 20241024101946_gAbyl | US004D | 2024-10-26T12:04:56.760Z | 2024-11-02T12:28:16.965Z |
5367224 | 5367224 | 20241023060110_22ML9 | US004D | 2024-10-25T12:21:48.949Z | 2024-10-31T12:30:11.872Z |
5367036 | 5367036 | 20241023051031_uqYY1 | US004D | 2024-10-25T12:21:41.921Z | 2024-10-31T12:30:10.673Z |
5366622 | 5366622 | 20241023030920_VKoXb | US004D | 2024-10-25T12:21:20.745Z | 2024-10-31T12:30:07.151Z |
5357853 | 5357853 | 20241023102221_goAKD | US004D | 2024-10-25T12:04:41.426Z | 2024-11-01T12:26:41.433Z |
5357832 | 5357832 | 20241023101901_RclaM | US004D | 2024-10-25T12:04:38.147Z | 2024-11-01T12:26:41.403Z |
5357317 | 5357317 | 20241023091549_KpOr4 | US004D | 2024-10-25T12:03:18.189Z | 2024-11-01T12:26:39.532Z |
5357278 | 5357278 | 20241023090838_Zs3pN | US004D | 2024-10-25T12:03:09.631Z | 2024-11-01T12:26:39.387Z |
5356807 | 5356807 | 20241023080131_frw1Q | US004D | 2024-10-25T12:01:41.967Z | 2024-11-01T12:26:37.164Z |
5356689 | 5356689 | 20241023073932_cD5A9 | US004D | 2024-10-25T12:01:20.931Z | 2024-11-01T12:26:36.625Z |
5356557 | 5356557 | 20241023071502_sq8Z4 | US004D | 2024-10-25T12:00:55.046Z | 2024-11-01T12:26:36.060Z |
5356480 | 5356480 | 20241023070053_RRE3s | US004D | 2024-10-25T12:00:41.322Z | 2024-11-01T12:26:35.811Z |
5356460 | 5356460 | 20241023065759_OZNYv | US004D | 2024-10-25T12:00:38.332Z | 2024-11-01T12:26:35.787Z |
5356455 | 5356455 | 20241023065540_vJS3u | US004D | 2024-10-25T12:00:37.566Z | 2024-11-01T12:26:35.784Z |
5356389 | 5356389 | 20241023064036_BBgfs | US004D | 2024-10-25T12:00:22.029Z | 2024-11-01T12:26:35.511Z |
5353376 | 5353376 | 20241023012251_dkhD2 | US004D | 2024-10-24T12:19:40.866Z | 2024-10-31T12:30:04.205Z |
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);