participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,071 rows where station_code = "UK0049" 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 |
---|---|---|---|---|---|
5451324 | 5451324 | 20241031233234_fSZI5 | UK0049 | 2024-11-02T12:16:53.309Z | 2024-11-09T14:24:23.073Z |
5441688 | 5441688 | 20241029231105_493rL | UK0049 | 2024-11-01T12:18:53.156Z | 2024-11-07T14:26:43.009Z |
5441685 | 5441685 | 20241029231033_zoQCL | UK0049 | 2024-11-01T12:18:52.973Z | 2024-11-07T14:26:42.995Z |
5441327 | 5441327 | 20241029214306_w3mEN | UK0049 | 2024-11-01T12:18:26.434Z | 2024-11-07T14:26:41.722Z |
5441238 | 5441238 | 20241029211820_bMcvI | UK0049 | 2024-11-01T12:18:20.598Z | 2024-11-07T14:26:41.357Z |
5433609 | 5433609 | 20241029203124_xpST3 | UK0049 | 2024-10-31T12:22:24.367Z | 2024-11-07T14:26:40.316Z |
5433450 | 5433450 | 20241029200007_RdE4V | UK0049 | 2024-10-31T12:22:16.504Z | 2024-11-07T14:26:39.654Z |
5410828 | 5410828 | 20241027053957_mtQzN | UK0049 | 2024-10-29T12:18:05.850Z | 2024-11-04T14:29:05.637Z |
5410515 | 5410515 | 20241027051622_VhkyR | UK0049 | 2024-10-29T12:17:57.451Z | 2024-11-04T14:29:04.714Z |
5405514 | 5405514 | 20241027004003_eZt4a | UK0049 | 2024-10-29T12:12:59.731Z | 2024-11-04T14:28:53.581Z |
5404252 | 5404252 | 20241026231208_R2WjD | UK0049 | 2024-10-29T12:11:03.268Z | 2024-11-04T14:28:50.555Z |
5404051 | 5404051 | 20241026225453_4WnQH | UK0049 | 2024-10-29T12:10:51.012Z | 2024-11-04T14:28:50.276Z |
5404026 | 5404026 | 20241026225341_GOqcS | UK0049 | 2024-10-29T12:10:48.642Z | 2024-11-04T14:28:50.252Z |
5402609 | 5402609 | 20241026200426_Gll2y | UK0049 | 2024-10-29T12:07:48.002Z | 2024-11-04T14:28:45.609Z |
5398713 | 5398713 | 20241026032144_Fl0F8 | UK0049 | 2024-10-28T12:19:29.458Z | 2024-11-03T14:27:37.888Z |
5375112 | 5375112 | 20241024025802_BV4G9 | UK0049 | 2024-10-26T12:21:13.284Z | 2024-11-01T12:27:00.290Z |
5375069 | 5375069 | 20241024025537_CS2hK | UK0049 | 2024-10-26T12:21:11.705Z | 2024-11-01T12:27:00.177Z |
5363771 | 5363771 | 20241023214253_PZ3o9 | UK0049 | 2024-10-25T12:16:43.570Z | 2024-11-01T12:26:53.617Z |
5362067 | 5362067 | 20241023190539_Ouoa3 | UK0049 | 2024-10-25T12:13:49.216Z | 2024-11-01T12:26:50.940Z |
5361986 | 5361986 | 20241023190036_00FD1 | UK0049 | 2024-10-25T12:13:44.342Z | 2024-11-01T12:26:50.795Z |
5361187 | 5361187 | 20241023175734_6kieZ | UK0049 | 2024-10-25T12:12:26.423Z | 2024-11-01T12:26:49.504Z |
5350818 | 5350818 | 20241022223042_hb7b9 | UK0049 | 2024-10-24T12:16:37.648Z | 2024-10-31T12:29:58.825Z |
5349786 | 5349786 | 20241022203516_BW3tR | UK0049 | 2024-10-24T12:14:38.623Z | 2024-10-31T12:29:56.320Z |
5349159 | 5349159 | 20241022192955_7MJqp | UK0049 | 2024-10-24T12:13:14.097Z | 2024-10-31T12:29:54.658Z |
5349054 | 5349054 | 20241022192304_PlB0X | UK0049 | 2024-10-24T12:13:02.722Z | 2024-10-31T12:29:54.521Z |
5345118 | 5345118 | 20241022051333_sQ9AW | UK0049 | 2024-10-23T12:19:06.931Z | 2024-10-30T12:26:52.195Z |
5344892 | 5344892 | 20241022045500_VUDx2 | UK0049 | 2024-10-23T12:18:56.785Z | 2024-10-30T12:26:51.945Z |
5341684 | 5341684 | 20241022014847_1INSJ | UK0049 | 2024-10-23T12:16:06.998Z | 2024-10-30T12:26:47.337Z |
5341162 | 5341162 | 20241022011843_iroM2 | UK0049 | 2024-10-23T12:15:26.223Z | 2024-10-30T12:26:46.643Z |
5340654 | 5340654 | 20241022004025_2PaPq | UK0049 | 2024-10-23T12:14:46.240Z | 2024-10-30T12:26:46.116Z |
5340341 | 5340341 | 20241022000721_oL2fK | UK0049 | 2024-10-23T12:14:29.232Z | 2024-10-30T12:26:45.690Z |
5339825 | 5339825 | 20241021232029_SrKrb | UK0049 | 2024-10-23T12:13:53.687Z | 2024-10-30T12:26:44.982Z |
5338755 | 5338755 | 20241021203128_qi1CO | UK0049 | 2024-10-23T12:11:51.755Z | 2024-10-30T12:26:42.750Z |
5332575 | 5332575 | 20241020205604_qP5pS | UK0049 | 2024-10-22T12:13:38.211Z | 2024-10-29T12:26:33.562Z |
5332529 | 5332529 | 20241020202900_7tKwZ | UK0049 | 2024-10-22T12:13:24.791Z | 2024-10-29T12:26:33.473Z |
5332396 | 5332396 | 20241020192545_Y8zS5 | UK0049 | 2024-10-22T12:12:52.906Z | 2024-10-29T12:26:33.071Z |
5319665 | 5319665 | 20241017194312_RU3Rs | UK0049 | 2024-10-19T12:03:30.220Z | 2024-10-26T12:27:52.819Z |
5318695 | 5318695 | 20241017044034_FvMCu | UK0049 | 2024-10-18T12:04:17.809Z | 2024-10-25T12:24:36.560Z |
5318537 | 5318537 | 20241017034535_Z6FFH | UK0049 | 2024-10-18T12:03:57.867Z | 2024-10-25T12:24:36.157Z |
5318455 | 5318455 | 20241017032922_NtvEm | UK0049 | 2024-10-18T12:03:49.891Z | 2024-10-25T12:24:35.629Z |
5317540 | 5317540 | 20241017053503_0VUuX | UK0049 | 2024-10-18T12:00:07.890Z | 2024-10-26T12:27:50.180Z |
5304294 | 5304294 | 20241013043412_GIyEV | UK0049 | 2024-10-14T12:17:47.373Z | 2024-10-21T12:24:24.633Z |
5304219 | 5304219 | 20241013042909_C9c2o | UK0049 | 2024-10-14T12:17:45.024Z | 2024-10-21T12:24:24.439Z |
5304062 | 5304062 | 20241013040732_CG2G4 | UK0049 | 2024-10-14T12:17:41.971Z | 2024-10-21T12:24:23.052Z |
5303965 | 5303965 | 20241013035459_N2JK7 | UK0049 | 2024-10-14T12:17:39.316Z | 2024-10-21T12:24:22.245Z |
5301348 | 5301348 | 20241012231259_q3vuf | UK0049 | 2024-10-14T12:15:21.466Z | 2024-10-21T12:23:57.827Z |
5300754 | 5300754 | 20241012213828_O9Om7 | UK0049 | 2024-10-14T12:14:26.095Z | 2024-10-21T12:23:52.330Z |
5300498 | 5300498 | 20241012204431_nb2N3 | UK0049 | 2024-10-14T12:14:11.477Z | 2024-10-21T12:23:49.533Z |
5294853 | 5294853 | 20241013050121_WCoLn | UK0049 | 2024-10-14T12:00:27.875Z | 2024-10-22T12:24:06.106Z |
5294764 | 5294764 | 20241013044512_l3gc1 | UK0049 | 2024-10-14T12:00:18.252Z | 2024-10-22T12:24:05.229Z |
5290978 | 5290978 | 20241011193039_geCQQ | UK0049 | 2024-10-13T12:13:48.235Z | 2024-10-20T12:24:23.442Z |
5285493 | 5285493 | 20241011040005_aq9Be | UK0049 | 2024-10-12T12:18:11.360Z | 2024-10-19T12:28:02.931Z |
5285377 | 5285377 | 20241011035339_QlKnb | UK0049 | 2024-10-12T12:18:07.533Z | 2024-10-19T12:28:02.327Z |
5285254 | 5285254 | 20241011034253_XZEBL | UK0049 | 2024-10-12T12:18:00.824Z | 2024-10-19T12:28:01.609Z |
5284648 | 5284648 | 20241011025933_TZAF3 | UK0049 | 2024-10-12T12:17:31.825Z | 2024-10-19T12:27:57.001Z |
5284473 | 5284473 | 20241011024929_JhNUK | UK0049 | 2024-10-12T12:17:25.316Z | 2024-10-19T12:27:55.927Z |
5284409 | 5284409 | 20241011024124_TLjjl | UK0049 | 2024-10-12T12:17:21.001Z | 2024-10-19T12:27:55.806Z |
5284281 | 5284281 | 20241011023403_NBxHb | UK0049 | 2024-10-12T12:17:16.084Z | 2024-10-19T12:27:54.921Z |
5283908 | 5283908 | 20241011020543_AEXUl | UK0049 | 2024-10-12T12:17:01.388Z | 2024-10-19T12:27:53.339Z |
5283771 | 5283771 | 20241011015330_lQkv8 | UK0049 | 2024-10-12T12:16:55.970Z | 2024-10-19T12:27:52.701Z |
5283601 | 5283601 | 20241011013805_6elQr | UK0049 | 2024-10-12T12:16:48.023Z | 2024-10-19T12:27:52.246Z |
5283158 | 5283158 | 20241011005748_CRiXC | UK0049 | 2024-10-12T12:16:26.224Z | 2024-10-19T12:27:49.412Z |
5282872 | 5282872 | 20241011000202_qrxHq | UK0049 | 2024-10-12T12:16:09.701Z | 2024-10-19T12:27:47.181Z |
5282840 | 5282840 | 20241010235601_TkP6c | UK0049 | 2024-10-12T12:16:07.553Z | 2024-10-19T12:27:46.929Z |
5282734 | 5282734 | 20241010232033_3UcD3 | UK0049 | 2024-10-12T12:16:00.336Z | 2024-10-19T12:27:45.972Z |
5282718 | 5282718 | 20241010231611_p3En1 | UK0049 | 2024-10-12T12:15:59.490Z | 2024-10-19T12:27:45.769Z |
5282388 | 5282388 | 20241010213425_cX9oq | UK0049 | 2024-10-12T12:15:30.774Z | 2024-10-19T12:27:43.621Z |
5282351 | 5282351 | 20241010212100_LSjTE | UK0049 | 2024-10-12T12:15:29.618Z | 2024-10-19T12:27:43.456Z |
5282280 | 5282280 | 20241010210415_wakuG | UK0049 | 2024-10-12T12:15:25.848Z | 2024-10-19T12:27:43.100Z |
5282075 | 5282075 | 20241010201434_UMcjp | UK0049 | 2024-10-12T12:15:10.739Z | 2024-10-19T12:27:40.561Z |
5282057 | 5282057 | 20241010201227_VISJm | UK0049 | 2024-10-12T12:15:10.112Z | 2024-10-19T12:27:40.434Z |
5281734 | 5281734 | 20241010192511_VEOsq | UK0049 | 2024-10-12T12:14:38.409Z | 2024-10-19T12:27:36.018Z |
5276482 | 5276482 | 20241011044339_MODZ2 | UK0049 | 2024-10-12T12:01:14.748Z | 2024-10-20T12:23:10.012Z |
5276009 | 5276009 | 20241011041120_CCCKQ | UK0049 | 2024-10-12T12:00:12.360Z | 2024-10-20T12:23:04.161Z |
5255456 | 5255456 | 20241008042636_8eJmR | UK0049 | 2024-10-09T12:01:14.247Z | 2024-10-17T12:19:52.344Z |
5255433 | 5255433 | 20241008042522_Ko2i2 | UK0049 | 2024-10-09T12:01:12.639Z | 2024-10-17T12:19:52.299Z |
5255282 | 5255282 | 20241008040441_soN8b | UK0049 | 2024-10-09T12:00:55.167Z | 2024-10-17T12:19:51.569Z |
5255202 | 5255202 | 20241008035224_tkC4q | UK0049 | 2024-10-09T12:00:47.768Z | 2024-10-17T12:19:51.346Z |
5254159 | 5254159 | 20241007014414_P50tO | UK0049 | 2024-10-08T12:14:08.143Z | 2024-10-15T12:29:13.133Z |
5254013 | 5254013 | 20241007011744_8PqzR | UK0049 | 2024-10-08T12:13:57.960Z | 2024-10-15T12:29:12.631Z |
5253963 | 5253963 | 20241007011202_Fhbqs | UK0049 | 2024-10-08T12:13:55.905Z | 2024-10-15T12:29:12.557Z |
5246994 | 5246994 | 20241005013002_fz82O | UK0049 | 2024-10-07T12:18:49.735Z | 2024-10-13T12:26:25.627Z |
5239821 | 5239821 | 20241005042930_eZZ50 | UK0049 | 2024-10-07T12:07:11.763Z | 2024-10-14T12:24:20.782Z |
5239680 | 5239680 | 20241005042145_NZwrq | UK0049 | 2024-10-07T12:06:59.106Z | 2024-10-14T12:24:20.507Z |
5239594 | 5239594 | 20241005041205_MA1TL | UK0049 | 2024-10-07T12:06:49.296Z | 2024-10-14T12:24:20.335Z |
5239479 | 5239479 | 20241005040303_T6xR2 | UK0049 | 2024-10-07T12:06:28.623Z | 2024-10-14T12:24:19.343Z |
5239030 | 5239030 | 20241005032145_hxR0N | UK0049 | 2024-10-07T12:05:39.486Z | 2024-10-14T12:24:18.039Z |
5238507 | 5238507 | 20241005023722_LWhBf | UK0049 | 2024-10-07T12:04:37.511Z | 2024-10-14T12:24:16.651Z |
5238254 | 5238254 | 20241005021742_3q02p | UK0049 | 2024-10-07T12:03:59.757Z | 2024-10-14T12:24:15.873Z |
5234805 | 5234805 | 20241004221609_L8mSM | UK0049 | 2024-10-06T12:15:22.500Z | 2024-10-13T12:26:22.831Z |
5227725 | 5227725 | 20241004014219_xdw4b | UK0049 | 2024-10-05T12:21:38.029Z | 2024-10-12T12:25:12.949Z |
5227475 | 5227475 | 20241004012603_5eeZv | UK0049 | 2024-10-05T12:21:33.051Z | 2024-10-12T12:25:12.779Z |
5227120 | 5227120 | 20241004010230_257AE | UK0049 | 2024-10-05T12:21:13.678Z | 2024-10-12T12:25:12.503Z |
5227013 | 5227013 | 20241004005254_Mei70 | UK0049 | 2024-10-05T12:21:08.882Z | 2024-10-12T12:25:12.327Z |
5226679 | 5226679 | 20241004003014_4nBUq | UK0049 | 2024-10-05T12:20:53.604Z | 2024-10-12T12:25:11.998Z |
5226672 | 5226672 | 20241004003014_fjQVI | UK0049 | 2024-10-05T12:20:53.540Z | 2024-10-12T12:25:11.998Z |
5226534 | 5226534 | 20241004002118_sylss | UK0049 | 2024-10-05T12:20:47.430Z | 2024-10-12T12:25:11.823Z |
5226232 | 5226232 | 20241003235702_Zz6wW | UK0049 | 2024-10-05T12:20:33.997Z | 2024-10-12T12:25:11.398Z |
5219999 | 5219999 | 20241003043520_TTero | UK0049 | 2024-10-05T12:10:03.606Z | 2024-10-12T12:24:56.577Z |
5219924 | 5219924 | 20241003043014_Jmkl3 | UK0049 | 2024-10-05T12:09:54.727Z | 2024-10-12T12:24:56.484Z |
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);