participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,648 rows where station_code = "RU0001" 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 |
---|---|---|---|---|---|
5504658 | 5504658 | 20241108023533_CwO2u | RU0001 | 2024-11-09T14:15:01.756Z | 2024-11-09T14:16:28.594Z |
5504476 | 5504476 | 20241108020341_xGDkM | RU0001 | 2024-11-09T14:14:43.314Z | 2024-11-09T14:16:28.548Z |
5504195 | 5504195 | 20241108011225_kYz94 | RU0001 | 2024-11-09T14:14:13.129Z | 2024-11-09T14:16:28.473Z |
5504112 | 5504112 | 20241108005638_73lMJ | RU0001 | 2024-11-09T14:14:05.465Z | 2024-11-09T14:16:28.452Z |
5503905 | 5503905 | 20241108001215_IbyB9 | RU0001 | 2024-11-09T14:13:50.740Z | 2024-11-09T14:16:28.389Z |
5503611 | 5503611 | 20241107230302_RCEgp | RU0001 | 2024-11-09T14:13:24.158Z | 2024-11-09T14:16:28.302Z |
5496888 | 5496888 | 20241107020732_rknd5 | RU0001 | 2024-11-08T14:12:57.297Z | 2024-11-09T14:18:32.404Z |
5496764 | 5496764 | 20241107013332_2rX4R | RU0001 | 2024-11-08T14:12:50.479Z | 2024-11-09T14:18:29.714Z |
5491288 | 5491288 | 20241106025055_r60lW | RU0001 | 2024-11-07T14:15:47.100Z | 2024-11-09T14:20:06.344Z |
5491220 | 5491220 | 20241106022658_U35Te | RU0001 | 2024-11-07T14:15:33.159Z | 2024-11-09T14:20:05.673Z |
5491189 | 5491189 | 20241106021856_9E0kg | RU0001 | 2024-11-07T14:15:25.754Z | 2024-11-09T14:20:05.109Z |
5491063 | 5491063 | 20241106014747_YMFkR | RU0001 | 2024-11-07T14:15:16.652Z | 2024-11-09T14:20:03.580Z |
5491025 | 5491025 | 20241106014000_nBekE | RU0001 | 2024-11-07T14:15:13.549Z | 2024-11-09T14:20:03.152Z |
5490907 | 5490907 | 20241106010956_lMfDE | RU0001 | 2024-11-07T14:15:04.478Z | 2024-11-09T14:20:01.406Z |
5490506 | 5490506 | 20241105231248_qsyIa | RU0001 | 2024-11-07T14:14:07.228Z | 2024-11-09T14:19:56.383Z |
5489159 | 5489159 | 20241105175916_rneZi | RU0001 | 2024-11-07T14:11:23.669Z | 2024-11-09T14:19:37.755Z |
5485636 | 5485636 | 20241104005733_e5uBR | RU0001 | 2024-11-06T14:21:17.762Z | 2024-11-09T14:22:14.113Z |
5485634 | 5485634 | 20241104001821_wYquY | RU0001 | 2024-11-06T14:21:14.755Z | 2024-11-09T14:22:12.264Z |
5485632 | 5485632 | 20241103234049_oCVKM | RU0001 | 2024-11-06T14:21:12.466Z | 2024-11-09T14:22:10.366Z |
5476551 | 5476551 | 20241103234400_arxz4 | RU0001 | 2024-11-05T14:15:38.530Z | 2024-11-09T14:22:10.615Z |
5476313 | 5476313 | 20241103230604_ko2R0 | RU0001 | 2024-11-05T14:15:02.933Z | 2024-11-09T14:22:07.749Z |
5468932 | 5468932 | 20241103021210_KN2SI | RU0001 | 2024-11-04T14:15:15.474Z | 2024-11-09T14:23:00.380Z |
5468871 | 5468871 | 20241103020222_9rlgM | RU0001 | 2024-11-04T14:15:10.292Z | 2024-11-09T14:23:00.049Z |
5468692 | 5468692 | 20241103012721_naXL2 | RU0001 | 2024-11-04T14:14:55.617Z | 2024-11-09T14:22:59.337Z |
5468657 | 5468657 | 20241103011640_tIqvO | RU0001 | 2024-11-04T14:14:47.961Z | 2024-11-09T14:22:59.236Z |
5443580 | 5443580 | 20241030234455_Twpck | RU0001 | 2024-11-01T12:20:39.906Z | 2024-11-08T14:23:11.683Z |
5433759 | 5433759 | 20241028001416_vqUQN | RU0001 | 2024-10-31T12:24:28.502Z | 2024-11-05T14:27:13.376Z |
5420281 | 5420281 | 20241028022431_DXcrE | RU0001 | 2024-10-30T12:18:40.495Z | 2024-11-05T14:27:15.104Z |
5420149 | 5420149 | 20241028020457_K3Ubk | RU0001 | 2024-10-30T12:18:25.464Z | 2024-11-05T14:27:14.672Z |
5419872 | 5419872 | 20241028012402_hSH47 | RU0001 | 2024-10-30T12:17:59.748Z | 2024-11-05T14:27:14.059Z |
5419828 | 5419828 | 20241028011611_zRwCH | RU0001 | 2024-10-30T12:17:56.518Z | 2024-11-05T14:27:13.983Z |
5419522 | 5419522 | 20241028001419_uUvK4 | RU0001 | 2024-10-30T12:17:31.765Z | 2024-11-05T14:27:13.377Z |
5419408 | 5419408 | 20241027235520_ZiWkx | RU0001 | 2024-10-30T12:17:25.665Z | 2024-11-05T14:27:13.017Z |
5419390 | 5419390 | 20241027234927_znMTM | RU0001 | 2024-10-30T12:17:24.498Z | 2024-11-05T14:27:12.993Z |
5419303 | 5419303 | 20241027233331_Z3i62 | RU0001 | 2024-10-30T12:17:19.793Z | 2024-11-05T14:27:12.708Z |
5418720 | 5418720 | 20241027214243_3a8M5 | RU0001 | 2024-10-30T12:16:01.249Z | 2024-11-05T14:27:10.957Z |
5418497 | 5418497 | 20241027205738_JyrVZ | RU0001 | 2024-10-30T12:15:45.530Z | 2024-11-05T14:27:10.236Z |
5418322 | 5418322 | 20241027202320_3U3Gb | RU0001 | 2024-10-30T12:15:28.018Z | 2024-11-05T14:27:09.636Z |
5417006 | 5417006 | 20241027173417_utOBJ | RU0001 | 2024-10-30T12:12:43.377Z | 2024-11-05T14:27:06.164Z |
5416744 | 5416744 | 20241027165025_awTxx | RU0001 | 2024-10-30T12:12:22.449Z | 2024-11-05T14:27:05.350Z |
5407426 | 5407426 | 20241027023642_iA2bL | RU0001 | 2024-10-29T12:15:24.548Z | 2024-11-04T14:28:57.565Z |
5406281 | 5406281 | 20241027012514_Kg2Jh | RU0001 | 2024-10-29T12:14:00.675Z | 2024-11-04T14:28:55.285Z |
5406092 | 5406092 | 20241027011455_Xo3GU | RU0001 | 2024-10-29T12:13:51.138Z | 2024-11-04T14:28:54.984Z |
5405373 | 5405373 | 20241027003031_IZVhP | RU0001 | 2024-10-29T12:12:52.033Z | 2024-11-04T14:28:53.362Z |
5404973 | 5404973 | 20241027000415_Kb0T8 | RU0001 | 2024-10-29T12:12:12.620Z | 2024-11-04T14:28:52.481Z |
5404812 | 5404812 | 20241026235417_KBGdD | RU0001 | 2024-10-29T12:11:59.458Z | 2024-11-04T14:28:52.001Z |
5404042 | 5404042 | 20241026225433_21Tka | RU0001 | 2024-10-29T12:10:50.149Z | 2024-11-04T14:28:50.266Z |
5403341 | 5403341 | 20241026214302_KYqeu | RU0001 | 2024-10-29T12:09:23.118Z | 2024-11-04T14:28:48.434Z |
5402407 | 5402407 | 20241026192940_5FJLE | RU0001 | 2024-10-29T12:07:10.875Z | 2024-11-04T14:28:44.204Z |
5402053 | 5402053 | 20241026183557_AAFlU | RU0001 | 2024-10-29T12:06:16.215Z | 2024-11-04T14:28:41.900Z |
5372735 | 5372735 | 20241024010534_ybql0 | RU0001 | 2024-10-26T12:19:41.009Z | 2024-11-01T12:26:57.901Z |
5372455 | 5372455 | 20241024004912_OMsFH | RU0001 | 2024-10-26T12:19:25.526Z | 2024-11-01T12:26:57.461Z |
5363751 | 5363751 | 20241023214051_AEgyF | RU0001 | 2024-10-25T12:16:41.465Z | 2024-11-01T12:26:53.605Z |
5342740 | 5342740 | 20241022024254_VkCvI | RU0001 | 2024-10-23T12:17:18.800Z | 2024-10-30T12:26:48.879Z |
5342681 | 5342681 | 20241022023914_QRnbX | RU0001 | 2024-10-23T12:17:13.632Z | 2024-10-30T12:26:48.821Z |
5342536 | 5342536 | 20241022023243_5wIpz | RU0001 | 2024-10-23T12:17:01.955Z | 2024-10-30T12:26:48.608Z |
5342369 | 5342369 | 20241022022249_CcmJl | RU0001 | 2024-10-23T12:16:50.269Z | 2024-10-30T12:26:48.428Z |
5341251 | 5341251 | 20241022012145_Y938G | RU0001 | 2024-10-23T12:15:33.218Z | 2024-10-30T12:26:46.720Z |
5338777 | 5338777 | 20241021203636_B4TXl | RU0001 | 2024-10-23T12:11:55.169Z | 2024-10-30T12:26:42.756Z |
5316707 | 5316707 | 20241016003801_KWBZ5 | RU0001 | 2024-10-17T12:07:01.629Z | 2024-10-24T12:27:57.750Z |
5291483 | 5291483 | 20241011210552_3sR9h | RU0001 | 2024-10-13T12:14:39.306Z | 2024-10-20T12:24:32.136Z |
5283825 | 5283825 | 20241011015700_FqJZ2 | RU0001 | 2024-10-12T12:16:58.740Z | 2024-10-19T12:27:52.887Z |
5283694 | 5283694 | 20241011014509_wX2Oo | RU0001 | 2024-10-12T12:16:51.441Z | 2024-10-19T12:27:52.416Z |
5282970 | 5282970 | 20241011002113_LcajC | RU0001 | 2024-10-12T12:16:15.569Z | 2024-10-19T12:27:47.915Z |
5274746 | 5274746 | 20241009231801_hLikV | RU0001 | 2024-10-11T12:14:49.461Z | 2024-10-18T12:22:11.276Z |
5274722 | 5274722 | 20241009230949_vASVV | RU0001 | 2024-10-11T12:14:47.958Z | 2024-10-18T12:22:10.903Z |
5260637 | 5260637 | 20241007170431_DQ2jW | RU0001 | 2024-10-09T12:12:47.041Z | 2024-10-16T12:21:11.696Z |
5254475 | 5254475 | 20241007021716_CYgjk | RU0001 | 2024-10-08T12:14:27.540Z | 2024-10-15T12:29:15.764Z |
5254471 | 5254471 | 20241007021638_9UP3v | RU0001 | 2024-10-08T12:14:27.280Z | 2024-10-15T12:29:15.720Z |
5254400 | 5254400 | 20241007020826_UQDQq | RU0001 | 2024-10-08T12:14:23.325Z | 2024-10-15T12:29:15.303Z |
5254291 | 5254291 | 20241007015825_m0hei | RU0001 | 2024-10-08T12:14:16.283Z | 2024-10-15T12:29:14.516Z |
5254287 | 5254287 | 20241007015818_2o4GX | RU0001 | 2024-10-08T12:14:16.032Z | 2024-10-15T12:29:14.513Z |
5254267 | 5254267 | 20241007015516_HNOiL | RU0001 | 2024-10-08T12:14:14.852Z | 2024-10-15T12:29:14.417Z |
5253892 | 5253892 | 20241007010133_2E0fs | RU0001 | 2024-10-08T12:13:48.923Z | 2024-10-15T12:29:11.718Z |
5253201 | 5253201 | 20241006230926_2J3GK | RU0001 | 2024-10-08T12:13:01.623Z | 2024-10-15T12:29:07.929Z |
5252843 | 5252843 | 20241006214821_lMPBJ | RU0001 | 2024-10-08T12:12:36.075Z | 2024-10-15T12:29:04.757Z |
5252579 | 5252579 | 20241006203217_216f2 | RU0001 | 2024-10-08T12:11:59.121Z | 2024-10-15T12:29:01.741Z |
5252521 | 5252521 | 20241006201837_vmDe6 | RU0001 | 2024-10-08T12:11:52.009Z | 2024-10-15T12:29:00.813Z |
5247232 | 5247232 | 20241005014658_6pLKr | RU0001 | 2024-10-07T12:18:51.934Z | 2024-10-13T12:26:25.871Z |
5246104 | 5246104 | 20241006010139_SK5Ie | RU0001 | 2024-10-07T12:16:12.504Z | 2024-10-14T12:24:37.206Z |
5245618 | 5245618 | 20241005233621_Gd9bW | RU0001 | 2024-10-07T12:15:49.132Z | 2024-10-14T12:24:35.947Z |
5245540 | 5245540 | 20241005232211_eFWKX | RU0001 | 2024-10-07T12:15:44.710Z | 2024-10-14T12:24:35.780Z |
5245361 | 5245361 | 20241005224528_g8n3j | RU0001 | 2024-10-07T12:15:37.832Z | 2024-10-14T12:24:35.303Z |
5245024 | 5245024 | 20241005215129_PGftT | RU0001 | 2024-10-07T12:15:28.842Z | 2024-10-14T12:24:34.508Z |
5244936 | 5244936 | 20241005213257_iQLwF | RU0001 | 2024-10-07T12:15:26.385Z | 2024-10-14T12:24:34.365Z |
5244595 | 5244595 | 20241005203052_NIB9N | RU0001 | 2024-10-07T12:15:03.435Z | 2024-10-14T12:24:33.904Z |
5244426 | 5244426 | 20241005200244_eynx8 | RU0001 | 2024-10-07T12:14:52.749Z | 2024-10-14T12:24:33.519Z |
5244173 | 5244173 | 20241005192804_wdtev | RU0001 | 2024-10-07T12:14:33.634Z | 2024-10-14T12:24:32.929Z |
5236351 | 5236351 | 20241005004223_iy6HE | RU0001 | 2024-10-06T12:17:28.004Z | 2024-10-13T12:26:24.855Z |
5235507 | 5235507 | 20241004233937_cxOfT | RU0001 | 2024-10-06T12:16:08.052Z | 2024-10-13T12:26:24.309Z |
5235018 | 5235018 | 20241004224355_2p70Y | RU0001 | 2024-10-06T12:15:46.661Z | 2024-10-13T12:26:23.378Z |
5234966 | 5234966 | 20241004223725_aTxKQ | RU0001 | 2024-10-06T12:15:43.956Z | 2024-10-13T12:26:23.231Z |
5234593 | 5234593 | 20241004215647_kFl3A | RU0001 | 2024-10-06T12:15:02.080Z | 2024-10-13T12:26:22.649Z |
5234472 | 5234472 | 20241004214021_xwQBL | RU0001 | 2024-10-06T12:14:56.333Z | 2024-10-13T12:26:22.539Z |
5234435 | 5234435 | 20241004213641_ImJb6 | RU0001 | 2024-10-06T12:14:54.941Z | 2024-10-13T12:26:22.506Z |
5232993 | 5232993 | 20241004184428_qPu12 | RU0001 | 2024-10-06T12:12:47.843Z | 2024-10-13T12:26:20.122Z |
5232149 | 5232149 | 20241004162157_YFEha | RU0001 | 2024-10-06T12:11:26.060Z | 2024-10-13T12:26:18.864Z |
5227138 | 5227138 | 20241004010432_Q4TxN | RU0001 | 2024-10-05T12:21:14.459Z | 2024-10-12T12:25:12.538Z |
5226530 | 5226530 | 20241004002116_vegVl | RU0001 | 2024-10-05T12:20:47.375Z | 2024-10-12T12:25:11.822Z |
5225613 | 5225613 | 20241003230105_1VpYN | RU0001 | 2024-10-05T12:19:58.115Z | 2024-10-12T12:25:10.488Z |
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);