participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,204 rows where station_code = "CA002U" 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 |
---|---|---|---|---|---|
5503752 | 5503752 | 20241107234429_YSiYW | CA002U | 2024-11-09T14:13:42.740Z | 2024-11-09T14:16:28.338Z |
5492785 | 5492785 | 20241107095611_JUwwt | CA002U | 2024-11-08T14:02:05.454Z | 2024-11-09T14:16:27.454Z |
5492767 | 5492767 | 20241107095352_V8W2J | CA002U | 2024-11-08T14:02:03.507Z | 2024-11-09T14:16:27.450Z |
5492757 | 5492757 | 20241107095202_JNbhG | CA002U | 2024-11-08T14:02:02.407Z | 2024-11-09T14:16:27.447Z |
5478761 | 5478761 | 20241104054704_2PYDl | CA002U | 2024-11-05T14:18:47.917Z | 2024-11-09T14:22:31.170Z |
5478030 | 5478030 | 20241104031028_QX19k | CA002U | 2024-11-05T14:17:46.441Z | 2024-11-09T14:22:23.804Z |
5469167 | 5469167 | 20241103024255_zw44M | CA002U | 2024-11-04T14:15:47.583Z | 2024-11-09T14:23:01.153Z |
5465074 | 5465074 | 20241103103408_8zO27 | CA002U | 2024-11-04T14:02:38.265Z | 2024-11-09T14:21:30.513Z |
5465025 | 5465025 | 20241103102438_Tyrpd | CA002U | 2024-11-04T14:02:30.211Z | 2024-11-09T14:21:30.260Z |
5464982 | 5464982 | 20241103100920_Qtc2R | CA002U | 2024-11-04T14:02:23.013Z | 2024-11-09T14:21:30.041Z |
5464960 | 5464960 | 20241103100624_SlGg2 | CA002U | 2024-11-04T14:02:18.817Z | 2024-11-09T14:21:29.938Z |
5464917 | 5464917 | 20241103095140_egjkc | CA002U | 2024-11-04T14:02:11.993Z | 2024-11-09T14:21:29.597Z |
5464856 | 5464856 | 20241103093848_etgKZ | CA002U | 2024-11-04T14:01:54.072Z | 2024-11-09T14:21:29.311Z |
5464758 | 5464758 | 20241103090711_81BNy | CA002U | 2024-11-04T14:01:35.678Z | 2024-11-09T14:21:28.643Z |
5464718 | 5464718 | 20241103085943_ZkeLO | CA002U | 2024-11-04T14:01:29.569Z | 2024-11-09T14:21:28.059Z |
5464601 | 5464601 | 20241103082931_73Zke | CA002U | 2024-11-04T14:01:04.822Z | 2024-11-09T14:21:26.866Z |
5464594 | 5464594 | 20241103082800_73nWc | CA002U | 2024-11-04T14:01:03.580Z | 2024-11-09T14:21:26.822Z |
5464566 | 5464566 | 20241103081838_IO2q8 | CA002U | 2024-11-04T14:00:58.046Z | 2024-11-09T14:21:26.636Z |
5464532 | 5464532 | 20241103080613_XXDx7 | CA002U | 2024-11-04T14:00:52.563Z | 2024-11-09T14:21:26.462Z |
5464460 | 5464460 | 20241103072841_YqXIk | CA002U | 2024-11-04T14:00:33.791Z | 2024-11-09T14:21:25.668Z |
5464455 | 5464455 | 20241103072709_zeZEq | CA002U | 2024-11-04T14:00:31.609Z | 2024-11-09T14:21:25.630Z |
5463723 | 5463723 | 20241102044634_3OQjz | CA002U | 2024-11-03T14:19:11.894Z | 2024-11-09T14:23:43.558Z |
5463716 | 5463716 | 20241102044200_bIvvf | CA002U | 2024-11-03T14:19:11.577Z | 2024-11-09T14:23:43.553Z |
5463138 | 5463138 | 20241102023920_H3JMH | CA002U | 2024-11-03T14:18:22.011Z | 2024-11-09T14:23:38.113Z |
5462954 | 5462954 | 20241102020416_jkAV1 | CA002U | 2024-11-03T14:18:11.139Z | 2024-11-09T14:23:36.917Z |
5462501 | 5462501 | 20241102003504_yHpnl | CA002U | 2024-11-03T14:17:31.494Z | 2024-11-09T14:23:34.427Z |
5462354 | 5462354 | 20241101235618_W3q12 | CA002U | 2024-11-03T14:17:18.452Z | 2024-11-09T14:23:33.968Z |
5446711 | 5446711 | 20241031102527_k4qBj | CA002U | 2024-11-02T12:06:05.718Z | 2024-11-09T14:23:56.089Z |
5446659 | 5446659 | 20241031101906_IqaVZ | CA002U | 2024-11-02T12:05:59.424Z | 2024-11-09T14:23:55.493Z |
5446530 | 5446530 | 20241031100811_PLVcw | CA002U | 2024-11-02T12:05:31.757Z | 2024-11-09T14:23:55.016Z |
5431952 | 5431952 | 20241029022128_uduql | CA002U | 2024-10-31T12:20:52.465Z | 2024-11-06T14:27:25.598Z |
5431781 | 5431781 | 20241029015750_JkvL4 | CA002U | 2024-10-31T12:20:38.103Z | 2024-11-06T14:27:24.833Z |
5431662 | 5431662 | 20241029014409_2Jaww | CA002U | 2024-10-31T12:20:30.433Z | 2024-11-06T14:27:24.377Z |
5431633 | 5431633 | 20241029013902_Jay3e | CA002U | 2024-10-31T12:20:27.067Z | 2024-11-06T14:27:24.301Z |
5431499 | 5431499 | 20241029012140_F655C | CA002U | 2024-10-31T12:20:15.369Z | 2024-11-06T14:27:23.947Z |
5431351 | 5431351 | 20241029005943_FXY47 | CA002U | 2024-10-31T12:20:00.687Z | 2024-11-06T14:27:23.333Z |
5431200 | 5431200 | 20241029004050_CYqJY | CA002U | 2024-10-31T12:19:45.093Z | 2024-11-06T14:27:22.946Z |
5431155 | 5431155 | 20241029003641_VqSuF | CA002U | 2024-10-31T12:19:40.214Z | 2024-11-06T14:27:22.865Z |
5431064 | 5431064 | 20241029002145_msSIJ | CA002U | 2024-10-31T12:19:32.284Z | 2024-11-06T14:27:22.634Z |
5431036 | 5431036 | 20241029001812_7O0y9 | CA002U | 2024-10-31T12:19:30.401Z | 2024-11-06T14:27:22.534Z |
5430622 | 5430622 | 20241028231242_AU3Tj | CA002U | 2024-10-31T12:18:43.990Z | 2024-11-06T14:27:20.732Z |
5421510 | 5421510 | 20241028064702_5n6Gb | CA002U | 2024-10-30T12:20:01.672Z | 2024-11-05T14:27:18.976Z |
5421418 | 5421418 | 20241028063100_CiZuW | CA002U | 2024-10-30T12:19:55.173Z | 2024-11-05T14:27:18.642Z |
5421405 | 5421405 | 20241028062151_AU3Vw | CA002U | 2024-10-30T12:19:54.493Z | 2024-11-05T14:27:18.612Z |
5421398 | 5421398 | 20241028061757_QrJ5A | CA002U | 2024-10-30T12:19:54.124Z | 2024-11-05T14:27:18.567Z |
5421385 | 5421385 | 20241028061301_9ICsR | CA002U | 2024-10-30T12:19:53.586Z | 2024-11-05T14:27:18.526Z |
5421262 | 5421262 | 20241028052040_agPvT | CA002U | 2024-10-30T12:19:46.131Z | 2024-11-05T14:27:18.032Z |
5421256 | 5421256 | 20241028051824_mPNoj | CA002U | 2024-10-30T12:19:45.905Z | 2024-11-05T14:27:17.935Z |
5421224 | 5421224 | 20241028051040_WSXI2 | CA002U | 2024-10-30T12:19:43.858Z | 2024-11-05T14:27:17.808Z |
5421205 | 5421205 | 20241028050519_wY2xA | CA002U | 2024-10-30T12:19:42.878Z | 2024-11-05T14:27:17.775Z |
5421065 | 5421065 | 20241028042632_Jh51I | CA002U | 2024-10-30T12:19:34.408Z | 2024-11-05T14:27:17.190Z |
5421063 | 5421063 | 20241028042601_DWfCG | CA002U | 2024-10-30T12:19:34.371Z | 2024-11-05T14:27:17.189Z |
5420939 | 5420939 | 20241028035832_yXGyr | CA002U | 2024-10-30T12:19:27.194Z | 2024-11-05T14:27:16.742Z |
5420879 | 5420879 | 20241028034946_hgCNF | CA002U | 2024-10-30T12:19:23.992Z | 2024-11-05T14:27:16.621Z |
5420831 | 5420831 | 20241028034229_5Tz5K | CA002U | 2024-10-30T12:19:21.202Z | 2024-11-05T14:27:16.470Z |
5420829 | 5420829 | 20241028034200_zV3kP | CA002U | 2024-10-30T12:19:21.120Z | 2024-11-05T14:27:16.469Z |
5420810 | 5420810 | 20241028033907_m3fo1 | CA002U | 2024-10-30T12:19:20.027Z | 2024-11-05T14:27:16.413Z |
5420612 | 5420612 | 20241028030757_nzVkH | CA002U | 2024-10-30T12:19:04.828Z | 2024-11-05T14:27:15.891Z |
5420585 | 5420585 | 20241028030215_uzrVX | CA002U | 2024-10-30T12:19:02.575Z | 2024-11-05T14:27:15.786Z |
5420579 | 5420579 | 20241028030130_fIkPb | CA002U | 2024-10-30T12:19:02.332Z | 2024-11-05T14:27:15.783Z |
5420457 | 5420457 | 20241028024349_FJ6RE | CA002U | 2024-10-30T12:18:52.726Z | 2024-11-05T14:27:15.466Z |
5420360 | 5420360 | 20241028023323_ojlw9 | CA002U | 2024-10-30T12:18:45.230Z | 2024-11-05T14:27:15.281Z |
5420337 | 5420337 | 20241028023045_fgWQd | CA002U | 2024-10-30T12:18:43.707Z | 2024-11-05T14:27:15.187Z |
5420251 | 5420251 | 20241028021954_1282C | CA002U | 2024-10-30T12:18:36.749Z | 2024-11-05T14:27:15.016Z |
5420227 | 5420227 | 20241028021542_OQ9eI | CA002U | 2024-10-30T12:18:33.805Z | 2024-11-05T14:27:14.957Z |
5420214 | 5420214 | 20241028021334_36ewf | CA002U | 2024-10-30T12:18:32.891Z | 2024-11-05T14:27:14.854Z |
5420126 | 5420126 | 20241028020027_2NmyN | CA002U | 2024-10-30T12:18:22.801Z | 2024-11-05T14:27:14.606Z |
5420046 | 5420046 | 20241028015213_fVKH2 | CA002U | 2024-10-30T12:18:16.370Z | 2024-11-05T14:27:14.408Z |
5413439 | 5413439 | 20241028100029_i8jQR | CA002U | 2024-10-30T12:03:02.772Z | 2024-11-06T14:27:05.898Z |
5413385 | 5413385 | 20241028095104_waCzo | CA002U | 2024-10-30T12:02:54.111Z | 2024-11-06T14:27:05.555Z |
5413313 | 5413313 | 20241028093630_l63cZ | CA002U | 2024-10-30T12:02:41.493Z | 2024-11-06T14:27:05.238Z |
5413255 | 5413255 | 20241028092317_e3z3k | CA002U | 2024-10-30T12:02:25.757Z | 2024-11-06T14:27:05.112Z |
5413130 | 5413130 | 20241028085507_z9l9t | CA002U | 2024-10-30T12:01:59.300Z | 2024-11-06T14:27:04.456Z |
5413005 | 5413005 | 20241028083141_UIA8q | CA002U | 2024-10-30T12:01:32.639Z | 2024-11-06T14:27:03.979Z |
5413000 | 5413000 | 20241028083113_63kHD | CA002U | 2024-10-30T12:01:31.900Z | 2024-11-06T14:27:03.960Z |
5412818 | 5412818 | 20241028074209_87XT3 | CA002U | 2024-10-30T12:00:51.350Z | 2024-11-06T14:27:02.843Z |
5412806 | 5412806 | 20241028073828_v9kiB | CA002U | 2024-10-30T12:00:44.514Z | 2024-11-06T14:27:02.729Z |
5412750 | 5412750 | 20241028072047_naqiv | CA002U | 2024-10-30T12:00:32.683Z | 2024-11-06T14:27:02.112Z |
5412705 | 5412705 | 20241028070844_tR92X | CA002U | 2024-10-30T12:00:24.622Z | 2024-11-06T14:27:01.745Z |
5411262 | 5411262 | 20241027082149_xVtK7 | CA002U | 2024-10-29T12:18:37.873Z | 2024-11-05T14:26:53.220Z |
5411196 | 5411196 | 20241027064143_Rhp23 | CA002U | 2024-10-29T12:18:33.259Z | 2024-11-04T14:29:07.339Z |
5411102 | 5411102 | 20241027062835_EyVCU | CA002U | 2024-10-29T12:18:24.824Z | 2024-11-04T14:29:07.102Z |
5411046 | 5411046 | 20241027061217_2bfUm | CA002U | 2024-10-29T12:18:19.775Z | 2024-11-04T14:29:06.917Z |
5411012 | 5411012 | 20241027060606_BVIbF | CA002U | 2024-10-29T12:18:18.431Z | 2024-11-04T14:29:06.837Z |
5411009 | 5411009 | 20241027060601_L7E9R | CA002U | 2024-10-29T12:18:18.416Z | 2024-11-04T14:29:06.836Z |
5410835 | 5410835 | 20241027053958_Agtdc | CA002U | 2024-10-29T12:18:05.906Z | 2024-11-04T14:29:05.641Z |
5410764 | 5410764 | 20241027053502_fDn21 | CA002U | 2024-10-29T12:18:04.674Z | 2024-11-04T14:29:05.406Z |
5410730 | 5410730 | 20241027053229_XIO9N | CA002U | 2024-10-29T12:18:03.645Z | 2024-11-04T14:29:05.338Z |
5410399 | 5410399 | 20241027051140_J5WA7 | CA002U | 2024-10-29T12:17:55.229Z | 2024-11-04T14:29:04.546Z |
5409997 | 5409997 | 20241027044729_Y4DH4 | CA002U | 2024-10-29T12:17:45.632Z | 2024-11-04T14:29:03.242Z |
5409181 | 5409181 | 20241027040421_m4V5K | CA002U | 2024-10-29T12:17:10.445Z | 2024-11-04T14:29:01.351Z |
5408558 | 5408558 | 20241027033024_BZSi2 | CA002U | 2024-10-29T12:16:36.061Z | 2024-11-04T14:28:59.617Z |
5408542 | 5408542 | 20241027032959_nR9I4 | CA002U | 2024-10-29T12:16:35.384Z | 2024-11-04T14:28:59.611Z |
5407621 | 5407621 | 20241027024430_3b6CQ | CA002U | 2024-10-29T12:15:31.572Z | 2024-11-04T14:28:57.945Z |
5407358 | 5407358 | 20241027023300_A2bDX | CA002U | 2024-10-29T12:15:22.354Z | 2024-11-04T14:28:57.402Z |
5407244 | 5407244 | 20241027022814_BMuX9 | CA002U | 2024-10-29T12:15:18.584Z | 2024-11-04T14:28:57.260Z |
5407008 | 5407008 | 20241027021625_SFjoZ | CA002U | 2024-10-29T12:15:08.330Z | 2024-11-04T14:28:56.771Z |
5405856 | 5405856 | 20241027010331_BdhP0 | CA002U | 2024-10-29T12:13:24.619Z | 2024-11-04T14:28:54.543Z |
5404872 | 5404872 | 20241026235806_Y4T1M | CA002U | 2024-10-29T12:12:04.275Z | 2024-11-04T14:28:52.227Z |
5404868 | 5404868 | 20241026235739_GS5yW | CA002U | 2024-10-29T12:12:03.817Z | 2024-11-04T14:28:52.216Z |
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);