participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,623 rows where station_code = "CA000R" 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 |
---|---|---|---|---|---|
5552375 | 5552375 | 20241117095107_zGwL3 | CA000R | 2024-11-19T14:07:00.486Z | 2024-11-26T14:28:25.922Z |
5549476 | 5549476 | 20241117050022_uuqLr | CA000R | 2024-11-18T14:11:40.832Z | 2024-11-25T14:22:47.355Z |
5549369 | 5549369 | 20241117043627_7DmzP | CA000R | 2024-11-18T14:11:30.896Z | 2024-11-25T14:22:47.056Z |
5549343 | 5549343 | 20241117043023_0yNM3 | CA000R | 2024-11-18T14:11:29.123Z | 2024-11-25T14:22:46.993Z |
5549229 | 5549229 | 20241117035706_eFJud | CA000R | 2024-11-18T14:11:19.621Z | 2024-11-25T14:22:46.722Z |
5548963 | 5548963 | 20241117023057_RFYuN | CA000R | 2024-11-18T14:10:33.423Z | 2024-11-25T14:22:45.918Z |
5548796 | 5548796 | 20241117014215_vyep4 | CA000R | 2024-11-18T14:10:13.751Z | 2024-11-25T14:22:45.440Z |
5548784 | 5548784 | 20241117014058_irUcS | CA000R | 2024-11-18T14:10:12.694Z | 2024-11-25T14:22:45.411Z |
5548606 | 5548606 | 20241117003138_eW2c2 | CA000R | 2024-11-18T14:09:34.731Z | 2024-11-25T14:22:44.758Z |
5546248 | 5546248 | 20241117100609_b3kgo | CA000R | 2024-11-18T14:02:34.839Z | 2024-11-26T14:28:26.126Z |
5546147 | 5546147 | 20241117093110_2L8c1 | CA000R | 2024-11-18T14:02:18.444Z | 2024-11-26T14:28:25.683Z |
5546101 | 5546101 | 20241117091407_lBaXX | CA000R | 2024-11-18T14:02:03.303Z | 2024-11-26T14:28:25.438Z |
5546018 | 5546018 | 20241117084849_BCh1P | CA000R | 2024-11-18T14:01:43.955Z | 2024-11-26T14:28:24.704Z |
5545943 | 5545943 | 20241117081143_pWm7z | CA000R | 2024-11-18T14:01:31.717Z | 2024-11-26T14:28:24.392Z |
5545894 | 5545894 | 20241117074250_2kbF2 | CA000R | 2024-11-18T14:01:19.553Z | 2024-11-26T14:28:23.898Z |
5545875 | 5545875 | 20241117074153_4FSBj | CA000R | 2024-11-18T14:01:17.825Z | 2024-11-26T14:28:23.837Z |
5545831 | 5545831 | 20241117071550_KOILG | CA000R | 2024-11-18T14:01:07.030Z | 2024-11-26T14:28:23.466Z |
5545787 | 5545787 | 20241117065913_prHpc | CA000R | 2024-11-18T14:00:57.673Z | 2024-11-26T14:28:23.239Z |
5545761 | 5545761 | 20241117064334_2GzD5 | CA000R | 2024-11-18T14:00:53.377Z | 2024-11-26T14:28:23.001Z |
5545722 | 5545722 | 20241117062334_DFGCj | CA000R | 2024-11-18T14:00:46.481Z | 2024-11-26T14:28:22.790Z |
5545711 | 5545711 | 20241117062134_otEb2 | CA000R | 2024-11-18T14:00:45.178Z | 2024-11-26T14:28:22.540Z |
5545708 | 5545708 | 20241117061941_zNU6x | CA000R | 2024-11-18T14:00:44.750Z | 2024-11-26T14:28:22.388Z |
5545644 | 5545644 | 20241117055834_2q5c2 | CA000R | 2024-11-18T14:00:31.384Z | 2024-11-26T14:28:21.944Z |
5545617 | 5545617 | 20241117054416_h24WM | CA000R | 2024-11-18T14:00:27.854Z | 2024-11-26T14:28:21.815Z |
5545608 | 5545608 | 20241117053709_QgcwH | CA000R | 2024-11-18T14:00:26.136Z | 2024-11-26T14:28:21.718Z |
5545584 | 5545584 | 20241117053214_cr2y6 | CA000R | 2024-11-18T14:00:22.752Z | 2024-11-26T14:28:21.639Z |
5545103 | 5545103 | 20241116001439_vIZ6J | CA000R | 2024-11-17T14:03:47.823Z | 2024-11-24T14:25:42.239Z |
5544038 | 5544038 | 20241115052733_rDsQX | CA000R | 2024-11-16T14:07:52.159Z | 2024-11-23T14:26:22.731Z |
5543816 | 5543816 | 20241115034354_UzUrL | CA000R | 2024-11-16T14:07:19.416Z | 2024-11-23T14:26:21.405Z |
5543659 | 5543659 | 20241115024423_9cGSY | CA000R | 2024-11-16T14:06:59.032Z | 2024-11-23T14:26:20.208Z |
5543580 | 5543580 | 20241115021831_WL2om | CA000R | 2024-11-16T14:06:50.774Z | 2024-11-23T14:26:19.888Z |
5543478 | 5543478 | 20241115013826_jilAs | CA000R | 2024-11-16T14:06:27.875Z | 2024-11-23T14:26:19.069Z |
5543429 | 5543429 | 20241115012131_3qsIc | CA000R | 2024-11-16T14:06:19.438Z | 2024-11-23T14:26:18.940Z |
5542054 | 5542054 | 20241114053431_ArkEo | CA000R | 2024-11-15T14:08:51.370Z | 2024-11-22T14:24:21.917Z |
5542045 | 5542045 | 20241114053338_q8UGS | CA000R | 2024-11-15T14:08:50.857Z | 2024-11-22T14:24:21.885Z |
5541702 | 5541702 | 20241114035921_5E80N | CA000R | 2024-11-15T14:08:12.691Z | 2024-11-22T14:24:20.002Z |
5541634 | 5541634 | 20241114032617_E1ah0 | CA000R | 2024-11-15T14:08:00.575Z | 2024-11-22T14:24:19.726Z |
5541497 | 5541497 | 20241114021017_hMAHJ | CA000R | 2024-11-15T14:07:45.106Z | 2024-11-22T14:24:19.231Z |
5541419 | 5541419 | 20241114014303_RmKzy | CA000R | 2024-11-15T14:07:36.210Z | 2024-11-22T14:24:18.677Z |
5541303 | 5541303 | 20241114000659_HopdH | CA000R | 2024-11-15T14:07:24.930Z | 2024-11-22T14:24:17.974Z |
5541277 | 5541277 | 20241113233612_AbEVP | CA000R | 2024-11-15T14:07:21.512Z | 2024-11-22T14:24:17.740Z |
5540015 | 5540015 | 20241114094849_4GpCm | CA000R | 2024-11-15T14:02:32.633Z | 2024-11-23T14:26:08.525Z |
5539955 | 5539955 | 20241114093700_Nlp03 | CA000R | 2024-11-15T14:02:24.516Z | 2024-11-23T14:26:08.000Z |
5539872 | 5539872 | 20241114092013_njfjx | CA000R | 2024-11-15T14:02:15.403Z | 2024-11-23T14:26:07.363Z |
5539849 | 5539849 | 20241114091240_g2yCu | CA000R | 2024-11-15T14:02:11.592Z | 2024-11-23T14:26:07.199Z |
5539749 | 5539749 | 20241114085109_CfUWr | CA000R | 2024-11-15T14:01:49.963Z | 2024-11-23T14:26:06.381Z |
5539621 | 5539621 | 20241114081246_7sH1T | CA000R | 2024-11-15T14:01:33.012Z | 2024-11-23T14:26:05.105Z |
5539470 | 5539470 | 20241114071744_7nwVW | CA000R | 2024-11-15T14:01:05.124Z | 2024-11-23T14:26:03.661Z |
5539386 | 5539386 | 20241114064110_G5sUp | CA000R | 2024-11-15T14:00:53.306Z | 2024-11-23T14:26:02.892Z |
5539327 | 5539327 | 20241114061832_xvx3k | CA000R | 2024-11-15T14:00:43.832Z | 2024-11-23T14:26:02.312Z |
5539034 | 5539034 | 20241113053603_oODqP | CA000R | 2024-11-14T14:14:09.425Z | 2024-11-21T14:26:31.064Z |
5538844 | 5538844 | 20241113050437_o7C2c | CA000R | 2024-11-14T14:14:00.090Z | 2024-11-21T14:26:29.158Z |
5538828 | 5538828 | 20241113050315_pLDGD | CA000R | 2024-11-14T14:13:59.371Z | 2024-11-21T14:26:28.886Z |
5538251 | 5538251 | 20241113024808_ocjXA | CA000R | 2024-11-14T14:13:08.641Z | 2024-11-21T14:26:22.680Z |
5538210 | 5538210 | 20241113023925_CMrv9 | CA000R | 2024-11-14T14:13:04.149Z | 2024-11-21T14:26:21.710Z |
5537722 | 5537722 | 20241113001936_JFfV7 | CA000R | 2024-11-14T14:12:26.694Z | 2024-11-21T14:26:15.530Z |
5537546 | 5537546 | 20241112233645_4OVwv | CA000R | 2024-11-14T14:12:07.785Z | 2024-11-21T14:26:14.148Z |
5533956 | 5533956 | 20241113103156_JHt4C | CA000R | 2024-11-14T14:03:20.731Z | 2024-11-22T14:24:11.831Z |
5533612 | 5533612 | 20241113093340_KEXf9 | CA000R | 2024-11-14T14:02:30.819Z | 2024-11-22T14:24:10.459Z |
5533524 | 5533524 | 20241113091224_cSd36 | CA000R | 2024-11-14T14:02:18.470Z | 2024-11-22T14:24:09.870Z |
5533453 | 5533453 | 20241113085900_yE1sA | CA000R | 2024-11-14T14:02:01.872Z | 2024-11-22T14:24:09.413Z |
5533320 | 5533320 | 20241113082856_yyE3Y | CA000R | 2024-11-14T14:01:42.522Z | 2024-11-22T14:24:07.983Z |
5533227 | 5533227 | 20241113075340_CLIld | CA000R | 2024-11-14T14:01:28.277Z | 2024-11-22T14:24:07.690Z |
5533116 | 5533116 | 20241113072246_3MoS3 | CA000R | 2024-11-14T14:01:10.376Z | 2024-11-22T14:24:07.142Z |
5533097 | 5533097 | 20241113071329_PTUlA | CA000R | 2024-11-14T14:01:07.865Z | 2024-11-22T14:24:07.069Z |
5533007 | 5533007 | 20241113064347_LjRaj | CA000R | 2024-11-14T14:00:46.949Z | 2024-11-22T14:24:06.622Z |
5532970 | 5532970 | 20241113063109_Wo2nD | CA000R | 2024-11-14T14:00:41.320Z | 2024-11-22T14:24:06.404Z |
5532950 | 5532950 | 20241113062311_iZnbj | CA000R | 2024-11-14T14:00:37.397Z | 2024-11-22T14:24:06.246Z |
5532832 | 5532832 | 20241113060052_DnsQe | CA000R | 2024-11-14T14:00:21.022Z | 2024-11-22T14:24:05.571Z |
5532778 | 5532778 | 20241113055029_7KLW8 | CA000R | 2024-11-14T14:00:11.515Z | 2024-11-22T14:24:04.958Z |
5518144 | 5518144 | 20241110060756_7XAAQ | CA000R | 2024-11-11T14:15:15.895Z | 2024-11-18T14:26:39.665Z |
5518140 | 5518140 | 20241110060617_fvrUV | CA000R | 2024-11-11T14:15:15.606Z | 2024-11-18T14:26:39.653Z |
5518043 | 5518043 | 20241110054649_dgcY0 | CA000R | 2024-11-11T14:15:10.007Z | 2024-11-18T14:26:39.355Z |
5518001 | 5518001 | 20241110053528_muWM5 | CA000R | 2024-11-11T14:15:07.151Z | 2024-11-18T14:26:39.160Z |
5517784 | 5517784 | 20241110044818_ahfMu | CA000R | 2024-11-11T14:14:51.656Z | 2024-11-18T14:26:38.287Z |
5517749 | 5517749 | 20241110044327_0m6zw | CA000R | 2024-11-11T14:14:49.837Z | 2024-11-18T14:26:38.049Z |
5517723 | 5517723 | 20241110043752_5XA3K | CA000R | 2024-11-11T14:14:46.750Z | 2024-11-18T14:26:37.968Z |
5517666 | 5517666 | 20241110042439_pP6Hy | CA000R | 2024-11-11T14:14:43.322Z | 2024-11-18T14:26:37.710Z |
5517629 | 5517629 | 20241110041558_nMvt5 | CA000R | 2024-11-11T14:14:41.311Z | 2024-11-18T14:26:37.520Z |
5517627 | 5517627 | 20241110041356_rYX4L | CA000R | 2024-11-11T14:14:41.175Z | 2024-11-18T14:26:37.511Z |
5517608 | 5517608 | 20241110041119_3iz0V | CA000R | 2024-11-11T14:14:39.746Z | 2024-11-18T14:26:37.361Z |
5517549 | 5517549 | 20241110040143_a9QhP | CA000R | 2024-11-11T14:14:34.663Z | 2024-11-18T14:26:37.112Z |
5517473 | 5517473 | 20241110034834_3yHWY | CA000R | 2024-11-11T14:14:28.273Z | 2024-11-18T14:26:36.613Z |
5517210 | 5517210 | 20241110030310_yoK95 | CA000R | 2024-11-11T14:14:04.684Z | 2024-11-18T14:26:35.343Z |
5517124 | 5517124 | 20241110025052_YvJgD | CA000R | 2024-11-11T14:13:56.908Z | 2024-11-18T14:26:34.805Z |
5517119 | 5517119 | 20241110025020_LemCK | CA000R | 2024-11-11T14:13:56.640Z | 2024-11-18T14:26:34.792Z |
5516264 | 5516264 | 20241110002521_QZVEG | CA000R | 2024-11-11T14:12:37.051Z | 2024-11-18T14:26:30.371Z |
5516053 | 5516053 | 20241109234155_uXxDg | CA000R | 2024-11-11T14:12:05.474Z | 2024-11-18T14:26:29.192Z |
5515929 | 5515929 | 20241109231406_xErKk | CA000R | 2024-11-11T14:11:48.029Z | 2024-11-18T14:26:28.533Z |
5512991 | 5512991 | 20241110101817_zPLvL | CA000R | 2024-11-11T14:03:42.976Z | 2024-11-19T14:21:30.185Z |
5512874 | 5512874 | 20241110100330_e3bKk | CA000R | 2024-11-11T14:03:23.223Z | 2024-11-19T14:21:29.118Z |
5512866 | 5512866 | 20241110100248_8YBBG | CA000R | 2024-11-11T14:03:22.113Z | 2024-11-19T14:21:29.084Z |
5512758 | 5512758 | 20241110094427_X9MKn | CA000R | 2024-11-11T14:03:05.481Z | 2024-11-19T14:21:27.847Z |
5512555 | 5512555 | 20241110090728_xVs7b | CA000R | 2024-11-11T14:02:41.133Z | 2024-11-19T14:21:26.278Z |
5512429 | 5512429 | 20241110084754_UVpb3 | CA000R | 2024-11-11T14:02:17.645Z | 2024-11-19T14:21:24.277Z |
5512100 | 5512100 | 20241110075653_Clro4 | CA000R | 2024-11-11T14:01:32.758Z | 2024-11-19T14:21:20.604Z |
5511971 | 5511971 | 20241110073527_yCZgM | CA000R | 2024-11-11T14:01:14.449Z | 2024-11-19T14:21:18.081Z |
5511941 | 5511941 | 20241110072737_P5ou1 | CA000R | 2024-11-11T14:01:10.582Z | 2024-11-19T14:21:17.766Z |
5511916 | 5511916 | 20241110072153_NWPU1 | CA000R | 2024-11-11T14:01:03.941Z | 2024-11-19T14:21:17.550Z |
5511628 | 5511628 | 20241110062958_UVvt9 | CA000R | 2024-11-11T14:00:22.143Z | 2024-11-19T14:21:14.752Z |
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);