participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
701 rows where station_code = "NL000T" 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 |
---|---|---|---|---|---|
5127959 | 5127959 | 20240917001034_DHbPk | NL000T | 2024-09-19T12:09:48.768Z | 2024-09-19T12:09:48.768Z |
5127336 | 5127336 | 20240916213127_V5n7f | NL000T | 2024-09-19T12:08:54.592Z | 2024-09-19T12:08:54.592Z |
5127055 | 5127055 | 20240916201825_8L53g | NL000T | 2024-09-19T12:07:59.015Z | 2024-09-19T12:07:59.015Z |
5126944 | 5126944 | 20240916195848_pCFOg | NL000T | 2024-09-19T12:07:46.207Z | 2024-09-19T12:07:46.207Z |
5126929 | 5126929 | 20240916195411_0DVQ2 | NL000T | 2024-09-19T12:07:42.621Z | 2024-09-19T12:07:42.621Z |
5126764 | 5126764 | 20240916190845_4JclA | NL000T | 2024-09-19T12:07:05.284Z | 2024-09-19T12:07:05.284Z |
5120312 | 5120312 | 20240914031430_0uk27 | NL000T | 2024-09-18T12:10:36.959Z | 2024-09-19T12:19:59.864Z |
5120227 | 5120227 | 20240914030913_UO3Uh | NL000T | 2024-09-18T12:10:35.532Z | 2024-09-19T12:19:59.743Z |
5119913 | 5119913 | 20240914025244_JqXZf | NL000T | 2024-09-18T12:10:29.055Z | 2024-09-19T12:19:59.139Z |
5119882 | 5119882 | 20240914025133_Pps3A | NL000T | 2024-09-18T12:10:28.343Z | 2024-09-19T12:19:59.035Z |
5119498 | 5119498 | 20240914023630_ovrgr | NL000T | 2024-09-18T12:10:21.722Z | 2024-09-19T12:19:58.390Z |
5119326 | 5119326 | 20240914022404_Ff72N | NL000T | 2024-09-18T12:10:19.969Z | 2024-09-19T12:19:57.937Z |
5119311 | 5119311 | 20240914022254_xGikP | NL000T | 2024-09-18T12:10:19.771Z | 2024-09-19T12:19:57.900Z |
5116971 | 5116971 | 20240915035126_J6UzA | NL000T | 2024-09-18T12:07:26.689Z | 2024-09-19T12:19:12.820Z |
5116418 | 5116418 | 20240915032539_9leAG | NL000T | 2024-09-18T12:07:01.982Z | 2024-09-19T12:19:11.103Z |
5115759 | 5115759 | 20240915025311_L3poC | NL000T | 2024-09-18T12:06:23.284Z | 2024-09-19T12:19:07.095Z |
5115699 | 5115699 | 20240915024906_jGfsX | NL000T | 2024-09-18T12:06:21.372Z | 2024-09-19T12:19:06.400Z |
5115335 | 5115335 | 20240915023348_UHqCy | NL000T | 2024-09-18T12:06:11.249Z | 2024-09-19T12:19:03.972Z |
5114952 | 5114952 | 20240915020943_Al6mZ | NL000T | 2024-09-18T12:05:45.693Z | 2024-09-19T12:19:00.770Z |
5114332 | 5114332 | 20240915013646_5qu8d | NL000T | 2024-09-18T12:05:11.005Z | 2024-09-19T12:18:57.575Z |
5113881 | 5113881 | 20240915011658_z6hId | NL000T | 2024-09-18T12:04:54.368Z | 2024-09-19T12:18:54.015Z |
5113782 | 5113782 | 20240915011345_bBvbi | NL000T | 2024-09-18T12:04:50.455Z | 2024-09-19T12:18:52.628Z |
5113773 | 5113773 | 20240915011149_z9Qkx | NL000T | 2024-09-18T12:04:49.521Z | 2024-09-19T12:18:51.859Z |
5113435 | 5113435 | 20240915004927_V12GN | NL000T | 2024-09-18T12:04:16.835Z | 2024-09-19T12:18:49.062Z |
5113372 | 5113372 | 20240915004125_5pknd | NL000T | 2024-09-18T12:04:10.823Z | 2024-09-19T12:18:48.665Z |
5112943 | 5112943 | 20240915000822_0I0Te | NL000T | 2024-09-18T12:03:49.073Z | 2024-09-19T12:18:45.992Z |
5112797 | 5112797 | 20240914235557_gzOjY | NL000T | 2024-09-18T12:03:34.383Z | 2024-09-19T12:18:44.904Z |
5112663 | 5112663 | 20240914233906_2TpPa | NL000T | 2024-09-18T12:03:19.798Z | 2024-09-19T12:18:42.670Z |
5111315 | 5111315 | 20240914202056_Nl12i | NL000T | 2024-09-18T12:01:48.534Z | 2024-09-19T12:18:28.851Z |
5110833 | 5110833 | 20240914190140_lHdGy | NL000T | 2024-09-18T12:01:03.321Z | 2024-09-19T12:18:24.094Z |
5110455 | 5110455 | 20240911013506_HtI3v | NL000T | 2024-09-17T12:17:58.797Z | 2024-09-19T12:21:39.902Z |
5106272 | 5106272 | 20240913031648_y9XF3 | NL000T | 2024-09-17T12:12:47.768Z | 2024-09-19T12:20:45.738Z |
5106197 | 5106197 | 20240913031543_p23zy | NL000T | 2024-09-17T12:12:44.854Z | 2024-09-19T12:20:45.634Z |
5104680 | 5104680 | 20240913021854_aeYvH | NL000T | 2024-09-17T12:11:42.318Z | 2024-09-19T12:20:42.679Z |
5104564 | 5104564 | 20240913021513_Xr6d8 | NL000T | 2024-09-17T12:11:39.404Z | 2024-09-19T12:20:41.701Z |
5103824 | 5103824 | 20240913014124_XtjkU | NL000T | 2024-09-17T12:11:11.783Z | 2024-09-19T12:20:40.593Z |
5103403 | 5103403 | 20240913012946_dnm7z | NL000T | 2024-09-17T12:10:56.415Z | 2024-09-19T12:20:40.158Z |
5102871 | 5102871 | 20240914015030_hdgkO | NL000T | 2024-09-17T12:07:41.449Z | 2024-09-19T12:19:55.998Z |
5102681 | 5102681 | 20240914013712_4zl2f | NL000T | 2024-09-17T12:07:31.141Z | 2024-09-19T12:19:55.399Z |
5102438 | 5102438 | 20240914012543_qVWYe | NL000T | 2024-09-17T12:07:09.633Z | 2024-09-19T12:19:54.139Z |
5102341 | 5102341 | 20240914012103_KwMxw | NL000T | 2024-09-17T12:07:03.051Z | 2024-09-19T12:19:53.847Z |
5101472 | 5101472 | 20240914002801_BXvV2 | NL000T | 2024-09-17T12:05:54.006Z | 2024-09-19T12:19:50.651Z |
5099574 | 5099574 | 20240913213713_bkiaG | NL000T | 2024-09-17T12:03:10.716Z | 2024-09-19T12:19:45.328Z |
5099542 | 5099542 | 20240913213404_OkwZJ | NL000T | 2024-09-17T12:03:08.911Z | 2024-09-19T12:19:45.287Z |
5097977 | 5097977 | 20240913011111_UNr7C | NL000T | 2024-09-16T12:17:17.733Z | 2024-09-19T12:20:39.240Z |
5097796 | 5097796 | 20240913010444_xlrsA | NL000T | 2024-09-16T12:17:15.039Z | 2024-09-19T12:20:38.988Z |
5097589 | 5097589 | 20240913005605_HAWGY | NL000T | 2024-09-16T12:17:13.553Z | 2024-09-19T12:20:38.740Z |
5097355 | 5097355 | 20240913004232_gjm1T | NL000T | 2024-09-16T12:17:11.551Z | 2024-09-19T12:20:38.397Z |
5097148 | 5097148 | 20240913003331_lNykn | NL000T | 2024-09-16T12:17:05.922Z | 2024-09-19T12:20:37.560Z |
5093793 | 5093793 | 20240912033547_krhUy | NL000T | 2024-09-16T12:14:25.460Z | 2024-09-19T12:21:15.654Z |
5092160 | 5092160 | 20240912023912_1zI9W | NL000T | 2024-09-16T12:13:42.745Z | 2024-09-19T12:21:13.678Z |
5091985 | 5091985 | 20240912023324_fbBip | NL000T | 2024-09-16T12:13:36.346Z | 2024-09-19T12:21:13.551Z |
5091843 | 5091843 | 20240912022522_wUHaJ | NL000T | 2024-09-16T12:13:27.477Z | 2024-09-19T12:21:13.423Z |
5090540 | 5090540 | 20240912012909_p53oY | NL000T | 2024-09-16T12:12:22.805Z | 2024-09-19T12:21:11.369Z |
5090384 | 5090384 | 20240912012326_n2acS | NL000T | 2024-09-16T12:12:17.644Z | 2024-09-19T12:21:11.272Z |
5090324 | 5090324 | 20240912012035_IQLMK | NL000T | 2024-09-16T12:12:12.956Z | 2024-09-19T12:21:11.208Z |
5090045 | 5090045 | 20240912010819_EqUqv | NL000T | 2024-09-16T12:11:57.312Z | 2024-09-19T12:21:10.940Z |
5089126 | 5089126 | 20240912002653_DJGta | NL000T | 2024-09-16T12:11:15.592Z | 2024-09-19T12:21:09.758Z |
5088836 | 5088836 | 20240913002836_9CWVd | NL000T | 2024-09-16T12:08:32.451Z | 2024-09-19T12:20:37.331Z |
5088716 | 5088716 | 20240913002210_EHj21 | NL000T | 2024-09-16T12:08:22.437Z | 2024-09-19T12:20:37.198Z |
5087981 | 5087981 | 20240912235121_6DDVM | NL000T | 2024-09-16T12:07:39.474Z | 2024-09-19T12:20:36.006Z |
5087978 | 5087978 | 20240912235105_PfMBF | NL000T | 2024-09-16T12:07:39.184Z | 2024-09-19T12:20:36.000Z |
5087644 | 5087644 | 20240912233757_UoT6E | NL000T | 2024-09-16T12:07:09.178Z | 2024-09-19T12:20:35.519Z |
5087455 | 5087455 | 20240912232803_6JhwN | NL000T | 2024-09-16T12:06:56.668Z | 2024-09-19T12:20:35.033Z |
5087235 | 5087235 | 20240912231658_ufw5Q | NL000T | 2024-09-16T12:06:48.139Z | 2024-09-19T12:20:34.353Z |
5086235 | 5086235 | 20240912222050_TbcVP | NL000T | 2024-09-16T12:05:23.532Z | 2024-09-19T12:20:30.653Z |
5085620 | 5085620 | 20240912213517_k2ycI | NL000T | 2024-09-16T12:04:30.639Z | 2024-09-19T12:20:29.264Z |
5085561 | 5085561 | 20240912212927_4TGjB | NL000T | 2024-09-16T12:04:24.194Z | 2024-09-19T12:20:29.060Z |
5085440 | 5085440 | 20240912212101_TwORg | NL000T | 2024-09-16T12:04:15.778Z | 2024-09-19T12:20:28.624Z |
5085275 | 5085275 | 20240912210604_osBJX | NL000T | 2024-09-16T12:03:50.055Z | 2024-09-19T12:20:28.315Z |
5085106 | 5085106 | 20240912204549_aqNR9 | NL000T | 2024-09-16T12:03:32.393Z | 2024-09-19T12:20:28.039Z |
5084866 | 5084866 | 20240912202606_9VGCP | NL000T | 2024-09-16T12:03:06.097Z | 2024-09-19T12:20:27.389Z |
5080409 | 5080409 | 20240911035604_3H8Xu | NL000T | 2024-09-15T12:17:02.569Z | 2024-09-19T12:21:43.232Z |
5080008 | 5080008 | 20240911032615_UYxbK | NL000T | 2024-09-15T12:16:44.736Z | 2024-09-19T12:21:42.987Z |
5079150 | 5079150 | 20240911023457_8K3vL | NL000T | 2024-09-15T12:16:08.528Z | 2024-09-19T12:21:41.170Z |
5078887 | 5078887 | 20240911021904_LLSPO | NL000T | 2024-09-15T12:15:54.737Z | 2024-09-19T12:21:40.788Z |
5075742 | 5075742 | 20240912000447_QXWbU | NL000T | 2024-09-15T12:10:10.816Z | 2024-09-19T12:21:09.460Z |
5064281 | 5064281 | 20240910003757_IBuSh | NL000T | 2024-09-14T12:15:12.314Z | 2024-09-18T12:15:16.055Z |
5064141 | 5064141 | 20240910001053_I6svn | NL000T | 2024-09-14T12:14:59.456Z | 2024-09-18T12:15:15.622Z |
5063776 | 5063776 | 20240909223939_XoOQS | NL000T | 2024-09-14T12:14:21.512Z | 2024-09-18T12:15:14.731Z |
5063305 | 5063305 | 20240909204119_NCM8m | NL000T | 2024-09-14T12:13:53.026Z | 2024-09-18T12:15:13.610Z |
5063258 | 5063258 | 20240909202739_PTGTY | NL000T | 2024-09-14T12:13:45.490Z | 2024-09-18T12:15:13.463Z |
5052555 | 5052555 | 20240907210304_gDhhX | NL000T | 2024-09-13T12:15:13.818Z | 2024-09-16T12:21:06.237Z |
5047330 | 5047330 | 20240909033055_AnY9B | NL000T | 2024-09-13T12:08:48.375Z | 2024-09-17T12:19:02.057Z |
5047227 | 5047227 | 20240909030826_JTAID | NL000T | 2024-09-13T12:08:41.200Z | 2024-09-17T12:19:01.730Z |
5046991 | 5046991 | 20240909020944_FUg3j | NL000T | 2024-09-13T12:08:04.955Z | 2024-09-17T12:19:00.691Z |
5046949 | 5046949 | 20240909015714_Jxdsk | NL000T | 2024-09-13T12:08:00.194Z | 2024-09-17T12:19:00.646Z |
5046934 | 5046934 | 20240909015146_XfoQ3 | NL000T | 2024-09-13T12:07:58.525Z | 2024-09-17T12:19:00.618Z |
5046688 | 5046688 | 20240909004704_IuNSZ | NL000T | 2024-09-13T12:07:18.273Z | 2024-09-17T12:18:59.700Z |
5046674 | 5046674 | 20240909004522_sLcXY | NL000T | 2024-09-13T12:07:16.354Z | 2024-09-17T12:18:59.671Z |
5046661 | 5046661 | 20240909004016_rr63d | NL000T | 2024-09-13T12:07:15.044Z | 2024-09-17T12:18:59.652Z |
5046570 | 5046570 | 20240909001458_89pen | NL000T | 2024-09-13T12:06:57.585Z | 2024-09-17T12:18:59.554Z |
5046550 | 5046550 | 20240909000856_6WWdD | NL000T | 2024-09-13T12:06:55.415Z | 2024-09-17T12:18:59.493Z |
5046454 | 5046454 | 20240908233910_9U67V | NL000T | 2024-09-13T12:06:43.875Z | 2024-09-17T12:18:59.370Z |
5046366 | 5046366 | 20240908230503_EnkvN | NL000T | 2024-09-13T12:06:34.000Z | 2024-09-17T12:18:59.289Z |
5046140 | 5046140 | 20240908213147_jcl2z | NL000T | 2024-09-13T12:06:00.935Z | 2024-09-17T12:18:58.657Z |
5046073 | 5046073 | 20240908210606_XAv4c | NL000T | 2024-09-13T12:05:47.321Z | 2024-09-17T12:18:58.504Z |
5040284 | 5040284 | 20240906033014_yBwig | NL000T | 2024-09-12T12:16:05.268Z | 2024-09-14T12:23:08.532Z |
5039809 | 5039809 | 20240906020443_M2tAv | NL000T | 2024-09-12T12:15:45.776Z | 2024-09-14T12:23:04.920Z |
5039745 | 5039745 | 20240906015812_e0Gq2 | NL000T | 2024-09-12T12:15:43.942Z | 2024-09-14T12:23:04.537Z |
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);