participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
364 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 |
---|---|---|---|---|---|
5583950 | 5583950 | 20241117072927_Gu6eB | US004D | 2024-11-23T14:25:14.446Z | 2024-11-24T14:25:09.474Z |
5556879 | 5556879 | 20241119022839_UJg5w | US004D | 2024-11-20T14:11:36.561Z | 2024-11-24T14:25:04.814Z |
5556814 | 5556814 | 20241119020154_3uSGW | US004D | 2024-11-20T14:11:30.724Z | 2024-11-24T14:25:04.030Z |
5548520 | 5548520 | 20241117000706_x8O5O | US004D | 2024-11-18T14:09:23.716Z | 2024-11-24T14:25:32.040Z |
5541397 | 5541397 | 20241114012423_5bJZE | US004D | 2024-11-15T14:07:33.932Z | 2024-11-22T14:24:18.489Z |
5541374 | 5541374 | 20241114010800_V7W0U | US004D | 2024-11-15T14:07:31.975Z | 2024-11-22T14:24:18.383Z |
5533088 | 5533088 | 20241113070736_fmYt2 | US004D | 2024-11-14T14:01:05.901Z | 2024-11-22T14:24:07.012Z |
5526203 | 5526203 | 20241112083214_vx4qY | US004D | 2024-11-13T14:02:10.533Z | 2024-11-21T14:25:31.790Z |
5517615 | 5517615 | 20241110041206_SL3b2 | US004D | 2024-11-11T14:14:40.299Z | 2024-11-18T14:26:37.402Z |
5516537 | 5516537 | 20241110011516_1aP8Z | US004D | 2024-11-11T14:13:07.022Z | 2024-11-18T14:26:31.730Z |
5516147 | 5516147 | 20241110000002_D8wOp | US004D | 2024-11-11T14:12:20.247Z | 2024-11-18T14:26:29.800Z |
5512311 | 5512311 | 20241110083157_131DC | US004D | 2024-11-11T14:02:05.246Z | 2024-11-19T14:21:23.090Z |
5510407 | 5510407 | 20241109023637_Kd3Y3 | US004D | 2024-11-10T14:15:10.016Z | 2024-11-17T14:23:57.096Z |
5506553 | 5506553 | 20241109085715_klJYJ | US004D | 2024-11-10T14:02:32.891Z | 2024-11-18T14:26:00.547Z |
5506464 | 5506464 | 20241109084306_QEeSi | US004D | 2024-11-10T14:02:20.420Z | 2024-11-18T14:25:59.553Z |
5505488 | 5505488 | 20241108053925_Vhwyr | US004D | 2024-11-09T14:16:20.428Z | 2024-11-16T14:28:32.905Z |
5505212 | 5505212 | 20241108040846_YBBeh | US004D | 2024-11-09T14:15:55.865Z | 2024-11-16T14:28:28.494Z |
5505177 | 5505177 | 20241108040409_8Lacc | US004D | 2024-11-09T14:15:53.245Z | 2024-11-16T14:28:28.379Z |
5498721 | 5498721 | 20241108094147_CgdJI | US004D | 2024-11-09T14:02:15.823Z | 2024-11-17T14:22:59.329Z |
5498571 | 5498571 | 20241108091017_zwxS1 | US004D | 2024-11-09T14:01:48.345Z | 2024-11-17T14:22:57.982Z |
5498564 | 5498564 | 20241108090857_kDsf7 | US004D | 2024-11-09T14:01:47.804Z | 2024-11-17T14:22:57.846Z |
5498562 | 5498562 | 20241108090732_RMkBo | US004D | 2024-11-09T14:01:47.427Z | 2024-11-17T14:22:57.818Z |
5498193 | 5498193 | 20241108072652_qm4XA | US004D | 2024-11-09T14:00:47.955Z | 2024-11-17T14:22:51.525Z |
5498090 | 5498090 | 20241108064630_Kj82n | US004D | 2024-11-09T14:00:26.473Z | 2024-11-17T14:22:50.371Z |
5490853 | 5490853 | 20241106005330_mNSQW | US004D | 2024-11-07T14:14:59.834Z | 2024-11-14T14:23:22.627Z |
5490795 | 5490795 | 20241106004118_4EHvq | US004D | 2024-11-07T14:14:56.338Z | 2024-11-14T14:23:21.835Z |
5486206 | 5486206 | 20241106100311_DP2Hh | US004D | 2024-11-07T14:02:13.295Z | 2024-11-15T14:24:27.461Z |
5486172 | 5486172 | 20241106095721_Ht6fz | US004D | 2024-11-07T14:02:07.751Z | 2024-11-15T14:24:27.019Z |
5485962 | 5485962 | 20241106085459_xh7Jr | US004D | 2024-11-07T14:01:17.086Z | 2024-11-15T14:24:24.647Z |
5485317 | 5485317 | 20241105044611_53eR3 | US004D | 2024-11-06T14:18:07.250Z | 2024-11-13T14:27:41.640Z |
5479353 | 5479353 | 20241105090810_ZSi3q | US004D | 2024-11-06T14:02:05.194Z | 2024-11-14T14:22:58.546Z |
5478960 | 5478960 | 20241105071237_aBDuw | US004D | 2024-11-06T14:00:28.251Z | 2024-11-14T14:22:56.425Z |
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 |
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);