participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
986 rows where station_code = "US002R" 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 |
---|---|---|---|---|---|
5497924 | 5497924 | 20241107060800_40Qc8 | US002R | 2024-11-08T14:14:30.854Z | 2024-11-09T14:18:53.698Z |
5497884 | 5497884 | 20241107054743_ZrXH4 | US002R | 2024-11-08T14:14:28.921Z | 2024-11-09T14:18:53.182Z |
5497852 | 5497852 | 20241107053454_NVdWA | US002R | 2024-11-08T14:14:27.757Z | 2024-11-09T14:18:52.778Z |
5497845 | 5497845 | 20241107053424_zK2zv | US002R | 2024-11-08T14:14:26.739Z | 2024-11-09T14:18:52.709Z |
5496760 | 5496760 | 20241107013136_w63cA | US002R | 2024-11-08T14:12:50.143Z | 2024-11-09T14:18:29.654Z |
5493001 | 5493001 | 20241107103402_jNLSS | US002R | 2024-11-08T14:02:41.559Z | 2024-11-09T14:16:27.504Z |
5492686 | 5492686 | 20241107093219_aP5Hq | US002R | 2024-11-08T14:01:53.893Z | 2024-11-09T14:16:27.429Z |
5492601 | 5492601 | 20241107091413_GpJVt | US002R | 2024-11-08T14:01:32.075Z | 2024-11-09T14:16:27.410Z |
5492569 | 5492569 | 20241107090620_cFdbI | US002R | 2024-11-08T14:01:28.065Z | 2024-11-09T14:16:27.403Z |
5492519 | 5492519 | 20241107084903_xS7BF | US002R | 2024-11-08T14:01:20.456Z | 2024-11-09T14:16:27.391Z |
5492462 | 5492462 | 20241107083824_jQ3eA | US002R | 2024-11-08T14:01:14.177Z | 2024-11-09T14:16:27.379Z |
5492352 | 5492352 | 20241107081345_ImJ4F | US002R | 2024-11-08T14:00:51.285Z | 2024-11-09T14:16:27.352Z |
5492334 | 5492334 | 20241107081012_JHGzC | US002R | 2024-11-08T14:00:48.582Z | 2024-11-09T14:16:27.347Z |
5491873 | 5491873 | 20241106054839_0N8sE | US002R | 2024-11-07T14:17:15.954Z | 2024-11-09T14:20:15.497Z |
5491828 | 5491828 | 20241106052357_vAiCQ | US002R | 2024-11-07T14:17:05.864Z | 2024-11-09T14:20:15.141Z |
5491780 | 5491780 | 20241106050720_kN4W3 | US002R | 2024-11-07T14:16:57.701Z | 2024-11-09T14:20:14.609Z |
5491169 | 5491169 | 20241106021558_ufx98 | US002R | 2024-11-07T14:15:24.243Z | 2024-11-09T14:20:04.728Z |
5486492 | 5486492 | 20241106115251_AgWhF | US002R | 2024-11-07T14:03:13.151Z | 2024-11-09T14:16:49.004Z |
5486425 | 5486425 | 20241106113331_CxxEM | US002R | 2024-11-07T14:02:56.410Z | 2024-11-09T14:16:46.062Z |
5486332 | 5486332 | 20241106105044_PXAHD | US002R | 2024-11-07T14:02:38.626Z | 2024-11-09T14:16:42.839Z |
5486202 | 5486202 | 20241106100303_GeU5n | US002R | 2024-11-07T14:02:12.901Z | 2024-11-09T14:16:39.712Z |
5486180 | 5486180 | 20241106095939_IeeZE | US002R | 2024-11-07T14:02:09.458Z | 2024-11-09T14:16:39.229Z |
5486113 | 5486113 | 20241106094327_0IaAe | US002R | 2024-11-07T14:01:54.185Z | 2024-11-09T14:16:38.135Z |
5486111 | 5486111 | 20241106094320_0sQUZ | US002R | 2024-11-07T14:01:53.830Z | 2024-11-09T14:16:38.098Z |
5486056 | 5486056 | 20241106092244_uwMCV | US002R | 2024-11-07T14:01:40.964Z | 2024-11-09T14:16:37.202Z |
5486010 | 5486010 | 20241106090954_nmvWM | US002R | 2024-11-07T14:01:29.427Z | 2024-11-09T14:16:36.027Z |
5485946 | 5485946 | 20241106085305_AaYk1 | US002R | 2024-11-07T14:01:14.521Z | 2024-11-09T14:16:34.971Z |
5485919 | 5485919 | 20241106083430_XbSqx | US002R | 2024-11-07T14:01:09.267Z | 2024-11-09T14:16:34.593Z |
5485862 | 5485862 | 20241106080625_1hTbi | US002R | 2024-11-07T14:00:52.991Z | 2024-11-09T14:16:33.644Z |
5485798 | 5485798 | 20241106073145_Pkwjd | US002R | 2024-11-07T14:00:40.289Z | 2024-11-09T14:16:32.576Z |
5485795 | 5485795 | 20241106073040_DQZnj | US002R | 2024-11-07T14:00:39.208Z | 2024-11-09T14:16:32.531Z |
5485794 | 5485794 | 20241106073014_d61wZ | US002R | 2024-11-07T14:00:38.270Z | 2024-11-09T14:16:32.478Z |
5485768 | 5485768 | 20241106072351_THXq3 | US002R | 2024-11-07T14:00:34.557Z | 2024-11-09T14:16:32.024Z |
5485766 | 5485766 | 20241106072320_11y6i | US002R | 2024-11-07T14:00:33.660Z | 2024-11-09T14:16:31.932Z |
5485723 | 5485723 | 20241106070026_qPrcO | US002R | 2024-11-07T14:00:23.910Z | 2024-11-09T14:16:31.101Z |
5470400 | 5470400 | 20241104075710_wVgvR | US002R | 2024-11-05T14:00:31.096Z | 2024-11-09T14:20:19.327Z |
5459224 | 5459224 | 20241101102616_kLpAV | US002R | 2024-11-03T14:11:31.528Z | 2024-11-09T14:23:17.040Z |
5458477 | 5458477 | 20241101083316_0b832 | US002R | 2024-11-03T14:09:49.557Z | 2024-11-09T14:23:12.378Z |
5452804 | 5452804 | 20241101044112_AGrlj | US002R | 2024-11-02T12:19:23.573Z | 2024-11-09T14:24:34.096Z |
5452749 | 5452749 | 20241101042106_cI3VR | US002R | 2024-11-02T12:19:19.591Z | 2024-11-09T14:24:33.488Z |
5452484 | 5452484 | 20241101032325_2a2l7 | US002R | 2024-11-02T12:18:52.077Z | 2024-11-09T14:24:31.237Z |
5414223 | 5414223 | 20241027111633_eA3y1 | US002R | 2024-10-30T12:06:57.457Z | 2024-11-05T14:26:59.683Z |
5413850 | 5413850 | 20241027103434_Gx2ja | US002R | 2024-10-30T12:05:57.234Z | 2024-11-05T14:26:58.531Z |
5413803 | 5413803 | 20241027102913_ELz3K | US002R | 2024-10-30T12:05:50.321Z | 2024-11-05T14:26:58.310Z |
5412188 | 5412188 | 20241027100815_6LfkT | US002R | 2024-10-29T12:19:32.809Z | 2024-11-05T14:26:57.835Z |
5412136 | 5412136 | 20241027100429_3k3Fz | US002R | 2024-10-29T12:19:29.799Z | 2024-11-05T14:26:57.677Z |
5411563 | 5411563 | 20241027085403_Se9Lg | US002R | 2024-10-29T12:19:00.456Z | 2024-11-05T14:26:54.880Z |
5411552 | 5411552 | 20241027085250_BxWRW | US002R | 2024-10-29T12:18:59.609Z | 2024-11-05T14:26:54.843Z |
5411460 | 5411460 | 20241027084333_P3VEB | US002R | 2024-10-29T12:18:54.368Z | 2024-11-05T14:26:54.302Z |
5411383 | 5411383 | 20241027083158_2nbY6 | US002R | 2024-10-29T12:18:46.820Z | 2024-11-05T14:26:54.055Z |
5411317 | 5411317 | 20241027082530_IGdSQ | US002R | 2024-10-29T12:18:42.428Z | 2024-11-05T14:26:53.467Z |
5411251 | 5411251 | 20241027081916_7Gtb0 | US002R | 2024-10-29T12:18:37.707Z | 2024-11-05T14:26:53.181Z |
5411237 | 5411237 | 20241027081714_3SvmO | US002R | 2024-10-29T12:18:36.741Z | 2024-11-05T14:26:53.087Z |
5411117 | 5411117 | 20241027063142_Sp0Rn | US002R | 2024-10-29T12:18:26.031Z | 2024-11-04T14:29:07.150Z |
5401694 | 5401694 | 20241026102245_ZOP7m | US002R | 2024-10-29T12:03:31.298Z | 2024-11-04T14:28:31.182Z |
5401651 | 5401651 | 20241026084642_8T5o8 | US002R | 2024-10-29T12:02:46.894Z | 2024-11-04T14:28:26.173Z |
5401623 | 5401623 | 20241026080248_D3C1O | US002R | 2024-10-29T12:02:29.363Z | 2024-11-04T14:28:24.797Z |
5401612 | 5401612 | 20241026074755_3dNoE | US002R | 2024-10-29T12:02:24.520Z | 2024-11-04T14:28:23.988Z |
5401603 | 5401603 | 20241026073645_3pBRH | US002R | 2024-10-29T12:02:18.360Z | 2024-11-04T14:28:23.783Z |
5401585 | 5401585 | 20241026065103_v44SW | US002R | 2024-10-29T12:02:01.466Z | 2024-11-04T14:28:22.077Z |
5401566 | 5401566 | 20241027081536_kIa95 | US002R | 2024-10-29T12:01:54.645Z | 2024-11-05T14:26:53.010Z |
5324848 | 5324848 | 20241020113002_pEX0B | US002R | 2024-10-21T12:04:14.577Z | 2024-10-29T12:26:30.204Z |
5324634 | 5324634 | 20241020104400_NkuO0 | US002R | 2024-10-21T12:03:31.714Z | 2024-10-29T12:26:29.623Z |
5324588 | 5324588 | 20241020103738_JD7xg | US002R | 2024-10-21T12:03:14.276Z | 2024-10-29T12:26:29.505Z |
5323919 | 5323919 | 20241020075009_uzLXD | US002R | 2024-10-21T12:01:00.321Z | 2024-10-29T12:26:27.751Z |
5319383 | 5319383 | 20241018113302_eXKGI | US002R | 2024-10-19T12:02:00.091Z | 2024-10-27T12:28:47.700Z |
5319148 | 5319148 | 20241018091547_XjG3E | US002R | 2024-10-19T12:01:16.229Z | 2024-10-27T12:28:46.792Z |
5319067 | 5319067 | 20241018082132_rT0vg | US002R | 2024-10-19T12:00:58.603Z | 2024-10-27T12:28:46.482Z |
5318214 | 5318214 | 20241017005929_qfl7w | US002R | 2024-10-18T12:03:08.837Z | 2024-10-25T12:24:33.800Z |
5317803 | 5317803 | 20241017093951_2RUOV | US002R | 2024-10-18T12:00:51.082Z | 2024-10-26T12:27:51.362Z |
5317783 | 5317783 | 20241017092845_yCpUj | US002R | 2024-10-18T12:00:49.023Z | 2024-10-26T12:27:51.294Z |
5317719 | 5317719 | 20241017085725_K6Mbf | US002R | 2024-10-18T12:00:38.384Z | 2024-10-26T12:27:50.890Z |
5317673 | 5317673 | 20241017082259_ByxDB | US002R | 2024-10-18T12:00:29.364Z | 2024-10-26T12:27:50.803Z |
5317582 | 5317582 | 20241017063426_3whNu | US002R | 2024-10-18T12:00:16.396Z | 2024-10-26T12:27:50.539Z |
5315038 | 5315038 | 20241015113156_QlGVd | US002R | 2024-10-17T12:04:07.915Z | 2024-10-24T12:27:49.397Z |
5314967 | 5314967 | 20241015112208_LPe3T | US002R | 2024-10-17T12:04:02.697Z | 2024-10-24T12:27:48.410Z |
5314069 | 5314069 | 20241016112647_1DEU1 | US002R | 2024-10-17T12:01:39.562Z | 2024-10-25T12:24:28.620Z |
5313884 | 5313884 | 20241016103715_ijptr | US002R | 2024-10-17T12:01:15.091Z | 2024-10-25T12:24:27.660Z |
5313776 | 5313776 | 20241016100456_TUZBv | US002R | 2024-10-17T12:00:59.835Z | 2024-10-25T12:24:27.067Z |
5313701 | 5313701 | 20241016093947_PGQQj | US002R | 2024-10-17T12:00:51.781Z | 2024-10-25T12:24:26.725Z |
5313656 | 5313656 | 20241016092400_OjNmd | US002R | 2024-10-17T12:00:46.860Z | 2024-10-25T12:24:26.338Z |
5309082 | 5309082 | 20241014112345_A1pk6 | US002R | 2024-10-16T12:04:49.098Z | 2024-10-23T12:24:22.900Z |
5308937 | 5308937 | 20241014110231_E8cKk | US002R | 2024-10-16T12:04:30.685Z | 2024-10-23T12:24:21.462Z |
5308592 | 5308592 | 20241014101558_B8h7j | US002R | 2024-10-16T12:04:01.361Z | 2024-10-23T12:24:17.885Z |
5308493 | 5308493 | 20241014100213_q8J6l | US002R | 2024-10-16T12:03:44.930Z | 2024-10-23T12:24:16.802Z |
5308409 | 5308409 | 20241014094705_yED3X | US002R | 2024-10-16T12:03:36.162Z | 2024-10-23T12:24:15.897Z |
5308396 | 5308396 | 20241014094017_ZJwDs | US002R | 2024-10-16T12:03:34.833Z | 2024-10-23T12:24:15.633Z |
5308343 | 5308343 | 20241014092925_gbhD2 | US002R | 2024-10-16T12:03:29.708Z | 2024-10-23T12:24:14.998Z |
5308330 | 5308330 | 20241014092658_EE5FS | US002R | 2024-10-16T12:03:28.497Z | 2024-10-23T12:24:14.927Z |
5308262 | 5308262 | 20241014091025_3cI9E | US002R | 2024-10-16T12:03:23.834Z | 2024-10-23T12:24:14.456Z |
5307803 | 5307803 | 20241015110610_tZNeg | US002R | 2024-10-16T12:02:17.223Z | 2024-10-24T12:27:46.751Z |
5307785 | 5307785 | 20241015110409_dkz3j | US002R | 2024-10-16T12:02:15.432Z | 2024-10-24T12:27:46.571Z |
5307707 | 5307707 | 20241015104924_ZSGtp | US002R | 2024-10-16T12:02:07.429Z | 2024-10-24T12:27:45.790Z |
5307466 | 5307466 | 20241015100752_u5Y0V | US002R | 2024-10-16T12:01:34.598Z | 2024-10-24T12:27:43.679Z |
5307382 | 5307382 | 20241015094324_XzBFw | US002R | 2024-10-16T12:01:23.731Z | 2024-10-24T12:27:43.129Z |
5307264 | 5307264 | 20241015091137_XOjBv | US002R | 2024-10-16T12:01:03.984Z | 2024-10-24T12:27:41.834Z |
5307242 | 5307242 | 20241015090032_WOp2k | US002R | 2024-10-16T12:01:00.682Z | 2024-10-24T12:27:41.503Z |
5306962 | 5306962 | 20241015062857_gOt5P | US002R | 2024-10-16T12:00:20.247Z | 2024-10-24T12:27:37.792Z |
5304164 | 5304164 | 20241013042228_q5Erl | US002R | 2024-10-14T12:17:43.872Z | 2024-10-21T12:24:23.857Z |
5296404 | 5296404 | 20241012101301_AUSuU | US002R | 2024-10-14T12:06:00.518Z | 2024-10-21T12:23:03.343Z |
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);