participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,084 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 |
---|---|---|---|---|---|
5563893 | 5563893 | 20241120021301_v9rbn | US002R | 2024-11-21T14:16:55.317Z | 2024-11-21T14:18:53.940Z |
5560074 | 5560074 | 20241120115542_Ui63D | US002R | 2024-11-21T14:07:59.870Z | 2024-11-21T14:07:59.870Z |
5560068 | 5560068 | 20241120115404_pNbtf | US002R | 2024-11-21T14:07:58.796Z | 2024-11-21T14:07:58.796Z |
5559940 | 5559940 | 20241120113646_5hOEV | US002R | 2024-11-21T14:07:37.073Z | 2024-11-21T14:07:37.073Z |
5559885 | 5559885 | 20241120113021_8vmS3 | US002R | 2024-11-21T14:07:28.040Z | 2024-11-21T14:07:28.040Z |
5559541 | 5559541 | 20241120103926_1vWas | US002R | 2024-11-21T14:06:33.905Z | 2024-11-21T14:06:33.905Z |
5559492 | 5559492 | 20241120103322_UYfZ7 | US002R | 2024-11-21T14:06:27.210Z | 2024-11-21T14:06:27.210Z |
5559455 | 5559455 | 20241120102536_iGKAm | US002R | 2024-11-21T14:06:22.099Z | 2024-11-21T14:06:22.099Z |
5559390 | 5559390 | 20241120101653_76rwl | US002R | 2024-11-21T14:06:13.409Z | 2024-11-21T14:06:13.409Z |
5559283 | 5559283 | 20241120095517_FbPWL | US002R | 2024-11-21T14:05:50.389Z | 2024-11-21T14:05:50.389Z |
5559243 | 5559243 | 20241120094616_kspi8 | US002R | 2024-11-21T14:05:42.179Z | 2024-11-21T14:05:42.179Z |
5559124 | 5559124 | 20241120092649_2Ykqp | US002R | 2024-11-21T14:05:25.829Z | 2024-11-21T14:05:25.829Z |
5559105 | 5559105 | 20241120092500_dLzdT | US002R | 2024-11-21T14:05:22.470Z | 2024-11-21T14:05:22.470Z |
5559085 | 5559085 | 20241120092111_Z7Z1t | US002R | 2024-11-21T14:05:17.525Z | 2024-11-21T14:05:17.525Z |
5558807 | 5558807 | 20241120081131_v9q56 | US002R | 2024-11-21T14:04:27.284Z | 2024-11-21T14:04:27.284Z |
5558792 | 5558792 | 20241120080308_vDkS0 | US002R | 2024-11-21T14:04:23.490Z | 2024-11-21T14:04:23.490Z |
5558222 | 5558222 | 20241120054625_uVJ9Z | US002R | 2024-11-21T14:02:46.826Z | 2024-11-21T14:02:46.826Z |
5558004 | 5558004 | 20241120053028_SsX4C | US002R | 2024-11-21T14:02:16.006Z | 2024-11-21T14:02:16.006Z |
5557147 | 5557147 | 20241119041124_bDoSP | US002R | 2024-11-20T14:12:22.061Z | 2024-11-21T14:20:48.335Z |
5557098 | 5557098 | 20241119035308_WGRoE | US002R | 2024-11-20T14:12:17.267Z | 2024-11-21T14:20:46.349Z |
5555136 | 5555136 | 20241119115437_9jqJ8 | US002R | 2024-11-20T14:04:32.083Z | 2024-11-21T14:18:53.209Z |
5554966 | 5554966 | 20241119111221_vDIGG | US002R | 2024-11-20T14:03:57.628Z | 2024-11-21T14:18:53.175Z |
5554958 | 5554958 | 20241119111123_ZidZg | US002R | 2024-11-20T14:03:55.032Z | 2024-11-21T14:18:53.173Z |
5554708 | 5554708 | 20241119101452_MDIbL | US002R | 2024-11-20T14:03:05.540Z | 2024-11-21T14:18:53.116Z |
5554673 | 5554673 | 20241119100331_U4efl | US002R | 2024-11-20T14:02:59.148Z | 2024-11-21T14:18:53.107Z |
5554568 | 5554568 | 20241119093815_3L6ge | US002R | 2024-11-20T14:02:30.308Z | 2024-11-21T14:18:53.083Z |
5554382 | 5554382 | 20241119083817_k6hbJ | US002R | 2024-11-20T14:01:49.989Z | 2024-11-21T14:18:53.042Z |
5554325 | 5554325 | 20241119081505_BE9yP | US002R | 2024-11-20T14:01:39.748Z | 2024-11-21T14:18:53.027Z |
5554168 | 5554168 | 20241119064754_NF8YX | US002R | 2024-11-20T14:01:00.118Z | 2024-11-21T14:18:52.991Z |
5554112 | 5554112 | 20241119061046_uXN8W | US002R | 2024-11-20T14:00:46.127Z | 2024-11-21T14:18:52.980Z |
5554085 | 5554085 | 20241119060501_qJRDu | US002R | 2024-11-20T14:00:41.791Z | 2024-11-21T14:18:52.974Z |
5544213 | 5544213 | 20241116083422_lzway | US002R | 2024-11-17T14:00:29.194Z | 2024-11-21T14:22:28.854Z |
5542565 | 5542565 | 20241115105844_lYzO5 | US002R | 2024-11-16T14:01:48.499Z | 2024-11-21T14:23:29.726Z |
5542531 | 5542531 | 20241115104430_OR7Lf | US002R | 2024-11-16T14:01:38.198Z | 2024-11-21T14:23:29.154Z |
5542529 | 5542529 | 20241115104326_BibnX | US002R | 2024-11-16T14:01:37.628Z | 2024-11-21T14:23:29.120Z |
5542395 | 5542395 | 20241115091226_a3F2k | US002R | 2024-11-16T14:01:09.240Z | 2024-11-21T14:23:26.498Z |
5542310 | 5542310 | 20241115082247_nkAjj | US002R | 2024-11-16T14:00:56.798Z | 2024-11-21T14:23:25.181Z |
5542273 | 5542273 | 20241115075320_3Qlg9 | US002R | 2024-11-16T14:00:51.955Z | 2024-11-21T14:23:24.773Z |
5542245 | 5542245 | 20241115073954_prbr0 | US002R | 2024-11-16T14:00:47.836Z | 2024-11-21T14:23:23.840Z |
5542202 | 5542202 | 20241115071011_AIt7j | US002R | 2024-11-16T14:00:39.081Z | 2024-11-21T14:23:22.834Z |
5542193 | 5542193 | 20241115070238_xwBjp | US002R | 2024-11-16T14:00:37.080Z | 2024-11-21T14:23:22.533Z |
5540590 | 5540590 | 20241114113635_2bdU3 | US002R | 2024-11-15T14:04:06.523Z | 2024-11-21T14:24:13.823Z |
5540357 | 5540357 | 20241114104323_NwuVb | US002R | 2024-11-15T14:03:29.875Z | 2024-11-21T14:24:10.666Z |
5540106 | 5540106 | 20241114100942_C608P | US002R | 2024-11-15T14:02:57.549Z | 2024-11-21T14:24:08.005Z |
5540053 | 5540053 | 20241114095615_ngRh9 | US002R | 2024-11-15T14:02:44.389Z | 2024-11-21T14:24:07.385Z |
5540036 | 5540036 | 20241114095319_uiUBw | US002R | 2024-11-15T14:02:40.340Z | 2024-11-21T14:24:07.199Z |
5539980 | 5539980 | 20241114094203_dvrNm | US002R | 2024-11-15T14:02:28.715Z | 2024-11-21T14:24:06.375Z |
5539578 | 5539578 | 20241114075821_Ey8HY | US002R | 2024-11-15T14:01:27.764Z | 2024-11-21T14:23:57.821Z |
5539492 | 5539492 | 20241114072924_9ROlW | US002R | 2024-11-15T14:01:08.568Z | 2024-11-21T14:23:56.595Z |
5539224 | 5539224 | 20241114055103_2c32E | US002R | 2024-11-15T14:00:24.144Z | 2024-11-21T14:23:51.450Z |
5539016 | 5539016 | 20241113053302_MWAtS | US002R | 2024-11-14T14:14:08.497Z | 2024-11-21T14:26:31.010Z |
5535183 | 5535183 | 20241112115314_wsmdh | US002R | 2024-11-14T14:07:26.411Z | 2024-11-21T14:25:44.897Z |
5534950 | 5534950 | 20241112111527_6jYRI | US002R | 2024-11-14T14:07:01.440Z | 2024-11-21T14:25:41.874Z |
5534911 | 5534911 | 20241112110807_jFDg0 | US002R | 2024-11-14T14:06:58.737Z | 2024-11-21T14:25:41.568Z |
5532965 | 5532965 | 20241113063011_sLD6M | US002R | 2024-11-14T14:00:40.515Z | 2024-11-21T14:24:42.605Z |
5531094 | 5531094 | 20241112031349_vhO8e | US002R | 2024-11-13T14:15:12.535Z | 2024-11-20T14:26:07.652Z |
5529618 | 5529618 | 20241112004304_uHMej | US002R | 2024-11-13T14:13:02.023Z | 2024-11-20T14:25:46.776Z |
5526729 | 5526729 | 20241112100721_M9eSY | US002R | 2024-11-13T14:04:01.437Z | 2024-11-21T14:25:37.453Z |
5526721 | 5526721 | 20241112100557_Eu3us | US002R | 2024-11-13T14:04:00.400Z | 2024-11-21T14:25:37.412Z |
5526650 | 5526650 | 20241112095847_2T3vm | US002R | 2024-11-13T14:03:43.619Z | 2024-11-21T14:25:36.991Z |
5526399 | 5526399 | 20241112091251_Grmic | US002R | 2024-11-13T14:02:54.474Z | 2024-11-21T14:25:34.713Z |
5526356 | 5526356 | 20241112090517_i4aBH | US002R | 2024-11-13T14:02:46.829Z | 2024-11-21T14:25:34.444Z |
5526294 | 5526294 | 20241112085445_JahGX | US002R | 2024-11-13T14:02:38.311Z | 2024-11-21T14:25:33.902Z |
5526011 | 5526011 | 20241112074458_nmKvq | US002R | 2024-11-13T14:01:28.840Z | 2024-11-21T14:25:29.947Z |
5525944 | 5525944 | 20241112072807_vG9mP | US002R | 2024-11-13T14:01:17.342Z | 2024-11-21T14:25:29.183Z |
5524665 | 5524665 | 20241111050323_7Fz9R | US002R | 2024-11-12T14:17:52.125Z | 2024-11-19T14:22:23.267Z |
5524632 | 5524632 | 20241111044915_u0WEY | US002R | 2024-11-12T14:17:47.884Z | 2024-11-19T14:22:23.071Z |
5524507 | 5524507 | 20241111042332_2qo8W | US002R | 2024-11-12T14:17:30.059Z | 2024-11-19T14:22:21.813Z |
5524480 | 5524480 | 20241111041921_AHkk5 | US002R | 2024-11-12T14:17:24.501Z | 2024-11-19T14:22:21.533Z |
5524209 | 5524209 | 20241111033314_pcic8 | US002R | 2024-11-12T14:16:46.149Z | 2024-11-19T14:22:18.795Z |
5523820 | 5523820 | 20241111022923_lc5tq | US002R | 2024-11-12T14:16:15.553Z | 2024-11-19T14:22:15.403Z |
5519546 | 5519546 | 20241111115541_LZVvF | US002R | 2024-11-12T14:04:28.969Z | 2024-11-20T14:24:52.037Z |
5519524 | 5519524 | 20241111114614_44ue9 | US002R | 2024-11-12T14:04:22.750Z | 2024-11-20T14:24:51.616Z |
5519335 | 5519335 | 20241111110218_GNSzW | US002R | 2024-11-12T14:03:47.121Z | 2024-11-20T14:24:47.646Z |
5519325 | 5519325 | 20241111110034_xLBRo | US002R | 2024-11-12T14:03:46.097Z | 2024-11-20T14:24:47.529Z |
5519265 | 5519265 | 20241111105059_iq2rq | US002R | 2024-11-12T14:03:30.804Z | 2024-11-20T14:24:46.938Z |
5518990 | 5518990 | 20241111094914_bXMMC | US002R | 2024-11-12T14:02:33.978Z | 2024-11-20T14:24:43.714Z |
5518981 | 5518981 | 20241111094659_7Fjzr | US002R | 2024-11-12T14:02:32.533Z | 2024-11-20T14:24:43.637Z |
5518794 | 5518794 | 20241111091128_4880d | US002R | 2024-11-12T14:02:05.695Z | 2024-11-20T14:24:41.324Z |
5518754 | 5518754 | 20241111090237_yTYG0 | US002R | 2024-11-12T14:01:51.547Z | 2024-11-20T14:24:40.742Z |
5518514 | 5518514 | 20241111080820_brgU4 | US002R | 2024-11-12T14:01:10.925Z | 2024-11-20T14:24:35.661Z |
5517856 | 5517856 | 20241110050326_1XY06 | US002R | 2024-11-11T14:14:56.858Z | 2024-11-18T14:26:38.650Z |
5516519 | 5516519 | 20241110011129_wYlEX | US002R | 2024-11-11T14:13:06.033Z | 2024-11-18T14:26:31.662Z |
5513687 | 5513687 | 20241110120605_OI8rx | US002R | 2024-11-11T14:05:12.936Z | 2024-11-19T14:21:36.890Z |
5513632 | 5513632 | 20241110115838_ug79A | US002R | 2024-11-11T14:05:03.124Z | 2024-11-19T14:21:36.435Z |
5513527 | 5513527 | 20241110114602_JMLzZ | US002R | 2024-11-11T14:04:46.804Z | 2024-11-19T14:21:35.461Z |
5513490 | 5513490 | 20241110113841_dvlM8 | US002R | 2024-11-11T14:04:43.285Z | 2024-11-19T14:21:35.051Z |
5513334 | 5513334 | 20241110111657_3R3M4 | US002R | 2024-11-11T14:04:29.407Z | 2024-11-19T14:21:33.258Z |
5513237 | 5513237 | 20241110110207_WrtlF | US002R | 2024-11-11T14:04:12.937Z | 2024-11-19T14:21:32.136Z |
5513045 | 5513045 | 20241110102822_n9RCu | US002R | 2024-11-11T14:03:48.038Z | 2024-11-19T14:21:30.658Z |
5513004 | 5513004 | 20241110102057_Hcw4M | US002R | 2024-11-11T14:03:43.872Z | 2024-11-19T14:21:30.257Z |
5512983 | 5512983 | 20241110101759_Q8Jz7 | US002R | 2024-11-11T14:03:42.572Z | 2024-11-19T14:21:30.154Z |
5512431 | 5512431 | 20241110084825_K3TRn | US002R | 2024-11-11T14:02:18.169Z | 2024-11-19T14:21:24.313Z |
5512356 | 5512356 | 20241110083721_cxrSZ | US002R | 2024-11-11T14:02:10.078Z | 2024-11-19T14:21:23.612Z |
5511975 | 5511975 | 20241110073649_CHCy2 | US002R | 2024-11-11T14:01:16.212Z | 2024-11-19T14:21:18.660Z |
5511742 | 5511742 | 20241110064813_x20Uc | US002R | 2024-11-11T14:00:42.603Z | 2024-11-19T14:21:15.690Z |
5511687 | 5511687 | 20241110063814_BT5SA | US002R | 2024-11-11T14:00:32.780Z | 2024-11-19T14:21:15.244Z |
5506898 | 5506898 | 20241109095631_86WYG | US002R | 2024-11-10T14:03:44.448Z | 2024-11-18T14:26:03.423Z |
5497924 | 5497924 | 20241107060800_40Qc8 | US002R | 2024-11-08T14:14:30.854Z | 2024-11-15T14:25:06.755Z |
5497884 | 5497884 | 20241107054743_ZrXH4 | US002R | 2024-11-08T14:14:28.921Z | 2024-11-15T14:25:06.584Z |
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);