participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
463 rows where station_code = "MX0007" 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 |
---|---|---|---|---|---|
5401679 | 5401679 | 20241026092008_G4Pxr | MX0007 | 2024-10-29T12:03:03.058Z | 2024-11-04T14:28:27.214Z |
5400193 | 5400193 | 20241026055756_O34ep | MX0007 | 2024-10-28T12:20:27.149Z | 2024-11-03T14:27:41.622Z |
5390217 | 5390217 | 20241026091917_T6kWN | MX0007 | 2024-10-28T12:02:24.025Z | 2024-11-04T14:28:27.173Z |
5390198 | 5390198 | 20241026091501_GrgPk | MX0007 | 2024-10-28T12:02:21.101Z | 2024-11-04T14:28:26.983Z |
5387399 | 5387399 | 20241025023100_RLdUn | MX0007 | 2024-10-27T12:21:18.525Z | 2024-11-02T12:28:32.478Z |
5378448 | 5378448 | 20241024063259_xOsr3 | MX0007 | 2024-10-26T12:23:01.865Z | 2024-11-01T12:27:04.237Z |
5378322 | 5378322 | 20241024060100_6ECX4 | MX0007 | 2024-10-26T12:23:00.042Z | 2024-11-01T12:27:03.765Z |
5373060 | 5373060 | 20241024012203_oCjBV | MX0007 | 2024-10-26T12:19:55.530Z | 2024-11-01T12:26:58.108Z |
4495809 | 4495809 | 20240623060738_UP21C | MX0007 | 2024-06-24T12:02:56.033Z | 2024-07-01T12:12:25.787Z |
4495806 | 4495806 | 20240623060425_cks2X | MX0007 | 2024-06-24T12:02:55.736Z | 2024-07-01T12:12:25.763Z |
4494363 | 4494363 | 20240623100526_kNsj0 | MX0007 | 2024-06-24T12:00:20.361Z | 2024-07-02T12:10:13.310Z |
4482008 | 4482008 | 20240618104645_Lt8JF | MX0007 | 2024-06-20T12:01:49.633Z | 2024-06-27T12:11:14.501Z |
4481044 | 4481044 | 20240618035020_PyoMJ | MX0007 | 2024-06-20T12:00:11.209Z | 2024-06-27T12:10:59.520Z |
4475900 | 4475900 | 20240617091615_W3esf | MX0007 | 2024-06-19T12:02:41.982Z | 2024-06-26T12:14:14.816Z |
4475479 | 4475479 | 20240617071104_hNqmi | MX0007 | 2024-06-19T12:01:54.321Z | 2024-06-26T12:14:12.220Z |
4472205 | 4472205 | 20240616062528_vTbSF | MX0007 | 2024-06-18T12:01:48.391Z | 2024-06-24T12:11:05.393Z |
4472073 | 4472073 | 20240616053605_Yryec | MX0007 | 2024-06-18T12:01:30.933Z | 2024-06-24T12:11:02.544Z |
4465542 | 4465542 | 20240615103024_X1lrL | MX0007 | 2024-06-16T12:04:38.508Z | 2024-06-23T12:12:10.905Z |
4465173 | 4465173 | 20240615084000_qRjC6 | MX0007 | 2024-06-16T12:03:54.855Z | 2024-06-23T12:12:03.563Z |
4464905 | 4464905 | 20240615074824_9CGo3 | MX0007 | 2024-06-16T12:03:24.269Z | 2024-06-23T12:11:57.244Z |
4460860 | 4460860 | 20240614074355_N43Z3 | MX0007 | 2024-06-15T12:03:20.808Z | 2024-06-22T12:16:25.820Z |
4460786 | 4460786 | 20240614065024_2hVcW | MX0007 | 2024-06-15T12:03:01.968Z | 2024-06-22T12:16:25.387Z |
4456983 | 4456983 | 20240613054034_EgdJv | MX0007 | 2024-06-14T12:02:27.421Z | 2024-06-21T12:11:36.194Z |
4450140 | 4450140 | 20240612065416_QpFWF | MX0007 | 2024-06-13T12:02:23.307Z | 2024-06-20T12:11:57.453Z |
4450050 | 4450050 | 20240612062438_igTEI | MX0007 | 2024-06-13T12:02:14.872Z | 2024-06-20T12:11:57.007Z |
4449947 | 4449947 | 20240612053934_Xjih3 | MX0007 | 2024-06-13T12:02:04.806Z | 2024-06-20T12:11:56.030Z |
4144679 | 4144679 | 20240403112332_rWAlG | MX0007 | 2024-04-05T12:09:58.999Z | 2024-04-11T12:23:56.149Z |
4102047 | 4102047 | 20240320100426_iP75i | MX0007 | 2024-03-22T12:13:30.232Z | 2024-03-28T12:21:10.090Z |
4088825 | 4088825 | 20240318115153_0DHCv | MX0007 | 2024-03-20T12:00:58.992Z | 2024-03-27T12:18:23.182Z |
4082278 | 4082278 | 20240316092905_Bo3k7 | MX0007 | 2024-03-18T12:10:54.028Z | 2024-03-24T12:21:01.234Z |
4078629 | 4078629 | 20240316104926_6hxVU | MX0007 | 2024-03-18T12:00:16.881Z | 2024-03-25T12:21:40.069Z |
4078560 | 4078560 | 20240316064950_gBgP2 | MX0007 | 2024-03-17T12:09:38.522Z | 2024-03-24T12:20:58.316Z |
4063635 | 4063635 | 20240312084258_311hW | MX0007 | 2024-03-13T12:06:42.837Z | 2024-03-20T12:21:40.935Z |
4061952 | 4061952 | 20240312110504_AuYeQ | MX0007 | 2024-03-13T12:00:32.345Z | 2024-03-21T12:21:56.624Z |
4052153 | 4052153 | 20240309061714_nLZqY | MX0007 | 2024-03-10T12:10:14.603Z | 2024-03-17T12:18:32.201Z |
4048068 | 4048068 | 20240308112609_51EId | MX0007 | 2024-03-10T12:01:59.459Z | 2024-03-17T12:17:49.718Z |
4046776 | 4046776 | 20240308052415_qWcZi | MX0007 | 2024-03-09T14:10:15.291Z | 2024-03-16T12:21:45.869Z |
4042046 | 4042046 | 20240307090659_1w3Dr | MX0007 | 2024-03-08T14:09:33.148Z | 2024-03-15T12:19:44.244Z |
4036858 | 4036858 | 20240307111601_J2EUV | MX0007 | 2024-03-08T14:00:38.564Z | 2024-03-16T12:21:08.393Z |
4032138 | 4032138 | 20240305091838_bWCSp | MX0007 | 2024-03-06T14:10:38.366Z | 2024-03-13T12:21:04.877Z |
4031880 | 4031880 | 20240305081142_KUAD3 | MX0007 | 2024-03-06T14:10:02.467Z | 2024-03-13T12:21:02.653Z |
4031592 | 4031592 | 20240305051753_Gen5M | MX0007 | 2024-03-06T14:09:25.303Z | 2024-03-13T12:20:58.690Z |
4028330 | 4028330 | 20240305115308_kdNM4 | MX0007 | 2024-03-06T14:01:35.539Z | 2024-03-14T12:24:42.102Z |
4027897 | 4027897 | 20240304101825_N0fBH | MX0007 | 2024-03-05T14:10:01.825Z | 2024-03-12T12:15:39.398Z |
4027763 | 4027763 | 20240304092047_Tq2jW | MX0007 | 2024-03-05T14:09:51.173Z | 2024-03-12T12:15:39.009Z |
4021615 | 4021615 | 20240303064238_dbSWo | MX0007 | 2024-03-04T14:07:32.351Z | 2024-03-11T12:18:43.642Z |
4005592 | 4005592 | 20240227102327_XBWzC | MX0007 | 2024-02-28T14:04:45.952Z | 2024-03-06T14:19:48.510Z |
3998052 | 3998052 | 20240222105824_L7bB3 | MX0007 | 2024-02-23T14:06:48.571Z | 2024-03-01T14:15:25.016Z |
3995845 | 3995845 | 20240221112121_fDGbE | MX0007 | 2024-02-22T14:07:51.211Z | 2024-02-29T14:15:12.999Z |
3993309 | 3993309 | 20240220115149_KQNos | MX0007 | 2024-02-21T14:08:11.543Z | 2024-02-28T14:14:53.561Z |
3989302 | 3989302 | 20240219092828_t03It | MX0007 | 2024-02-20T14:06:42.670Z | 2024-02-27T14:14:13.173Z |
3989165 | 3989165 | 20240219084204_HFPku | MX0007 | 2024-02-20T14:06:20.886Z | 2024-02-27T14:14:08.827Z |
3989047 | 3989047 | 20240219074846_rHkBT | MX0007 | 2024-02-20T14:06:03.713Z | 2024-02-27T14:14:02.208Z |
3966710 | 3966710 | 20240214095222_M9IWQ | MX0007 | 2024-02-15T14:09:36.035Z | 2024-02-22T14:24:43.522Z |
3966551 | 3966551 | 20240214084715_btgn1 | MX0007 | 2024-02-15T14:09:25.666Z | 2024-02-22T14:24:35.278Z |
3948821 | 3948821 | 20240211121220_jkSB2 | MX0007 | 2024-02-12T14:09:22.078Z | 2024-02-19T14:19:18.412Z |
3948118 | 3948118 | 20240211094502_bOMAp | MX0007 | 2024-02-12T14:07:55.584Z | 2024-02-19T14:19:15.765Z |
3944568 | 3944568 | 20240210103126_OBt9z | MX0007 | 2024-02-11T14:08:24.842Z | 2024-02-18T14:22:19.593Z |
3940076 | 3940076 | 20240209105627_GmB3A | MX0007 | 2024-02-10T14:08:00.128Z | 2024-02-17T14:26:30.361Z |
3936716 | 3936716 | 20240208120325_YG1mY | MX0007 | 2024-02-09T14:07:54.060Z | 2024-02-16T14:18:38.072Z |
3936535 | 3936535 | 20240208100641_1ZqpX | MX0007 | 2024-02-09T14:07:30.910Z | 2024-02-16T14:18:36.142Z |
3932474 | 3932474 | 20240207115144_wgi2h | MX0007 | 2024-02-08T14:07:17.878Z | 2024-02-15T14:18:44.348Z |
3932338 | 3932338 | 20240207110023_d6rOR | MX0007 | 2024-02-08T14:06:58.620Z | 2024-02-15T14:18:43.892Z |
3932315 | 3932315 | 20240207104952_Vy6e2 | MX0007 | 2024-02-08T14:06:53.458Z | 2024-02-15T14:18:43.793Z |
3932313 | 3932313 | 20240207104917_0Pl2w | MX0007 | 2024-02-08T14:06:53.202Z | 2024-02-15T14:18:43.728Z |
3932127 | 3932127 | 20240207095946_ncKKL | MX0007 | 2024-02-08T14:06:30.288Z | 2024-02-15T14:18:42.310Z |
3932125 | 3932125 | 20240207095721_jo7VK | MX0007 | 2024-02-08T14:06:28.385Z | 2024-02-15T14:18:42.306Z |
3931963 | 3931963 | 20240207085107_Snxau | MX0007 | 2024-02-08T14:06:03.464Z | 2024-02-15T14:18:41.125Z |
3927671 | 3927671 | 20240206111103_E6g0l | MX0007 | 2024-02-07T14:07:39.370Z | 2024-02-14T14:19:56.699Z |
3927208 | 3927208 | 20240206092415_T2V9T | MX0007 | 2024-02-07T14:06:40.352Z | 2024-02-14T14:19:52.905Z |
3927105 | 3927105 | 20240206083346_2HhMa | MX0007 | 2024-02-07T14:06:25.145Z | 2024-02-14T14:19:52.455Z |
3927079 | 3927079 | 20240206081402_kYxmt | MX0007 | 2024-02-07T14:06:16.297Z | 2024-02-14T14:19:52.052Z |
3926976 | 3926976 | 20240206062724_pVp91 | MX0007 | 2024-02-07T14:05:57.473Z | 2024-02-14T14:19:50.641Z |
3926921 | 3926921 | 20240206053927_WG2t3 | MX0007 | 2024-02-07T14:05:46.598Z | 2024-02-14T14:19:49.636Z |
3926843 | 3926843 | 20240206042547_3flMt | MX0007 | 2024-02-07T14:05:28.177Z | 2024-02-14T14:19:48.589Z |
3923310 | 3923310 | 20240205101950_LLqIQ | MX0007 | 2024-02-06T14:09:01.583Z | 2024-02-13T14:27:44.849Z |
3923210 | 3923210 | 20240205100701_Zbl2D | MX0007 | 2024-02-06T14:08:53.923Z | 2024-02-13T14:27:42.118Z |
3922993 | 3922993 | 20240205093305_g6hZd | MX0007 | 2024-02-06T14:08:27.722Z | 2024-02-13T14:27:35.420Z |
3922647 | 3922647 | 20240205083225_2IvyW | MX0007 | 2024-02-06T14:07:44.183Z | 2024-02-13T14:27:25.120Z |
3922626 | 3922626 | 20240205082219_dvcXF | MX0007 | 2024-02-06T14:07:42.152Z | 2024-02-13T14:27:24.435Z |
3922215 | 3922215 | 20240205060147_kwdKQ | MX0007 | 2024-02-06T14:06:51.092Z | 2024-02-13T14:27:16.505Z |
3922138 | 3922138 | 20240205054533_zC1pS | MX0007 | 2024-02-06T14:06:43.059Z | 2024-02-13T14:27:14.132Z |
3922100 | 3922100 | 20240205053758_yn2Xx | MX0007 | 2024-02-06T14:06:35.658Z | 2024-02-13T14:27:12.576Z |
3917942 | 3917942 | 20240204115042_QXWm4 | MX0007 | 2024-02-05T14:06:47.413Z | 2024-02-12T14:23:32.156Z |
3917305 | 3917305 | 20240204101817_ti7dX | MX0007 | 2024-02-05T14:05:34.714Z | 2024-02-12T14:23:25.925Z |
3917123 | 3917123 | 20240204094932_r9QqT | MX0007 | 2024-02-05T14:05:10.142Z | 2024-02-12T14:23:22.632Z |
3916953 | 3916953 | 20240204091109_ukIOk | MX0007 | 2024-02-05T14:04:49.175Z | 2024-02-12T14:23:20.305Z |
3916806 | 3916806 | 20240204083655_jrZls | MX0007 | 2024-02-05T14:04:30.341Z | 2024-02-12T14:23:18.912Z |
3912713 | 3912713 | 20240203074813_f648J | MX0007 | 2024-02-04T14:05:17.501Z | 2024-02-11T14:23:18.724Z |
3885148 | 3885148 | 20240124120239_07t6Y | MX0007 | 2024-01-26T14:05:20.570Z | 2024-02-01T14:18:07.461Z |
3841222 | 3841222 | 20240116101501_ShMO3 | MX0007 | 2024-01-19T14:06:47.640Z | 2024-01-25T14:21:45.588Z |
3840794 | 3840794 | 20240116085814_Wzjgy | MX0007 | 2024-01-19T14:05:44.292Z | 2024-01-25T14:21:39.781Z |
3840585 | 3840585 | 20240116081504_XKipX | MX0007 | 2024-01-19T14:05:20.962Z | 2024-01-25T14:21:36.293Z |
3828178 | 3828178 | 20240114112215_rTW7e | MX0007 | 2024-01-17T14:10:15.509Z | 2024-01-23T14:25:00.484Z |
3808263 | 3808263 | 20240112035456_qzgD0 | MX0007 | 2024-01-15T14:03:04.556Z | 2024-01-21T14:27:31.364Z |
3780868 | 3780868 | 20240108090722_PMM7M | MX0007 | 2024-01-11T14:05:02.282Z | 2024-01-17T14:23:22.719Z |
3780863 | 3780863 | 20240108090405_BnaSk | MX0007 | 2024-01-11T14:05:01.190Z | 2024-01-17T14:23:22.712Z |
3759479 | 3759479 | 20240105110929_lDRUf | MX0007 | 2024-01-08T14:09:33.642Z | 2024-01-14T14:23:07.024Z |
3759222 | 3759222 | 20240105095455_n1GCY | MX0007 | 2024-01-08T14:08:57.367Z | 2024-01-14T14:23:04.121Z |
3758891 | 3758891 | 20240105075204_lW4U4 | MX0007 | 2024-01-08T14:08:06.245Z | 2024-01-14T14:23:00.106Z |
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);