participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
134 rows where station_code = "RU000V" 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 |
---|---|---|---|---|---|
5102443 | 5102443 | 20240914012558_ya3Vy | RU000V | 2024-09-17T12:07:11.217Z | 2024-09-20T12:18:53.502Z |
5101462 | 5101462 | 20240914002724_AV0HN | RU000V | 2024-09-17T12:05:53.140Z | 2024-09-20T12:18:46.551Z |
5052862 | 5052862 | 20240907222344_8t8Va | RU000V | 2024-09-13T12:15:32.809Z | 2024-09-16T12:21:08.277Z |
5046052 | 5046052 | 20240908205744_rUDiP | RU000V | 2024-09-13T12:05:40.788Z | 2024-09-17T12:18:58.458Z |
5039465 | 5039465 | 20240906010301_KO9wZ | RU000V | 2024-09-12T12:15:33.806Z | 2024-09-14T12:23:02.337Z |
5039114 | 5039114 | 20240905232318_eY2mG | RU000V | 2024-09-12T12:15:16.226Z | 2024-09-14T12:23:00.116Z |
5025109 | 5025109 | 20240906010301_4Nv07 | RU000V | 2024-09-11T12:05:36.620Z | 2024-09-11T12:16:32.475Z |
5024707 | 5024707 | 20240905232318_lxgre | RU000V | 2024-09-11T12:04:32.924Z | 2024-09-11T12:16:32.273Z |
4999478 | 4999478 | 20240902002555_YgiF2 | RU000V | 2024-09-08T12:14:22.360Z | 2024-09-10T12:19:19.600Z |
4988888 | 4988888 | 20240901215242_DkYrt | RU000V | 2024-09-07T12:08:07.582Z | 2024-09-10T12:19:15.766Z |
4977108 | 4977108 | 20240811233625_1bjP1 | RU000V | 2024-09-06T12:12:04.298Z | 2024-09-06T12:12:04.298Z |
4976382 | 4976382 | 20240811232951_2kY2G | RU000V | 2024-09-06T12:11:30.342Z | 2024-09-06T12:11:30.342Z |
4975933 | 4975933 | 20240811232327_3brS2 | RU000V | 2024-09-06T12:10:56.947Z | 2024-09-06T12:10:56.947Z |
4973882 | 4973882 | 20240811230113_bA0ES | RU000V | 2024-09-05T12:11:13.472Z | 2024-09-06T12:10:10.153Z |
4973292 | 4973292 | 20240811225527_VfXFY | RU000V | 2024-09-05T12:10:46.802Z | 2024-09-06T12:09:51.409Z |
4966226 | 4966226 | 20240811212547_ETme8 | RU000V | 2024-09-04T12:07:21.228Z | 2024-09-06T12:06:18.118Z |
4964493 | 4964493 | 20240811205604_ow7pc | RU000V | 2024-09-04T12:06:24.271Z | 2024-09-06T12:05:23.163Z |
4964380 | 4964380 | 20240811205315_OCnyP | RU000V | 2024-09-04T12:06:19.863Z | 2024-09-06T12:05:18.740Z |
4963986 | 4963986 | 20240811204231_Yj9ly | RU000V | 2024-09-04T12:06:03.109Z | 2024-09-06T12:05:07.614Z |
4963770 | 4963770 | 20240811203441_X5dzF | RU000V | 2024-09-04T12:05:55.101Z | 2024-09-06T12:04:55.547Z |
4963199 | 4963199 | 20240811194915_Ja09B | RU000V | 2024-09-04T12:05:19.012Z | 2024-09-06T12:04:22.169Z |
4962965 | 4962965 | 20240811193452_xSimL | RU000V | 2024-09-04T12:05:01.685Z | 2024-09-06T12:04:13.079Z |
4946731 | 4946731 | 20240811010525_C2SKk | RU000V | 2024-09-02T12:14:05.385Z | 2024-09-06T12:26:32.238Z |
4944157 | 4944157 | 20240811002439_JHcWe | RU000V | 2024-09-02T12:12:23.691Z | 2024-09-06T12:25:14.605Z |
4941116 | 4941116 | 20240810232700_TxDrV | RU000V | 2024-09-02T12:10:13.082Z | 2024-09-06T12:23:43.436Z |
4939057 | 4939057 | 20240810223625_Lca3X | RU000V | 2024-09-01T12:09:35.850Z | 2024-09-06T12:23:12.052Z |
4938508 | 4938508 | 20240810222130_rdByl | RU000V | 2024-09-01T12:09:09.400Z | 2024-09-06T12:22:54.504Z |
4938377 | 4938377 | 20240810221847_GHsaE | RU000V | 2024-09-01T12:09:05.239Z | 2024-09-06T12:22:50.987Z |
4937279 | 4937279 | 20240810214510_02ZXz | RU000V | 2024-09-01T12:08:08.218Z | 2024-09-06T12:22:06.268Z |
4936517 | 4936517 | 20240810212125_wzUP8 | RU000V | 2024-09-01T12:07:35.163Z | 2024-09-06T12:21:37.791Z |
4934957 | 4934957 | 20240810192244_j6gGS | RU000V | 2024-09-01T12:05:57.959Z | 2024-09-06T12:20:24.458Z |
4934496 | 4934496 | 20240810182313_zoqTk | RU000V | 2024-09-01T12:05:26.911Z | 2024-09-06T12:20:13.086Z |
4918862 | 4918862 | 20240810000003_lzxMy | RU000V | 2024-08-30T12:12:17.135Z | 2024-09-02T12:25:37.632Z |
4918443 | 4918443 | 20240809235159_IxDLZ | RU000V | 2024-08-30T12:12:02.835Z | 2024-09-02T12:25:31.785Z |
4917314 | 4917314 | 20240809233118_XajZn | RU000V | 2024-08-30T12:11:20.926Z | 2024-09-02T12:24:58.867Z |
4914118 | 4914118 | 20240809220806_y8yIq | RU000V | 2024-08-30T12:08:56.202Z | 2024-09-02T12:23:17.199Z |
4913985 | 4913985 | 20240809220206_CVh6m | RU000V | 2024-08-30T12:08:46.601Z | 2024-09-02T12:23:11.076Z |
4912060 | 4912060 | 20240809205503_cNYJg | RU000V | 2024-08-29T12:08:06.899Z | 2024-09-02T12:22:07.223Z |
4911235 | 4911235 | 20240809193751_aL5RL | RU000V | 2024-08-29T12:07:09.849Z | 2024-09-02T12:21:26.505Z |
4901124 | 4901124 | 20240808010725_lYRux | RU000V | 2024-08-28T12:18:34.705Z | 2024-08-28T12:18:34.705Z |
4901057 | 4901057 | 20240808010243_ids1v | RU000V | 2024-08-28T12:18:32.302Z | 2024-08-28T12:18:32.302Z |
4900088 | 4900088 | 20240807234936_Wq3at | RU000V | 2024-08-28T12:17:45.295Z | 2024-08-28T12:17:45.295Z |
4899677 | 4899677 | 20240807231154_33H4c | RU000V | 2024-08-28T12:17:25.486Z | 2024-08-28T12:17:25.486Z |
4899631 | 4899631 | 20240807230857_MNfgL | RU000V | 2024-08-28T12:17:23.976Z | 2024-08-28T12:17:23.976Z |
4899595 | 4899595 | 20240807230414_1qt6i | RU000V | 2024-08-28T12:17:22.197Z | 2024-08-28T12:17:22.197Z |
4899262 | 4899262 | 20240807224232_UBAYh | RU000V | 2024-08-28T12:17:14.299Z | 2024-08-28T12:17:14.299Z |
4898821 | 4898821 | 20240807220743_8cVIZ | RU000V | 2024-08-28T12:16:52.232Z | 2024-08-28T12:16:52.232Z |
4898582 | 4898582 | 20240807215015_FNy5X | RU000V | 2024-08-28T12:16:43.049Z | 2024-08-28T12:16:43.049Z |
4890511 | 4890511 | 20240808231558_Mq6pH | RU000V | 2024-08-28T12:07:48.916Z | 2024-08-30T12:20:18.262Z |
4890388 | 4890388 | 20240808230520_oUT2F | RU000V | 2024-08-28T12:07:38.690Z | 2024-08-30T12:20:14.303Z |
4890154 | 4890154 | 20240808223837_W9X28 | RU000V | 2024-08-28T12:07:17.220Z | 2024-08-30T12:20:05.627Z |
4889722 | 4889722 | 20240808213959_qbmNX | RU000V | 2024-08-28T12:06:39.189Z | 2024-08-30T12:19:33.348Z |
4889699 | 4889699 | 20240808213751_1Jarr | RU000V | 2024-08-28T12:06:37.358Z | 2024-08-30T12:19:32.560Z |
4889394 | 4889394 | 20240808205253_f5YQU | RU000V | 2024-08-28T12:06:07.016Z | 2024-08-30T12:19:19.588Z |
4889348 | 4889348 | 20240808204622_jH3Sy | RU000V | 2024-08-28T12:06:02.849Z | 2024-08-30T12:19:12.966Z |
4889296 | 4889296 | 20240808203657_fS2fS | RU000V | 2024-08-28T12:05:55.101Z | 2024-08-30T12:19:06.104Z |
4889186 | 4889186 | 20240808200607_elXUX | RU000V | 2024-08-28T12:05:43.600Z | 2024-08-30T12:18:57.741Z |
4873859 | 4873859 | 20240806223550_th7Fn | RU000V | 2024-08-19T12:11:09.305Z | 2024-08-27T12:11:24.828Z |
4871692 | 4871692 | 20240806210406_oi7mr | RU000V | 2024-08-19T12:09:21.132Z | 2024-08-27T12:09:57.688Z |
4830350 | 4830350 | 20240804213120_CG84D | RU000V | 2024-08-15T12:10:31.828Z | 2024-08-17T12:29:43.170Z |
4824547 | 4824547 | 20240804000101_VIJA5 | RU000V | 2024-08-14T12:19:16.094Z | 2024-08-15T12:25:29.911Z |
4784215 | 4784215 | 20240801231738_LyN3d | RU000V | 2024-08-10T12:14:43.893Z | 2024-08-11T12:14:26.007Z |
4783193 | 4783193 | 20240801221228_cyGuC | RU000V | 2024-08-10T12:13:30.424Z | 2024-08-11T12:14:06.181Z |
4782776 | 4782776 | 20240801213127_J1TEi | RU000V | 2024-08-10T12:12:42.739Z | 2024-08-11T12:13:53.671Z |
4779550 | 4779550 | 20240801005106_4SOUd | RU000V | 2024-08-07T12:14:32.317Z | 2024-08-10T12:21:31.904Z |
4779346 | 4779346 | 20240801003354_CagGa | RU000V | 2024-08-07T12:14:24.590Z | 2024-08-10T12:21:27.448Z |
4779005 | 4779005 | 20240801000125_YXqZE | RU000V | 2024-08-07T12:14:09.232Z | 2024-08-10T12:21:19.770Z |
4778838 | 4778838 | 20240731234037_pTn33 | RU000V | 2024-08-07T12:14:02.905Z | 2024-08-10T12:21:16.450Z |
4770138 | 4770138 | 20240731220406_bgShi | RU000V | 2024-08-06T12:11:34.362Z | 2024-08-10T12:20:55.037Z |
4769633 | 4769633 | 20240731210830_RryKz | RU000V | 2024-08-06T12:11:03.636Z | 2024-08-10T12:20:40.641Z |
4769579 | 4769579 | 20240731210148_386dM | RU000V | 2024-08-06T12:11:01.373Z | 2024-08-10T12:20:39.958Z |
4750378 | 4750378 | 20240729232219_nxYZu | RU000V | 2024-08-04T12:16:10.299Z | 2024-08-06T12:15:30.905Z |
4747884 | 4747884 | 20240729215242_32QKJ | RU000V | 2024-08-04T12:14:56.678Z | 2024-08-06T12:15:23.304Z |
4747785 | 4747785 | 20240729214759_zbfzI | RU000V | 2024-08-04T12:14:53.552Z | 2024-08-06T12:15:23.113Z |
4712148 | 4712148 | 20240727203109_QB1x4 | RU000V | 2024-07-29T12:12:53.072Z | 2024-08-04T12:20:07.256Z |
4712021 | 4712021 | 20240727191055_eHTYl | RU000V | 2024-07-29T12:12:38.014Z | 2024-08-04T12:20:04.950Z |
4711949 | 4711949 | 20240727183644_YY6RI | RU000V | 2024-07-29T12:12:32.702Z | 2024-08-04T12:20:03.832Z |
4706848 | 4706848 | 20240728000943_GF7iD | RU000V | 2024-07-29T12:03:54.256Z | 2024-08-05T12:19:37.418Z |
4690642 | 4690642 | 20240726001630_KMbwU | RU000V | 2024-07-27T12:03:50.270Z | 2024-08-03T12:21:11.643Z |
4690384 | 4690384 | 20240725234628_oBeCY | RU000V | 2024-07-27T12:03:12.465Z | 2024-08-03T12:21:09.545Z |
4684140 | 4684140 | 20240725002208_4jw38 | RU000V | 2024-07-26T12:02:20.560Z | 2024-08-02T12:24:08.492Z |
4684061 | 4684061 | 20240725000104_gYlTM | RU000V | 2024-07-26T12:02:08.060Z | 2024-08-02T12:24:04.673Z |
4683967 | 4683967 | 20240724231607_OFvX2 | RU000V | 2024-07-26T12:01:47.329Z | 2024-08-02T12:24:02.108Z |
4674102 | 4674102 | 20240720214721_ZE2rh | RU000V | 2024-07-22T12:01:03.615Z | 2024-07-29T12:17:09.727Z |
4666378 | 4666378 | 20240718233035_rFXhW | RU000V | 2024-07-20T12:02:19.367Z | 2024-07-27T12:17:01.849Z |
4654900 | 4654900 | 20240716235225_FN5l2 | RU000V | 2024-07-18T12:05:15.342Z | 2024-07-25T12:13:58.075Z |
4648330 | 4648330 | 20240714234004_1PLg7 | RU000V | 2024-07-17T12:07:50.614Z | 2024-07-23T12:08:42.672Z |
4602243 | 4602243 | 20240708194047_GFUi5 | RU000V | 2024-07-11T12:08:50.031Z | 2024-07-16T12:09:22.153Z |
4595729 | 4595729 | 20240707234025_3HK5v | RU000V | 2024-07-10T12:11:18.773Z | 2024-07-15T12:12:27.829Z |
4537900 | 4537900 | 20240702205329_sAkBV | RU000V | 2024-07-04T12:01:24.586Z | 2024-07-11T12:14:32.432Z |
4534658 | 4534658 | 20240701225101_PWOZs | RU000V | 2024-07-03T12:01:16.495Z | 2024-07-10T12:15:24.014Z |
4531533 | 4531533 | 20240630235449_KLBx2 | RU000V | 2024-07-02T12:03:00.595Z | 2024-07-09T12:08:03.428Z |
4531504 | 4531504 | 20240630234332_MDx0J | RU000V | 2024-07-02T12:02:58.357Z | 2024-07-09T12:08:03.002Z |
4531267 | 4531267 | 20240630221615_DQYhr | RU000V | 2024-07-02T12:02:37.259Z | 2024-07-09T12:08:01.126Z |
4526331 | 4526331 | 20240629221026_M7328 | RU000V | 2024-07-01T12:02:58.377Z | 2024-07-08T12:11:46.795Z |
4520480 | 4520480 | 20240628232803_cXGNV | RU000V | 2024-06-30T12:04:05.115Z | 2024-07-07T12:13:47.579Z |
4519688 | 4519688 | 20240628215834_ONg2i | RU000V | 2024-06-30T12:03:23.043Z | 2024-07-07T12:13:45.780Z |
4492428 | 4492428 | 20240621003522_Vs6VJ | RU000V | 2024-06-22T12:05:41.056Z | 2024-06-29T12:13:34.588Z |
4415954 | 4415954 | 20240604223414_rKAFY | RU000V | 2024-06-06T12:05:37.912Z | 2024-06-13T12:08:31.331Z |
4370864 | 4370864 | 20240523002739_gyFjY | RU000V | 2024-05-27T12:00:21.270Z | 2024-05-31T12:15:58.747Z |
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);