participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,243 rows where station_code = "NL000L" 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 |
---|---|---|---|---|---|
4538413 | 4538413 | 20240703003829_5mWdd | NL000L | 2024-07-04T12:02:15.110Z | 2024-07-11T12:14:35.504Z |
4538328 | 4538328 | 20240702235334_sCDHv | NL000L | 2024-07-04T12:02:06.211Z | 2024-07-11T12:14:34.765Z |
4534075 | 4534075 | 20240624225505_V276S | NL000L | 2024-07-02T12:10:01.086Z | 2024-07-03T12:13:10.995Z |
4534073 | 4534073 | 20240626005128_fc2Os | NL000L | 2024-07-02T12:09:52.065Z | 2024-07-04T12:08:54.223Z |
4534071 | 4534071 | 20240626002930_LHwo1 | NL000L | 2024-07-02T12:09:51.886Z | 2024-07-04T12:08:53.656Z |
4534069 | 4534069 | 20240626001332_xiLTl | NL000L | 2024-07-02T12:09:51.639Z | 2024-07-04T12:08:53.297Z |
4534067 | 4534067 | 20240625224903_wUqKH | NL000L | 2024-07-02T12:09:49.696Z | 2024-07-04T12:08:49.088Z |
4534014 | 4534014 | 20240629002437_IlmtO | NL000L | 2024-07-02T12:07:57.378Z | 2024-07-07T12:13:48.649Z |
4534012 | 4534012 | 20240628231705_SY3fZ | NL000L | 2024-07-02T12:07:38.694Z | 2024-07-07T12:13:47.290Z |
4531802 | 4531802 | 20240701005458_vdEFR | NL000L | 2024-07-02T12:03:28.193Z | 2024-07-09T12:08:05.247Z |
4531792 | 4531792 | 20240701005338_IrqZS | NL000L | 2024-07-02T12:03:27.736Z | 2024-07-09T12:08:05.243Z |
4531417 | 4531417 | 20240630232547_um9n9 | NL000L | 2024-07-02T12:02:50.721Z | 2024-07-09T12:08:02.015Z |
4488790 | 4488790 | 20240620002049_Xz2XQ | NL000L | 2024-06-21T12:05:24.107Z | 2024-06-28T12:09:38.815Z |
4488699 | 4488699 | 20240620000947_9oiSC | NL000L | 2024-06-21T12:05:19.387Z | 2024-06-28T12:09:38.240Z |
4479143 | 4479143 | 20240618001921_rtWga | NL000L | 2024-06-19T12:07:40.393Z | 2024-06-26T12:14:51.173Z |
4433055 | 4433055 | 20240607223352_XJuRr | NL000L | 2024-06-09T12:01:45.162Z | 2024-06-16T12:13:59.536Z |
4432869 | 4432869 | 20240607215625_NWiUj | NL000L | 2024-06-09T12:01:37.738Z | 2024-06-16T12:13:58.156Z |
4420913 | 4420913 | 20240605214813_2t7rD | NL000L | 2024-06-07T12:05:15.609Z | 2024-06-14T12:08:18.446Z |
4405970 | 4405970 | 20240602215615_YkoBF | NL000L | 2024-06-04T12:05:51.770Z | 2024-06-11T12:13:33.061Z |
4382242 | 4382242 | 20240525215941_4aYmw | NL000L | 2024-05-28T12:09:31.860Z | 2024-06-03T12:16:58.424Z |
4157594 | 4157594 | 20240408021711_dWZ6X | NL000L | 2024-04-09T12:05:13.142Z | 2024-04-16T12:20:17.954Z |
4150199 | 4150199 | 20240406030142_bsVq0 | NL000L | 2024-04-07T12:03:40.286Z | 2024-04-14T12:20:45.905Z |
4136036 | 4136036 | 20240402025002_qlt83 | NL000L | 2024-04-03T12:06:18.835Z | 2024-04-10T12:17:58.857Z |
4135934 | 4135934 | 20240402020139_VwCll | NL000L | 2024-04-03T12:06:07.629Z | 2024-04-10T12:17:56.712Z |
4135719 | 4135719 | 20240402004605_KnjNh | NL000L | 2024-04-03T12:05:35.885Z | 2024-04-10T12:17:52.046Z |
4135674 | 4135674 | 20240402003219_pR3Mg | NL000L | 2024-04-03T12:05:31.708Z | 2024-04-10T12:17:50.920Z |
3958187 | 3958187 | 20240212233231_6HQ7O | NL000L | 2024-02-14T14:07:09.672Z | 2024-02-21T14:20:31.232Z |
3877382 | 3877382 | 20240119215056_fNPFi | NL000L | 2024-01-23T14:17:12.481Z | 2024-01-27T14:21:52.225Z |
3874010 | 3874010 | 20240120040947_Fhhc7 | NL000L | 2024-01-23T14:09:39.155Z | 2024-01-28T14:19:45.837Z |
3856644 | 3856644 | 20240118055018_UorRe | NL000L | 2024-01-21T14:09:35.627Z | 2024-01-26T14:21:26.439Z |
3856507 | 3856507 | 20240118054211_hJIrW | NL000L | 2024-01-21T14:09:07.300Z | 2024-01-26T14:21:24.533Z |
3856443 | 3856443 | 20240118053811_Ab9lX | NL000L | 2024-01-21T14:09:01.080Z | 2024-01-26T14:21:23.248Z |
3849406 | 3849406 | 20240117002302_Q7Wn3 | NL000L | 2024-01-20T14:06:19.672Z | 2024-01-21T14:19:18.362Z |
3846428 | 3846428 | 20240118004822_WOg1i | NL000L | 2024-01-20T14:01:35.664Z | 2024-01-26T14:20:33.741Z |
3845257 | 3845257 | 20240116210923_qDPbA | NL000L | 2024-01-19T14:13:46.109Z | 2024-01-25T14:22:28.699Z |
3831061 | 3831061 | 20240114231608_lb0nw | NL000L | 2024-01-17T14:14:23.015Z | 2024-01-23T14:25:25.966Z |
3807554 | 3807554 | 20240111021151_oAjdo | NL000L | 2024-01-14T14:17:14.317Z | 2024-01-19T14:28:15.288Z |
3807415 | 3807415 | 20240111015520_E3rFw | NL000L | 2024-01-14T14:17:02.931Z | 2024-01-19T14:28:14.456Z |
3807207 | 3807207 | 20240111013426_wJZ0Z | NL000L | 2024-01-14T14:16:47.629Z | 2024-01-19T14:28:13.285Z |
3807057 | 3807057 | 20240111011441_hruWV | NL000L | 2024-01-14T14:16:36.252Z | 2024-01-19T14:28:12.272Z |
3806608 | 3806608 | 20240111001322_taeOs | NL000L | 2024-01-14T14:16:03.608Z | 2024-01-19T14:28:09.425Z |
3802677 | 3802677 | 20240111051002_wtc95 | NL000L | 2024-01-14T14:04:18.660Z | 2024-01-20T14:22:43.473Z |
3802436 | 3802436 | 20240111044107_ltV5p | NL000L | 2024-01-14T14:03:32.582Z | 2024-01-20T14:22:41.903Z |
3802039 | 3802039 | 20240111035806_BzMHX | NL000L | 2024-01-14T14:02:37.562Z | 2024-01-20T14:22:40.192Z |
3801703 | 3801703 | 20240111032503_OtMRs | NL000L | 2024-01-14T14:01:41.411Z | 2024-01-20T14:22:38.959Z |
3801461 | 3801461 | 20240111025928_pWWFV | NL000L | 2024-01-14T14:00:58.195Z | 2024-01-20T14:22:37.103Z |
3800736 | 3800736 | 20240110231128_jlbZc | NL000L | 2024-01-13T14:16:57.368Z | 2024-01-19T14:28:06.766Z |
3800631 | 3800631 | 20240110225148_8t1j2 | NL000L | 2024-01-13T14:16:41.258Z | 2024-01-19T14:28:06.129Z |
3800135 | 3800135 | 20240110212413_iqfo0 | NL000L | 2024-01-13T14:16:07.204Z | 2024-01-19T14:28:03.220Z |
3800036 | 3800036 | 20240110210854_xkt19 | NL000L | 2024-01-13T14:16:03.770Z | 2024-01-19T14:28:02.820Z |
3799717 | 3799717 | 20240110200900_RHKU8 | NL000L | 2024-01-13T14:15:30.050Z | 2024-01-19T14:28:00.734Z |
3799626 | 3799626 | 20240110194536_36g3q | NL000L | 2024-01-13T14:15:22.670Z | 2024-01-19T14:27:59.722Z |
3798919 | 3798919 | 20240110172302_f1Q4N | NL000L | 2024-01-13T14:14:08.192Z | 2024-01-19T14:27:48.387Z |
3798911 | 3798911 | 20240110172036_ihPKa | NL000L | 2024-01-13T14:14:07.774Z | 2024-01-19T14:27:47.908Z |
3793272 | 3793272 | 20240110040341_fIulO | NL000L | 2024-01-13T14:03:08.280Z | 2024-01-19T14:26:41.789Z |
3792839 | 3792839 | 20240110033528_oxNkd | NL000L | 2024-01-13T14:02:01.693Z | 2024-01-19T14:26:33.483Z |
3792417 | 3792417 | 20240110030548_VkoAg | NL000L | 2024-01-13T14:01:09.712Z | 2024-01-19T14:26:29.003Z |
3792389 | 3792389 | 20240110030242_6NlC4 | NL000L | 2024-01-13T14:01:05.373Z | 2024-01-19T14:26:28.579Z |
3792155 | 3792155 | 20240110024840_kN7A0 | NL000L | 2024-01-13T14:00:34.817Z | 2024-01-19T14:26:24.372Z |
3791517 | 3791517 | 20240110012201_3MOVd | NL000L | 2024-01-12T14:16:41.900Z | 2024-01-18T14:26:06.470Z |
3790732 | 3790732 | 20240109233532_BOOsj | NL000L | 2024-01-12T14:12:28.337Z | 2024-01-18T14:26:00.466Z |
3790616 | 3790616 | 20240109231739_0ZvEs | NL000L | 2024-01-12T14:12:19.560Z | 2024-01-18T14:25:59.631Z |
3790251 | 3790251 | 20240109221905_X3mWl | NL000L | 2024-01-12T14:11:52.206Z | 2024-01-18T14:25:57.519Z |
3789993 | 3789993 | 20240109212824_cJgUV | NL000L | 2024-01-12T14:11:28.261Z | 2024-01-18T14:25:55.614Z |
3784862 | 3784862 | 20240109050729_40JAW | NL000L | 2024-01-11T14:14:38.724Z | 2024-01-18T14:25:14.243Z |
3784740 | 3784740 | 20240109030115_w92Oo | NL000L | 2024-01-11T14:14:19.414Z | 2024-01-17T14:23:48.207Z |
3784561 | 3784561 | 20240109023011_XS9Xl | NL000L | 2024-01-11T14:14:06.137Z | 2024-01-17T14:23:47.527Z |
3784372 | 3784372 | 20240109020147_KOSii | NL000L | 2024-01-11T14:13:44.438Z | 2024-01-17T14:23:45.209Z |
3784291 | 3784291 | 20240109015254_2XKbK | NL000L | 2024-01-11T14:13:34.659Z | 2024-01-17T14:23:44.349Z |
3783874 | 3783874 | 20240109001402_utbEv | NL000L | 2024-01-11T14:12:40.447Z | 2024-01-17T14:23:40.529Z |
3783839 | 3783839 | 20240109000602_dN5ar | NL000L | 2024-01-11T14:12:34.844Z | 2024-01-17T14:23:40.391Z |
3783434 | 3783434 | 20240108202941_2kQ00 | NL000L | 2024-01-11T14:11:32.333Z | 2024-01-17T14:23:36.355Z |
3780445 | 3780445 | 20240109044931_doD2r | NL000L | 2024-01-11T14:02:36.883Z | 2024-01-18T14:25:12.181Z |
3779227 | 3779227 | 20240108050418_Kh20A | NL000L | 2024-01-10T14:15:24.600Z | 2024-01-17T14:23:17.554Z |
3779196 | 3779196 | 20240108045839_E8PxD | NL000L | 2024-01-10T14:15:20.045Z | 2024-01-17T14:23:17.356Z |
3777946 | 3777946 | 20240108002534_eiBIq | NL000L | 2024-01-10T14:13:34.989Z | 2024-01-16T14:27:32.639Z |
3777519 | 3777519 | 20240107230200_2HmaG | NL000L | 2024-01-10T14:13:08.670Z | 2024-01-16T14:27:31.019Z |
3776796 | 3776796 | 20240107204907_qs4XA | NL000L | 2024-01-10T14:12:07.377Z | 2024-01-16T14:27:27.212Z |
3776661 | 3776661 | 20240107203320_x0rrP | NL000L | 2024-01-10T14:11:51.691Z | 2024-01-16T14:27:26.474Z |
3771321 | 3771321 | 20240108042618_Mul3J | NL000L | 2024-01-10T14:01:00.449Z | 2024-01-17T14:23:16.163Z |
3767676 | 3767676 | 20240106192347_03A02 | NL000L | 2024-01-09T14:10:19.378Z | 2024-01-15T14:24:19.185Z |
3704826 | 3704826 | 20231222003229_vBQ7Q | NL000L | 2024-01-06T00:05:52.030Z | 2024-01-06T00:05:52.030Z |
3578072 | 3578072 | 20231212023811_2Sq6I | NL000L | 2024-01-06T00:05:15.199Z | 2024-01-06T00:05:15.199Z |
3577810 | 3577810 | 20231212002359_FgbCX | NL000L | 2024-01-06T00:05:15.155Z | 2024-01-06T00:05:15.155Z |
3577756 | 3577756 | 20231212001138_3qLud | NL000L | 2024-01-06T00:05:15.148Z | 2024-01-06T00:05:15.148Z |
3379712 | 3379712 | 20231111235218_rH0WM | NL000L | 2024-01-06T00:04:16.258Z | 2024-01-06T00:04:16.258Z |
3379523 | 3379523 | 20231111232437_2gU3Z | NL000L | 2024-01-06T00:04:16.234Z | 2024-01-06T00:04:16.234Z |
3379414 | 3379414 | 20231111231019_gxwGK | NL000L | 2024-01-06T00:04:16.219Z | 2024-01-06T00:04:16.219Z |
3379201 | 3379201 | 20231111223901_3LGfo | NL000L | 2024-01-06T00:04:16.197Z | 2024-01-06T00:04:16.197Z |
3378726 | 3378726 | 20231111212258_cS2oY | NL000L | 2024-01-06T00:04:16.138Z | 2024-01-06T00:04:16.138Z |
3378390 | 3378390 | 20231111203004_fSs4Y | NL000L | 2024-01-06T00:04:16.099Z | 2024-01-06T00:04:16.099Z |
3368751 | 3368751 | 20231111020444_tSerH | NL000L | 2024-01-06T00:04:15.214Z | 2024-01-06T00:04:15.214Z |
3357627 | 3357627 | 20231110043437_8WoKr | NL000L | 2024-01-06T00:04:12.790Z | 2024-01-06T00:04:12.790Z |
3357012 | 3357012 | 20231110023747_pRYP2 | NL000L | 2024-01-06T00:04:12.713Z | 2024-01-06T00:04:12.713Z |
3317170 | 3317170 | 20231105201157_sOPrd | NL000L | 2024-01-06T00:03:53.793Z | 2024-01-06T00:03:53.793Z |
3306786 | 3306786 | 20231103214022_KI7qz | NL000L | 2024-01-06T00:03:45.868Z | 2024-01-06T00:03:45.868Z |
3306778 | 3306778 | 20231103214015_8cDQ2 | NL000L | 2024-01-06T00:03:45.866Z | 2024-01-06T00:03:45.866Z |
3306735 | 3306735 | 20231103213257_JguuU | NL000L | 2024-01-06T00:03:45.854Z | 2024-01-06T00:03:45.854Z |
3305988 | 3305988 | 20231103194405_JRW52 | NL000L | 2024-01-06T00:03:45.522Z | 2024-01-06T00:03:45.522Z |
3305986 | 3305986 | 20231103194216_lxGIE | NL000L | 2024-01-06T00:03:45.520Z | 2024-01-06T00:03:45.520Z |
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);