participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,780 rows where station_code = "ES000C" 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 |
---|---|---|---|---|---|
5133725 | 5133725 | 20240916035704_Z91tS | ES000C | 2024-09-19T12:17:06.272Z | 2024-09-19T12:17:06.272Z |
5133357 | 5133357 | 20240916032619_t1YQE | ES000C | 2024-09-19T12:16:55.290Z | 2024-09-19T12:16:55.290Z |
5121866 | 5121866 | 20240914041747_txPHp | ES000C | 2024-09-18T12:11:02.390Z | 2024-09-19T12:20:02.450Z |
5121556 | 5121556 | 20240914040905_LLbsn | ES000C | 2024-09-18T12:10:58.298Z | 2024-09-19T12:20:02.117Z |
5121427 | 5121427 | 20240914040056_Ml4GP | ES000C | 2024-09-18T12:10:55.351Z | 2024-09-19T12:20:01.814Z |
5120650 | 5120650 | 20240914033051_jGvnZ | ES000C | 2024-09-18T12:10:44.231Z | 2024-09-19T12:20:00.672Z |
5120472 | 5120472 | 20240914032248_6MwNu | ES000C | 2024-09-18T12:10:41.234Z | 2024-09-19T12:20:00.437Z |
5119658 | 5119658 | 20240914024335_Dcs3u | ES000C | 2024-09-18T12:10:23.569Z | 2024-09-19T12:19:58.672Z |
5119646 | 5119646 | 20240914024154_HyCew | ES000C | 2024-09-18T12:10:22.846Z | 2024-09-19T12:19:58.635Z |
5116770 | 5116770 | 20240915034036_DAPfY | ES000C | 2024-09-18T12:07:20.452Z | 2024-09-19T12:19:12.318Z |
5115756 | 5115756 | 20240915025304_O3nVg | ES000C | 2024-09-18T12:06:23.146Z | 2024-09-19T12:19:06.778Z |
5115628 | 5115628 | 20240915024646_aOYWw | ES000C | 2024-09-18T12:06:19.765Z | 2024-09-19T12:19:05.841Z |
5114363 | 5114363 | 20240915013924_3nyDT | ES000C | 2024-09-18T12:05:13.530Z | 2024-09-19T12:18:57.827Z |
5113537 | 5113537 | 20240915005645_9B7oY | ES000C | 2024-09-18T12:04:26.892Z | 2024-09-19T12:18:50.079Z |
5107688 | 5107688 | 20240913040820_b3BVG | ES000C | 2024-09-17T12:13:21.598Z | 2024-09-19T12:20:47.455Z |
5107469 | 5107469 | 20240913035739_PcN0v | ES000C | 2024-09-17T12:13:15.920Z | 2024-09-19T12:20:47.175Z |
5105116 | 5105116 | 20240913023153_gFDvh | ES000C | 2024-09-17T12:11:56.923Z | 2024-09-19T12:20:43.720Z |
5102344 | 5102344 | 20240914012114_MwCka | ES000C | 2024-09-17T12:07:03.580Z | 2024-09-19T12:19:53.857Z |
5088371 | 5088371 | 20240913000826_LJ1MR | ES000C | 2024-09-16T12:07:56.812Z | 2024-09-19T12:20:36.726Z |
5088240 | 5088240 | 20240913000232_dx3vs | ES000C | 2024-09-16T12:07:49.664Z | 2024-09-19T12:20:36.542Z |
5088040 | 5088040 | 20240912235413_tkbpR | ES000C | 2024-09-16T12:07:41.829Z | 2024-09-19T12:20:36.199Z |
5087984 | 5087984 | 20240912235300_40KkB | ES000C | 2024-09-16T12:07:39.937Z | 2024-09-19T12:20:36.035Z |
5087954 | 5087954 | 20240912234927_5uZkH | ES000C | 2024-09-16T12:07:37.946Z | 2024-09-19T12:20:35.980Z |
5087210 | 5087210 | 20240912231627_ZealT | ES000C | 2024-09-16T12:06:47.242Z | 2024-09-19T12:20:34.206Z |
5086394 | 5086394 | 20240912223213_L6s7i | ES000C | 2024-09-16T12:05:39.926Z | 2024-09-19T12:20:31.042Z |
5080751 | 5080751 | 20240911043818_xnv0x | ES000C | 2024-09-15T12:17:12.195Z | 2024-09-19T12:21:43.574Z |
5080682 | 5080682 | 20240911042153_Pr6i8 | ES000C | 2024-09-15T12:17:10.101Z | 2024-09-19T12:21:43.386Z |
5079777 | 5079777 | 20240911031059_0IwJ2 | ES000C | 2024-09-15T12:16:35.057Z | 2024-09-19T12:21:42.600Z |
5078393 | 5078393 | 20240911015545_KKfBr | ES000C | 2024-09-15T12:15:37.999Z | 2024-09-19T12:21:40.338Z |
5077808 | 5077808 | 20240911011947_mcNFy | ES000C | 2024-09-15T12:15:06.513Z | 2024-09-19T12:21:39.664Z |
5076779 | 5076779 | 20240911000844_WhCRw | ES000C | 2024-09-15T12:14:03.080Z | 2024-09-19T12:21:37.569Z |
5069252 | 5069252 | 20240910212314_RE93z | ES000C | 2024-09-14T12:19:50.529Z | 2024-09-19T12:21:34.106Z |
5065518 | 5065518 | 20240910042937_U6gUS | ES000C | 2024-09-14T12:17:08.596Z | 2024-09-18T12:15:19.670Z |
5065249 | 5065249 | 20240910032941_aRyxe | ES000C | 2024-09-14T12:16:49.214Z | 2024-09-18T12:15:18.829Z |
5065100 | 5065100 | 20240910030453_Xo56q | ES000C | 2024-09-14T12:16:25.433Z | 2024-09-18T12:15:18.378Z |
5064760 | 5064760 | 20240910015828_sEYUs | ES000C | 2024-09-14T12:15:59.899Z | 2024-09-18T12:15:17.267Z |
5064550 | 5064550 | 20240910013310_ZFixs | ES000C | 2024-09-14T12:15:38.583Z | 2024-09-18T12:15:16.828Z |
5064200 | 5064200 | 20240910002113_B57YC | ES000C | 2024-09-14T12:15:03.757Z | 2024-09-18T12:15:15.780Z |
5064104 | 5064104 | 20240909235806_kn2N1 | ES000C | 2024-09-14T12:14:53.318Z | 2024-09-18T12:15:15.513Z |
5064090 | 5064090 | 20240909234931_d0au3 | ES000C | 2024-09-14T12:14:49.731Z | 2024-09-18T12:15:15.483Z |
5063707 | 5063707 | 20240909221731_HFGst | ES000C | 2024-09-14T12:14:14.001Z | 2024-09-18T12:15:14.372Z |
5046065 | 5046065 | 20240908210350_N0zwf | ES000C | 2024-09-13T12:05:45.285Z | 2024-09-17T12:18:58.500Z |
5045977 | 5045977 | 20240908202410_5CUdM | ES000C | 2024-09-13T12:05:29.741Z | 2024-09-17T12:18:58.304Z |
5026107 | 5026107 | 20240905021735_lMv2r | ES000C | 2024-09-11T12:11:55.761Z | 2024-09-13T12:19:56.868Z |
5025711 | 5025711 | 20240905005926_3Ac6s | ES000C | 2024-09-11T12:10:50.547Z | 2024-09-13T12:19:55.239Z |
5020128 | 5020128 | 20240905005926_TSEiD | ES000C | 2024-09-10T12:13:57.697Z | 2024-09-13T12:19:55.241Z |
5019725 | 5019725 | 20240904234304_U36me | ES000C | 2024-09-10T12:13:19.855Z | 2024-09-13T12:19:53.620Z |
5019470 | 5019470 | 20240904225552_kHOna | ES000C | 2024-09-10T12:12:47.776Z | 2024-09-13T12:19:52.192Z |
5018964 | 5018964 | 20240904211342_m6POU | ES000C | 2024-09-10T12:11:51.079Z | 2024-09-13T12:19:49.933Z |
5018769 | 5018769 | 20240904201213_x6FlS | ES000C | 2024-09-10T12:11:31.657Z | 2024-09-13T12:19:48.859Z |
4847437 | 4847437 | 20240805034653_1trYR | ES000C | 2024-08-16T12:20:51.729Z | 2024-08-17T12:33:01.369Z |
4836971 | 4836971 | 20240805024201_Oa36s | ES000C | 2024-08-15T12:16:32.338Z | 2024-08-17T12:32:50.475Z |
4836558 | 4836558 | 20240805022134_2O7du | ES000C | 2024-08-15T12:16:13.691Z | 2024-08-17T12:32:42.565Z |
4836117 | 4836117 | 20240805020503_TPObi | ES000C | 2024-08-15T12:15:59.845Z | 2024-08-17T12:32:30.273Z |
4834403 | 4834403 | 20240805005641_DZk8s | ES000C | 2024-08-15T12:14:40.560Z | 2024-08-17T12:31:55.532Z |
4833691 | 4833691 | 20240805002957_ZM6hQ | ES000C | 2024-08-15T12:14:06.968Z | 2024-08-17T12:31:43.221Z |
4832855 | 4832855 | 20240804235321_UhYWB | ES000C | 2024-08-15T12:13:15.110Z | 2024-08-17T12:31:15.957Z |
4832453 | 4832453 | 20240804233550_7UMud | ES000C | 2024-08-15T12:13:01.133Z | 2024-08-17T12:31:04.655Z |
4830568 | 4830568 | 20240804214355_VWDR2 | ES000C | 2024-08-15T12:10:42.994Z | 2024-08-17T12:29:53.604Z |
4826484 | 4826484 | 20240804034249_mCJfU | ES000C | 2024-08-14T12:21:08.731Z | 2024-08-15T12:26:20.019Z |
4826465 | 4826465 | 20240804033405_3r7mM | ES000C | 2024-08-14T12:21:07.777Z | 2024-08-15T12:26:19.719Z |
4826422 | 4826422 | 20240804031859_3oGWr | ES000C | 2024-08-14T12:21:01.552Z | 2024-08-15T12:26:18.423Z |
4826334 | 4826334 | 20240804024807_e6n8E | ES000C | 2024-08-14T12:20:56.598Z | 2024-08-15T12:26:16.644Z |
4825832 | 4825832 | 20240804014619_6hf2H | ES000C | 2024-08-14T12:20:27.515Z | 2024-08-15T12:26:00.780Z |
4825509 | 4825509 | 20240804011945_M9lQF | ES000C | 2024-08-14T12:20:11.557Z | 2024-08-15T12:25:54.113Z |
4825367 | 4825367 | 20240804010859_WZVyO | ES000C | 2024-08-14T12:20:04.485Z | 2024-08-15T12:25:50.308Z |
4825280 | 4825280 | 20240804005946_Z22B4 | ES000C | 2024-08-14T12:20:01.236Z | 2024-08-15T12:25:48.439Z |
4825194 | 4825194 | 20240804005223_f3gqA | ES000C | 2024-08-14T12:19:58.865Z | 2024-08-15T12:25:46.595Z |
4806642 | 4806642 | 20240803024402_PiCdJ | ES000C | 2024-08-12T12:19:11.821Z | 2024-08-13T12:17:45.849Z |
4806319 | 4806319 | 20240803014935_2ia2C | ES000C | 2024-08-12T12:18:42.998Z | 2024-08-13T12:17:36.941Z |
4805910 | 4805910 | 20240803010709_2jpIz | ES000C | 2024-08-12T12:18:12.104Z | 2024-08-13T12:17:26.745Z |
4804551 | 4804551 | 20240802224826_MSKPy | ES000C | 2024-08-12T12:16:39.109Z | 2024-08-13T12:16:59.234Z |
4804367 | 4804367 | 20240802221945_cZfxp | ES000C | 2024-08-12T12:16:19.372Z | 2024-08-13T12:16:55.109Z |
4736571 | 4736571 | 20240729025357_wPp37 | ES000C | 2024-08-01T12:05:33.336Z | 2024-08-06T12:14:56.393Z |
4736260 | 4736260 | 20240729024140_23Vs2 | ES000C | 2024-08-01T12:05:25.273Z | 2024-08-06T12:14:55.063Z |
4733248 | 4733248 | 20240729011941_wvccX | ES000C | 2024-08-01T12:03:41.423Z | 2024-08-06T12:14:46.129Z |
4705328 | 4705328 | 20240727225757_JrOsQ | ES000C | 2024-07-29T12:01:39.440Z | 2024-08-05T12:19:25.517Z |
4690275 | 4690275 | 20240725233542_5AjFQ | ES000C | 2024-07-27T12:03:02.303Z | 2024-08-03T12:21:08.967Z |
4690174 | 4690174 | 20240725232238_TUaFB | ES000C | 2024-07-27T12:02:44.018Z | 2024-08-03T12:21:07.861Z |
4689637 | 4689637 | 20240725215552_G4ned | ES000C | 2024-07-27T12:01:19.537Z | 2024-08-03T12:21:02.639Z |
4677475 | 4677475 | 20240722221142_pOPOu | ES000C | 2024-07-24T12:01:03.526Z | 2024-07-31T12:17:51.212Z |
4672895 | 4672895 | 20240720030944_xgQ3x | ES000C | 2024-07-21T12:04:30.201Z | 2024-07-28T12:14:57.652Z |
4664991 | 4664991 | 20240717032811_nVECg | ES000C | 2024-07-19T12:09:19.454Z | 2024-07-25T12:14:10.920Z |
4664971 | 4664971 | 20240717030625_2bllB | ES000C | 2024-07-19T12:09:17.765Z | 2024-07-25T12:14:10.484Z |
4664573 | 4664573 | 20240717015759_pN2lQ | ES000C | 2024-07-19T12:09:04.794Z | 2024-07-25T12:14:08.095Z |
4664361 | 4664361 | 20240717013444_fwOFi | ES000C | 2024-07-19T12:08:53.894Z | 2024-07-25T12:14:06.571Z |
4662943 | 4662943 | 20240718031302_ngVON | ES000C | 2024-07-19T12:05:25.627Z | 2024-07-26T12:17:46.987Z |
4662913 | 4662913 | 20240718024316_7z2oR | ES000C | 2024-07-19T12:05:21.699Z | 2024-07-26T12:17:46.420Z |
4662648 | 4662648 | 20240718013538_aB7Ba | ES000C | 2024-07-19T12:04:52.188Z | 2024-07-26T12:17:44.406Z |
4662387 | 4662387 | 20240718005351_HGH2d | ES000C | 2024-07-19T12:04:29.268Z | 2024-07-26T12:17:41.244Z |
4662228 | 4662228 | 20240718003254_Z88A3 | ES000C | 2024-07-19T12:04:16.640Z | 2024-07-26T12:17:38.765Z |
4651393 | 4651393 | 20240713224411_lSdRd | ES000C | 2024-07-17T12:11:26.727Z | 2024-07-22T12:10:15.002Z |
4651042 | 4651042 | 20240715031002_sUKsf | ES000C | 2024-07-17T12:09:43.675Z | 2024-07-23T12:08:48.545Z |
4650986 | 4650986 | 20240715023731_2pXAC | ES000C | 2024-07-17T12:09:39.633Z | 2024-07-23T12:08:48.428Z |
4650937 | 4650937 | 20240715022339_aza2E | ES000C | 2024-07-17T12:09:36.010Z | 2024-07-23T12:08:48.318Z |
4650386 | 4650386 | 20240715013521_srh3w | ES000C | 2024-07-17T12:09:14.503Z | 2024-07-23T12:08:47.364Z |
4649539 | 4649539 | 20240715005459_p31jk | ES000C | 2024-07-17T12:08:41.591Z | 2024-07-23T12:08:45.839Z |
4649135 | 4649135 | 20240715003006_zWMQA | ES000C | 2024-07-17T12:08:30.841Z | 2024-07-23T12:08:44.904Z |
4648801 | 4648801 | 20240715001308_I8O1H | ES000C | 2024-07-17T12:08:16.184Z | 2024-07-23T12:08:44.180Z |
4648374 | 4648374 | 20240714234242_8CfCW | ES000C | 2024-07-17T12:07:52.596Z | 2024-07-23T12:08:42.748Z |
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);