participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
618 rows where station_code = "RU0019" 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 |
---|---|---|---|---|---|
5132644 | 5132644 | 20240916014931_oMeuy | RU0019 | 2024-09-19T12:16:24.368Z | 2024-09-19T12:16:24.368Z |
5132603 | 5132603 | 20240916014113_4Q2Ss | RU0019 | 2024-09-19T12:16:22.102Z | 2024-09-19T12:16:22.102Z |
5132596 | 5132596 | 20240916013748_T7uzY | RU0019 | 2024-09-19T12:16:21.059Z | 2024-09-19T12:16:21.059Z |
5132563 | 5132563 | 20240916013030_YC1RE | RU0019 | 2024-09-19T12:16:18.986Z | 2024-09-19T12:16:18.986Z |
5132529 | 5132529 | 20240916012421_vZS2m | RU0019 | 2024-09-19T12:16:17.457Z | 2024-09-19T12:16:17.457Z |
5132441 | 5132441 | 20240916010851_dKLEE | RU0019 | 2024-09-19T12:16:12.969Z | 2024-09-19T12:16:12.969Z |
5132350 | 5132350 | 20240916004754_PQKvN | RU0019 | 2024-09-19T12:16:08.827Z | 2024-09-19T12:16:08.827Z |
5132320 | 5132320 | 20240916003325_25MsY | RU0019 | 2024-09-19T12:16:07.058Z | 2024-09-19T12:16:07.058Z |
5132318 | 5132318 | 20240916003232_hq2G6 | RU0019 | 2024-09-19T12:16:06.809Z | 2024-09-19T12:16:06.809Z |
5132303 | 5132303 | 20240916002823_4ebiN | RU0019 | 2024-09-19T12:16:04.522Z | 2024-09-19T12:16:04.522Z |
5132197 | 5132197 | 20240915235930_ncBHR | RU0019 | 2024-09-19T12:15:58.024Z | 2024-09-19T12:15:58.024Z |
5132186 | 5132186 | 20240915235417_3EzTl | RU0019 | 2024-09-19T12:15:57.195Z | 2024-09-19T12:15:57.195Z |
5132171 | 5132171 | 20240915235116_EY2BZ | RU0019 | 2024-09-19T12:15:54.444Z | 2024-09-19T12:15:54.444Z |
5132083 | 5132083 | 20240915231305_ZMQ0z | RU0019 | 2024-09-19T12:15:49.070Z | 2024-09-19T12:15:49.070Z |
5132046 | 5132046 | 20240915225422_yxfSS | RU0019 | 2024-09-19T12:15:44.950Z | 2024-09-19T12:15:44.950Z |
5131967 | 5131967 | 20240915222537_S8T2h | RU0019 | 2024-09-19T12:15:37.985Z | 2024-09-19T12:15:37.985Z |
5131898 | 5131898 | 20240915220753_orkeS | RU0019 | 2024-09-19T12:15:32.961Z | 2024-09-19T12:15:32.961Z |
5131829 | 5131829 | 20240915212542_9Q3KA | RU0019 | 2024-09-19T12:15:26.266Z | 2024-09-19T12:15:26.266Z |
5131728 | 5131728 | 20240915205757_mkccg | RU0019 | 2024-09-19T12:15:18.435Z | 2024-09-19T12:15:18.435Z |
5131119 | 5131119 | 20240915175222_SdzWM | RU0019 | 2024-09-19T12:14:25.008Z | 2024-09-19T12:14:25.008Z |
5114553 | 5114553 | 20240915014811_Q70x2 | RU0019 | 2024-09-18T12:05:21.607Z | 2024-09-19T12:18:58.835Z |
5114427 | 5114427 | 20240915014117_htsJR | RU0019 | 2024-09-18T12:05:15.407Z | 2024-09-19T12:18:58.038Z |
5114360 | 5114360 | 20240915013913_0nc5S | RU0019 | 2024-09-18T12:05:13.230Z | 2024-09-19T12:18:57.783Z |
5113656 | 5113656 | 20240915010302_N3F7t | RU0019 | 2024-09-18T12:04:37.303Z | 2024-09-19T12:18:50.888Z |
5113646 | 5113646 | 20240915010147_MRm4A | RU0019 | 2024-09-18T12:04:36.000Z | 2024-09-19T12:18:50.732Z |
5113408 | 5113408 | 20240915004750_ReaUL | RU0019 | 2024-09-18T12:04:15.756Z | 2024-09-19T12:18:48.983Z |
5113321 | 5113321 | 20240915003813_yW38y | RU0019 | 2024-09-18T12:04:08.370Z | 2024-09-19T12:18:48.484Z |
5113268 | 5113268 | 20240915003440_QwqAN | RU0019 | 2024-09-18T12:04:05.282Z | 2024-09-19T12:18:48.325Z |
5113059 | 5113059 | 20240915001742_yX1Nd | RU0019 | 2024-09-18T12:03:53.548Z | 2024-09-19T12:18:46.773Z |
5112762 | 5112762 | 20240914235032_SC9hQ | RU0019 | 2024-09-18T12:03:29.053Z | 2024-09-19T12:18:44.371Z |
5112742 | 5112742 | 20240914234726_RS7XJ | RU0019 | 2024-09-18T12:03:26.396Z | 2024-09-19T12:18:44.094Z |
5112345 | 5112345 | 20240914230230_Q26Ry | RU0019 | 2024-09-18T12:03:00.752Z | 2024-09-19T12:18:40.652Z |
5112251 | 5112251 | 20240914224724_X33Hd | RU0019 | 2024-09-18T12:02:56.713Z | 2024-09-19T12:18:40.155Z |
5112237 | 5112237 | 20240914223918_siluD | RU0019 | 2024-09-18T12:02:54.863Z | 2024-09-19T12:18:39.894Z |
5112232 | 5112232 | 20240914223846_5TCSH | RU0019 | 2024-09-18T12:02:54.485Z | 2024-09-19T12:18:39.868Z |
5112000 | 5112000 | 20240914215236_ky2hw | RU0019 | 2024-09-18T12:02:36.911Z | 2024-09-19T12:18:36.322Z |
5111724 | 5111724 | 20240914210701_2rbNB | RU0019 | 2024-09-18T12:02:13.464Z | 2024-09-19T12:18:33.677Z |
5111481 | 5111481 | 20240914204225_Qv9r6 | RU0019 | 2024-09-18T12:01:59.298Z | 2024-09-19T12:18:30.747Z |
5110491 | 5110491 | 20240914163337_Gpo7M | RU0019 | 2024-09-18T12:00:16.260Z | 2024-09-19T12:18:20.746Z |
5102751 | 5102751 | 20240914014130_2sDGo | RU0019 | 2024-09-17T12:07:34.711Z | 2024-09-19T12:19:55.530Z |
5102242 | 5102242 | 20240914011249_5ubrQ | RU0019 | 2024-09-17T12:06:55.660Z | 2024-09-19T12:19:53.074Z |
5102135 | 5102135 | 20240914010630_MlEmD | RU0019 | 2024-09-17T12:06:49.643Z | 2024-09-19T12:19:52.510Z |
5102012 | 5102012 | 20240914005955_mBbCD | RU0019 | 2024-09-17T12:06:40.704Z | 2024-09-19T12:19:52.189Z |
5101151 | 5101151 | 20240914000719_BBevY | RU0019 | 2024-09-17T12:05:22.609Z | 2024-09-19T12:19:49.873Z |
5100672 | 5100672 | 20240913234046_USiqF | RU0019 | 2024-09-17T12:04:48.580Z | 2024-09-19T12:19:48.525Z |
5100279 | 5100279 | 20240913231416_W24AN | RU0019 | 2024-09-17T12:04:24.222Z | 2024-09-19T12:19:47.617Z |
5100181 | 5100181 | 20240913230016_yzfBJ | RU0019 | 2024-09-17T12:04:07.199Z | 2024-09-19T12:19:47.136Z |
5100178 | 5100178 | 20240913225902_9LKvs | RU0019 | 2024-09-17T12:04:06.515Z | 2024-09-19T12:19:47.065Z |
5100052 | 5100052 | 20240913224443_O2121 | RU0019 | 2024-09-17T12:03:54.984Z | 2024-09-19T12:19:46.799Z |
5100025 | 5100025 | 20240913224134_Nb1qv | RU0019 | 2024-09-17T12:03:52.592Z | 2024-09-19T12:19:46.757Z |
5100009 | 5100009 | 20240913223936_MKVzR | RU0019 | 2024-09-17T12:03:50.809Z | 2024-09-19T12:19:46.735Z |
5099973 | 5099973 | 20240913222940_cdg1J | RU0019 | 2024-09-17T12:03:47.221Z | 2024-09-19T12:19:46.632Z |
5099534 | 5099534 | 20240913213313_PeHYX | RU0019 | 2024-09-17T12:03:07.901Z | 2024-09-19T12:19:45.281Z |
5099532 | 5099532 | 20240913213304_Tghef | RU0019 | 2024-09-17T12:03:07.276Z | 2024-09-19T12:19:45.255Z |
5099502 | 5099502 | 20240913212458_XCVFl | RU0019 | 2024-09-17T12:03:04.270Z | 2024-09-19T12:19:45.130Z |
5099301 | 5099301 | 20240913205643_VSHkF | RU0019 | 2024-09-17T12:02:42.706Z | 2024-09-19T12:19:44.441Z |
5099100 | 5099100 | 20240913202323_JLcud | RU0019 | 2024-09-17T12:02:20.649Z | 2024-09-19T12:19:43.419Z |
5098970 | 5098970 | 20240913200000_FdA3L | RU0019 | 2024-09-17T12:02:05.406Z | 2024-09-19T12:19:42.799Z |
5098475 | 5098475 | 20240913172926_0C5lV | RU0019 | 2024-09-17T12:00:42.959Z | 2024-09-19T12:19:37.650Z |
5077787 | 5077787 | 20240911011743_iHZPH | RU0019 | 2024-09-15T12:15:04.593Z | 2024-09-19T12:21:39.643Z |
5077711 | 5077711 | 20240911011235_O2U8R | RU0019 | 2024-09-15T12:15:01.507Z | 2024-09-19T12:21:39.568Z |
5077509 | 5077509 | 20240911010026_7n3Br | RU0019 | 2024-09-15T12:14:49.905Z | 2024-09-19T12:21:39.311Z |
5077464 | 5077464 | 20240911005613_1Pnl6 | RU0019 | 2024-09-15T12:14:46.678Z | 2024-09-19T12:21:39.009Z |
5074424 | 5074424 | 20240911223907_MDdf2 | RU0019 | 2024-09-15T12:08:32.452Z | 2024-09-19T12:21:07.313Z |
5074332 | 5074332 | 20240911223014_J08zO | RU0019 | 2024-09-15T12:08:23.742Z | 2024-09-19T12:21:07.093Z |
5074000 | 5074000 | 20240911220528_kS9wV | RU0019 | 2024-09-15T12:07:50.386Z | 2024-09-19T12:21:06.840Z |
5073901 | 5073901 | 20240911215253_XlAPB | RU0019 | 2024-09-15T12:07:43.223Z | 2024-09-19T12:21:06.384Z |
5073809 | 5073809 | 20240911214503_2QYdv | RU0019 | 2024-09-15T12:07:38.943Z | 2024-09-19T12:21:06.254Z |
5073359 | 5073359 | 20240911211600_dbLI1 | RU0019 | 2024-09-15T12:07:05.535Z | 2024-09-19T12:21:05.690Z |
5071798 | 5071798 | 20240911182328_npNft | RU0019 | 2024-09-15T12:03:38.353Z | 2024-09-19T12:21:02.765Z |
5069187 | 5069187 | 20240910211646_8gDMc | RU0019 | 2024-09-14T12:19:47.721Z | 2024-09-19T12:21:33.816Z |
5063976 | 5063976 | 20240909231239_PYgOs | RU0019 | 2024-09-14T12:14:35.075Z | 2024-09-18T12:15:15.024Z |
5060651 | 5060651 | 20240910204805_axj7x | RU0019 | 2024-09-14T12:09:17.437Z | 2024-09-19T12:21:33.400Z |
5060642 | 5060642 | 20240910204657_4KaX6 | RU0019 | 2024-09-14T12:09:15.920Z | 2024-09-19T12:21:33.387Z |
5060477 | 5060477 | 20240910203316_jsUkx | RU0019 | 2024-09-14T12:08:51.227Z | 2024-09-19T12:21:32.429Z |
5060474 | 5060474 | 20240910203233_AmvFF | RU0019 | 2024-09-14T12:08:50.903Z | 2024-09-19T12:21:32.426Z |
5053669 | 5053669 | 20240908011347_Tq2A7 | RU0019 | 2024-09-13T12:16:13.029Z | 2024-09-16T12:21:12.369Z |
5052766 | 5052766 | 20240907215735_HKJ29 | RU0019 | 2024-09-13T12:15:25.769Z | 2024-09-16T12:21:07.618Z |
5052682 | 5052682 | 20240907213307_B12sD | RU0019 | 2024-09-13T12:15:19.365Z | 2024-09-16T12:21:07.075Z |
5052638 | 5052638 | 20240907211755_BRXzZ | RU0019 | 2024-09-13T12:15:16.611Z | 2024-09-16T12:21:06.862Z |
5051951 | 5051951 | 20240907191348_9EAyX | RU0019 | 2024-09-13T12:14:49.534Z | 2024-09-16T12:21:02.586Z |
5051634 | 5051634 | 20240907175811_FZVxh | RU0019 | 2024-09-13T12:14:25.852Z | 2024-09-16T12:21:01.435Z |
5046756 | 5046756 | 20240909011253_uLqs5 | RU0019 | 2024-09-13T12:07:27.215Z | 2024-09-17T12:19:00.256Z |
5046500 | 5046500 | 20240908235259_PhKsS | RU0019 | 2024-09-13T12:06:48.627Z | 2024-09-17T12:18:59.430Z |
5046358 | 5046358 | 20240908225709_kLxAb | RU0019 | 2024-09-13T12:06:33.005Z | 2024-09-17T12:18:59.147Z |
5046282 | 5046282 | 20240908222644_pSekj | RU0019 | 2024-09-13T12:06:17.994Z | 2024-09-17T12:18:58.991Z |
5039146 | 5039146 | 20240905233103_H3uF6 | RU0019 | 2024-09-12T12:15:17.304Z | 2024-09-14T12:23:00.445Z |
5039144 | 5039144 | 20240905233029_4a7jn | RU0019 | 2024-09-12T12:15:17.175Z | 2024-09-14T12:23:00.415Z |
5039140 | 5039140 | 20240905232823_NP4Wo | RU0019 | 2024-09-12T12:15:17.019Z | 2024-09-14T12:23:00.397Z |
5039115 | 5039115 | 20240905232318_eY2mG | RU0019 | 2024-09-12T12:15:16.226Z | 2024-09-14T12:23:00.116Z |
5038920 | 5038920 | 20240905223810_GMh4F | RU0019 | 2024-09-12T12:15:07.421Z | 2024-09-14T12:22:59.372Z |
5038911 | 5038911 | 20240905223745_QJeRk | RU0019 | 2024-09-12T12:15:06.916Z | 2024-09-14T12:22:59.200Z |
5038867 | 5038867 | 20240905222305_xZhhw | RU0019 | 2024-09-12T12:15:05.264Z | 2024-09-14T12:22:58.892Z |
5038793 | 5038793 | 20240905215426_AxYLA | RU0019 | 2024-09-12T12:15:01.533Z | 2024-09-14T12:22:58.001Z |
5038780 | 5038780 | 20240905214936_hTyWR | RU0019 | 2024-09-12T12:15:00.576Z | 2024-09-14T12:22:57.946Z |
5038650 | 5038650 | 20240905211814_e3jnE | RU0019 | 2024-09-12T12:14:53.260Z | 2024-09-14T12:22:57.023Z |
5038447 | 5038447 | 20240905201843_rSmkH | RU0019 | 2024-09-12T12:14:40.850Z | 2024-09-14T12:22:56.125Z |
5038294 | 5038294 | 20240905190131_H3tDY | RU0019 | 2024-09-12T12:14:31.682Z | 2024-09-14T12:22:55.514Z |
5038199 | 5038199 | 20240905174144_y0fqL | RU0019 | 2024-09-12T12:14:25.642Z | 2024-09-14T12:22:55.263Z |
5032776 | 5032776 | 20240907014543_aSJeV | RU0019 | 2024-09-12T12:08:00.086Z | 2024-09-15T12:21:27.826Z |
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);