participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,650 rows where station_code = "ES0006" 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 |
---|---|---|---|---|---|
5134018 | 5134018 | 20240916043212_A3Tb8 | ES0006 | 2024-09-19T12:17:16.364Z | 2024-09-19T12:17:16.364Z |
5133839 | 5133839 | 20240916040938_huMHt | ES0006 | 2024-09-19T12:17:10.226Z | 2024-09-19T12:17:10.226Z |
5132650 | 5132650 | 20240916015023_M2pjz | ES0006 | 2024-09-19T12:16:25.037Z | 2024-09-19T12:16:25.037Z |
5132488 | 5132488 | 20240916011548_r3apo | ES0006 | 2024-09-19T12:16:14.945Z | 2024-09-19T12:16:14.945Z |
5131941 | 5131941 | 20240915222141_uQBTt | ES0006 | 2024-09-19T12:15:35.324Z | 2024-09-19T12:15:35.324Z |
5116874 | 5116874 | 20240915034448_rLkXZ | ES0006 | 2024-09-18T12:07:23.966Z | 2024-09-19T12:19:12.495Z |
5115112 | 5115112 | 20240915022035_TNT8F | ES0006 | 2024-09-18T12:06:00.261Z | 2024-09-19T12:19:01.634Z |
5108316 | 5108316 | 20240913044844_B8QxG | ES0006 | 2024-09-17T12:13:36.262Z | 2024-09-19T12:20:48.121Z |
5102088 | 5102088 | 20240914010601_thyI8 | ES0006 | 2024-09-17T12:06:47.624Z | 2024-09-19T12:19:52.435Z |
5097209 | 5097209 | 20240913003626_uKC31 | ES0006 | 2024-09-16T12:17:07.962Z | 2024-09-19T12:20:37.854Z |
5085931 | 5085931 | 20240912215816_3q7Qs | ES0006 | 2024-09-16T12:05:04.088Z | 2024-09-19T12:20:29.805Z |
5054859 | 5054859 | 20240908043241_iTBoz | ES0006 | 2024-09-13T12:16:57.248Z | 2024-09-16T12:21:17.022Z |
5047315 | 5047315 | 20240909032812_z9ZAK | ES0006 | 2024-09-13T12:08:47.075Z | 2024-09-17T12:19:01.997Z |
5026502 | 5026502 | 20240905034459_2P6x8 | ES0006 | 2024-09-11T12:12:38.027Z | 2024-09-13T12:19:58.464Z |
5020960 | 5020960 | 20240905034459_uqcFN | ES0006 | 2024-09-10T12:15:09.101Z | 2024-09-10T12:16:55.280Z |
5010978 | 5010978 | 20240904040923_gVnH8 | ES0006 | 2024-09-09T12:09:16.974Z | 2024-09-12T12:19:30.051Z |
5010668 | 5010668 | 20240904033139_fxzCB | ES0006 | 2024-09-09T12:08:56.618Z | 2024-09-12T12:19:28.546Z |
5009832 | 5009832 | 20240904020541_sfs3i | ES0006 | 2024-09-09T12:08:07.598Z | 2024-09-12T12:19:24.594Z |
5009554 | 5009554 | 20240904013547_1SlxG | ES0006 | 2024-09-09T12:07:49.841Z | 2024-09-12T12:19:23.317Z |
4998967 | 4998967 | 20240903044234_5YRG1 | ES0006 | 2024-09-08T12:08:16.259Z | 2024-09-11T12:21:15.786Z |
4955169 | 4955169 | 20240811035421_2fjgm | ES0006 | 2024-09-03T12:18:51.598Z | 2024-09-06T12:29:22.631Z |
4955117 | 4955117 | 20240811034207_1tguk | ES0006 | 2024-09-03T12:18:45.360Z | 2024-09-06T12:29:19.750Z |
4949973 | 4949973 | 20240811015847_rL0Ra | ES0006 | 2024-09-02T12:16:01.169Z | 2024-09-06T12:27:39.434Z |
4949506 | 4949506 | 20240811015113_222Ar | ES0006 | 2024-09-02T12:15:47.918Z | 2024-09-06T12:27:34.233Z |
4947856 | 4947856 | 20240811012541_pNGz2 | ES0006 | 2024-09-02T12:14:49.053Z | 2024-09-06T12:27:03.259Z |
4946771 | 4946771 | 20240811010617_ZsfYd | ES0006 | 2024-09-02T12:14:06.898Z | 2024-09-06T12:26:33.729Z |
4939638 | 4939638 | 20240810225155_nZ32G | ES0006 | 2024-09-01T12:09:57.188Z | 2024-09-06T12:23:25.492Z |
4938951 | 4938951 | 20240810223253_vggHd | ES0006 | 2024-09-01T12:09:32.304Z | 2024-09-06T12:23:08.559Z |
4929437 | 4929437 | 20240810041215_VFcPf | ES0006 | 2024-08-31T12:22:16.605Z | 2024-09-02T12:29:34.587Z |
4926849 | 4926849 | 20240810015834_mofzG | ES0006 | 2024-08-31T12:20:06.643Z | 2024-09-02T12:28:08.085Z |
4922431 | 4922431 | 20240810011617_RNO39 | ES0006 | 2024-08-30T12:14:49.489Z | 2024-09-02T12:27:26.584Z |
4919863 | 4919863 | 20240810002008_AZF8S | ES0006 | 2024-08-30T12:13:01.678Z | 2024-09-02T12:26:04.107Z |
4919704 | 4919704 | 20240810001748_JYLhr | ES0006 | 2024-08-30T12:12:58.529Z | 2024-09-02T12:25:57.240Z |
4917970 | 4917970 | 20240809234403_osW0S | ES0006 | 2024-08-30T12:11:47.054Z | 2024-09-02T12:25:22.908Z |
4913385 | 4913385 | 20240809214707_2zR8K | ES0006 | 2024-08-29T12:09:10.079Z | 2024-09-02T12:22:52.715Z |
4898240 | 4898240 | 20240807211459_tqALO | ES0006 | 2024-08-28T12:16:22.281Z | 2024-08-28T12:16:22.281Z |
4892628 | 4892628 | 20240809042509_ABNC8 | ES0006 | 2024-08-28T12:10:26.044Z | 2024-08-30T12:22:22.104Z |
4890881 | 4890881 | 20240809000023_t52G0 | ES0006 | 2024-08-28T12:08:16.428Z | 2024-08-30T12:20:38.733Z |
4890625 | 4890625 | 20240808233232_A5KIt | ES0006 | 2024-08-28T12:07:59.827Z | 2024-08-30T12:20:23.731Z |
4877489 | 4877489 | 20240807000527_Ki2ss | ES0006 | 2024-08-19T12:13:36.100Z | 2024-08-27T12:13:12.839Z |
4826527 | 4826527 | 20240804040226_GFajj | ES0006 | 2024-08-14T12:21:10.842Z | 2024-08-15T12:26:20.849Z |
4826509 | 4826509 | 20240804034831_5cT5p | ES0006 | 2024-08-14T12:21:09.741Z | 2024-08-15T12:26:20.404Z |
4825042 | 4825042 | 20240804003853_nxrpA | ES0006 | 2024-08-14T12:19:52.755Z | 2024-08-15T12:25:42.924Z |
4824990 | 4824990 | 20240804003427_0SXGC | ES0006 | 2024-08-14T12:19:47.833Z | 2024-08-15T12:25:41.455Z |
4824878 | 4824878 | 20240804002531_USRuC | ES0006 | 2024-08-14T12:19:38.722Z | 2024-08-15T12:25:39.424Z |
4824861 | 4824861 | 20240804002355_i64wD | ES0006 | 2024-08-14T12:19:36.504Z | 2024-08-15T12:25:38.576Z |
4806759 | 4806759 | 20240803041741_9BGkp | ES0006 | 2024-08-12T12:19:20.159Z | 2024-08-13T12:17:50.163Z |
4806665 | 4806665 | 20240803024633_umAiQ | ES0006 | 2024-08-12T12:19:12.859Z | 2024-08-13T12:17:46.610Z |
4763098 | 4763098 | 20240731034256_pqCxK | ES0006 | 2024-08-06T12:03:43.510Z | 2024-08-10T12:18:06.697Z |
4763067 | 4763067 | 20240731033243_tZsA8 | ES0006 | 2024-08-06T12:03:40.473Z | 2024-08-10T12:18:05.596Z |
4762012 | 4762012 | 20240731014436_70YVm | ES0006 | 2024-08-06T12:01:36.432Z | 2024-08-10T12:17:32.965Z |
4761944 | 4761944 | 20240731014130_WfD5x | ES0006 | 2024-08-06T12:01:22.135Z | 2024-08-10T12:17:30.777Z |
4761002 | 4761002 | 20240731000129_rayne | ES0006 | 2024-08-05T12:16:21.120Z | 2024-08-08T12:24:53.925Z |
4759433 | 4759433 | 20240730225055_GLdVP | ES0006 | 2024-08-05T12:15:25.591Z | 2024-08-08T12:24:02.990Z |
4759055 | 4759055 | 20240730223135_uU2gc | ES0006 | 2024-08-05T12:14:53.598Z | 2024-08-08T12:23:50.349Z |
4757795 | 4757795 | 20240730211646_2Aqry | ES0006 | 2024-08-05T12:13:42.447Z | 2024-08-08T12:23:02.436Z |
4734999 | 4734999 | 20240729020219_OWiuy | ES0006 | 2024-08-01T12:04:48.177Z | 2024-08-06T12:14:51.362Z |
4721418 | 4721418 | 20240728030900_vqTFA | ES0006 | 2024-07-31T12:06:39.015Z | 2024-08-05T12:19:56.789Z |
4720645 | 4720645 | 20240728233140_hYzAn | ES0006 | 2024-07-31T12:01:33.825Z | 2024-08-06T12:14:33.275Z |
4720643 | 4720643 | 20240728233132_1alUV | ES0006 | 2024-07-31T12:01:33.468Z | 2024-08-06T12:14:33.271Z |
4718538 | 4718538 | 20240728023826_gcqqo | ES0006 | 2024-07-30T12:09:41.355Z | 2024-08-05T12:19:55.714Z |
4715145 | 4715145 | 20240728010138_SX248 | ES0006 | 2024-07-30T12:05:56.829Z | 2024-08-05T12:19:42.976Z |
4691799 | 4691799 | 20240726030757_y2To3 | ES0006 | 2024-07-27T12:06:12.284Z | 2024-08-03T12:21:24.578Z |
4681114 | 4681114 | 20240724034859_b9GHq | ES0006 | 2024-07-25T12:03:22.473Z | 2024-08-01T12:12:03.487Z |
4681095 | 4681095 | 20240724032733_tbk5o | ES0006 | 2024-07-25T12:03:19.924Z | 2024-08-01T12:12:03.405Z |
4681078 | 4681078 | 20240724024804_yq7ZY | ES0006 | 2024-07-25T12:03:15.143Z | 2024-08-01T12:12:03.321Z |
4680490 | 4680490 | 20240723222110_ZtffV | ES0006 | 2024-07-25T12:02:07.555Z | 2024-08-01T12:12:01.908Z |
4677863 | 4677863 | 20240723010508_Q9phL | ES0006 | 2024-07-24T12:02:24.532Z | 2024-07-31T12:17:55.247Z |
4677514 | 4677514 | 20240722223047_Mt9xg | ES0006 | 2024-07-24T12:01:11.155Z | 2024-07-31T12:17:51.956Z |
4668494 | 4668494 | 20240719015554_3jlZA | ES0006 | 2024-07-20T12:04:40.029Z | 2024-07-27T12:17:17.693Z |
4662806 | 4662806 | 20240718020002_s57QJ | ES0006 | 2024-07-19T12:05:09.539Z | 2024-07-26T12:17:45.439Z |
4635482 | 4635482 | 20240713030114_AviJy | ES0006 | 2024-07-15T12:07:37.932Z | 2024-07-21T12:13:33.706Z |
4577205 | 4577205 | 20240706231840_jEugw | ES0006 | 2024-07-09T12:00:28.885Z | 2024-07-15T12:11:50.795Z |
4562521 | 4562521 | 20240705003058_CcmSE | ES0006 | 2024-07-07T12:03:29.454Z | 2024-07-13T12:12:47.903Z |
4553954 | 4553954 | 20240704020041_RpjxF | ES0006 | 2024-07-06T12:02:55.932Z | 2024-07-12T12:08:53.975Z |
4538554 | 4538554 | 20240703021001_t27ip | ES0006 | 2024-07-04T12:02:28.638Z | 2024-07-11T12:14:38.252Z |
4456774 | 4456774 | 20240613030200_JUsdf | ES0006 | 2024-06-14T12:02:06.961Z | 2024-06-21T12:11:33.839Z |
4456772 | 4456772 | 20240613025931_9Jf9G | ES0006 | 2024-06-14T12:02:06.766Z | 2024-06-21T12:11:33.828Z |
4455756 | 4455756 | 20240612232503_Nf93E | ES0006 | 2024-06-14T12:01:07.767Z | 2024-06-21T12:11:29.573Z |
4402988 | 4402988 | 20240601033002_iol0y | ES0006 | 2024-06-03T12:10:41.753Z | 2024-06-09T12:06:02.280Z |
4387753 | 4387753 | 20240528032736_qB0r1 | ES0006 | 2024-05-29T12:08:29.370Z | 2024-06-05T12:18:12.419Z |
4347985 | 4347985 | 20240510023127_5FxHV | ES0006 | 2024-05-20T12:11:13.890Z | 2024-05-21T12:11:21.414Z |
4343466 | 4343466 | 20240510020808_MHxYV | ES0006 | 2024-05-19T12:11:57.974Z | 2024-05-21T12:11:16.955Z |
4235683 | 4235683 | 20240423042454_Is4BX | ES0006 | 2024-04-26T12:05:04.443Z | 2024-05-02T12:22:28.346Z |
4230879 | 4230879 | 20240422041800_3Svu5 | ES0006 | 2024-04-23T12:10:03.938Z | 2024-04-30T12:17:06.365Z |
4227333 | 4227333 | 20240422021802_bXarK | ES0006 | 2024-04-23T12:02:16.088Z | 2024-04-30T12:16:58.744Z |
4227145 | 4227145 | 20240422014428_Kh0EL | ES0006 | 2024-04-23T12:01:48.686Z | 2024-04-30T12:16:55.176Z |
4226902 | 4226902 | 20240422010039_JhTvl | ES0006 | 2024-04-23T12:01:22.808Z | 2024-04-30T12:16:51.148Z |
4226380 | 4226380 | 20240421233625_CsrmR | ES0006 | 2024-04-23T12:00:21.719Z | 2024-04-30T12:16:45.046Z |
4218717 | 4218717 | 20240419224051_gJnMb | ES0006 | 2024-04-21T12:00:19.212Z | 2024-04-28T12:21:01.081Z |
4201763 | 4201763 | 20240417025034_i6OP3 | ES0006 | 2024-04-18T12:03:53.325Z | 2024-04-25T12:21:22.634Z |
4186333 | 4186333 | 20240414044130_WfCHQ | ES0006 | 2024-04-15T12:06:29.557Z | 2024-04-22T12:22:29.835Z |
4175909 | 4175909 | 20240412045048_uBjXi | ES0006 | 2024-04-13T12:07:12.748Z | 2024-04-20T12:25:33.552Z |
4175882 | 4175882 | 20240412041235_2d0Kz | ES0006 | 2024-04-13T12:07:08.580Z | 2024-04-20T12:25:33.168Z |
4172074 | 4172074 | 20240410034245_VQo9H | ES0006 | 2024-04-12T12:08:46.917Z | 2024-04-18T12:21:21.895Z |
4171095 | 4171095 | 20240411042307_zQ5mc | ES0006 | 2024-04-12T12:04:52.063Z | 2024-04-19T12:13:20.561Z |
4063186 | 4063186 | 20240312043106_3cQH3 | ES0006 | 2024-03-13T12:05:27.552Z | 2024-03-20T12:21:38.157Z |
4007665 | 4007665 | 20240226203658_B7djW | ES0006 | 2024-02-29T14:06:32.054Z | 2024-03-06T14:19:36.210Z |
3992298 | 3992298 | 20240219221644_SwA2v | ES0006 | 2024-02-21T14:05:56.850Z | 2024-02-28T14:14:26.589Z |
3988834 | 3988834 | 20240219053854_oqRQs | ES0006 | 2024-02-20T14:05:31.653Z | 2024-02-27T14:13:51.478Z |
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);