participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,709 rows where station_code = "NZ0010" 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 |
---|---|---|---|---|---|
5258572 | 5258572 | 20241007101804_2FwJG | NZ0010 | 2024-10-09T12:09:09.596Z | 2024-10-16T12:21:05.578Z |
5243384 | 5243384 | 20241005165845_a6nGM | NZ0010 | 2024-10-07T12:13:29.047Z | 2024-10-14T12:24:30.966Z |
5243344 | 5243344 | 20241005164701_ywGfv | NZ0010 | 2024-10-07T12:13:27.095Z | 2024-10-14T12:24:30.865Z |
5243332 | 5243332 | 20241005164516_TpnX7 | NZ0010 | 2024-10-07T12:13:26.601Z | 2024-10-14T12:24:30.838Z |
5243297 | 5243297 | 20241005164129_NHS6r | NZ0010 | 2024-10-07T12:13:25.204Z | 2024-10-14T12:24:30.784Z |
5243171 | 5243171 | 20241005161643_rUgxu | NZ0010 | 2024-10-07T12:13:19.234Z | 2024-10-14T12:24:30.498Z |
5243111 | 5243111 | 20241005160908_zec9y | NZ0010 | 2024-10-07T12:13:16.649Z | 2024-10-14T12:24:30.353Z |
5243103 | 5243103 | 20241005160813_8Dret | NZ0010 | 2024-10-07T12:13:16.250Z | 2024-10-14T12:24:30.327Z |
5243063 | 5243063 | 20241005160318_3Z010 | NZ0010 | 2024-10-07T12:13:14.684Z | 2024-10-14T12:24:30.301Z |
5242987 | 5242987 | 20241005155208_LbDTH | NZ0010 | 2024-10-07T12:13:10.876Z | 2024-10-14T12:24:30.151Z |
5242964 | 5242964 | 20241005154925_yaRIv | NZ0010 | 2024-10-07T12:13:09.521Z | 2024-10-14T12:24:30.104Z |
5242879 | 5242879 | 20241005153412_NDnRL | NZ0010 | 2024-10-07T12:12:58.318Z | 2024-10-14T12:24:29.952Z |
5242817 | 5242817 | 20241005152013_fTqz3 | NZ0010 | 2024-10-07T12:12:48.945Z | 2024-10-14T12:24:29.827Z |
5242617 | 5242617 | 20241005143827_MaUhe | NZ0010 | 2024-10-07T12:12:26.736Z | 2024-10-14T12:24:29.347Z |
5242396 | 5242396 | 20241005140120_45mxK | NZ0010 | 2024-10-07T12:12:07.623Z | 2024-10-14T12:24:28.906Z |
5242379 | 5242379 | 20241005135727_0UKEe | NZ0010 | 2024-10-07T12:12:06.141Z | 2024-10-14T12:24:28.890Z |
5242374 | 5242374 | 20241005135727_2iJKU | NZ0010 | 2024-10-07T12:12:06.066Z | 2024-10-14T12:24:28.889Z |
5242246 | 5242246 | 20241005133738_t1lsz | NZ0010 | 2024-10-07T12:11:56.928Z | 2024-10-14T12:24:28.730Z |
5242194 | 5242194 | 20241005131525_Nd2dN | NZ0010 | 2024-10-07T12:11:53.200Z | 2024-10-14T12:24:28.590Z |
5242050 | 5242050 | 20241005123349_0H5yj | NZ0010 | 2024-10-07T12:11:43.309Z | 2024-10-14T12:24:28.378Z |
5241519 | 5241519 | 20241005105927_ToVSD | NZ0010 | 2024-10-07T12:10:42.792Z | 2024-10-14T12:24:26.787Z |
5198167 | 5198167 | 20240929171720_3Z2OB | NZ0010 | 2024-10-01T12:14:26.082Z | 2024-10-07T12:21:30.822Z |
5198102 | 5198102 | 20240929170004_MQ3tH | NZ0010 | 2024-10-01T12:14:18.642Z | 2024-10-07T12:21:30.543Z |
5197752 | 5197752 | 20240929155903_4N0Fc | NZ0010 | 2024-10-01T12:13:48.062Z | 2024-10-07T12:21:29.773Z |
5194232 | 5194232 | 20240929154108_CIp52 | NZ0010 | 2024-09-30T12:19:35.459Z | 2024-10-07T12:21:29.469Z |
5194198 | 5194198 | 20240929153247_vocn0 | NZ0010 | 2024-09-30T12:19:35.233Z | 2024-10-07T12:21:29.374Z |
5194168 | 5194168 | 20240929152314_PzYbo | NZ0010 | 2024-09-30T12:19:34.939Z | 2024-10-07T12:21:29.318Z |
5194142 | 5194142 | 20240929151528_DUlMz | NZ0010 | 2024-09-30T12:19:34.453Z | 2024-10-07T12:21:29.158Z |
5194067 | 5194067 | 20240929145516_EfDIf | NZ0010 | 2024-09-30T12:19:33.228Z | 2024-10-07T12:21:28.740Z |
5193751 | 5193751 | 20240929133219_TWDqP | NZ0010 | 2024-09-30T12:19:25.514Z | 2024-10-07T12:21:27.187Z |
5193554 | 5193554 | 20240929123040_pDZGv | NZ0010 | 2024-09-30T12:19:20.759Z | 2024-10-07T12:21:26.347Z |
5193327 | 5193327 | 20240929114015_h0S94 | NZ0010 | 2024-09-30T12:19:13.906Z | 2024-10-07T12:21:25.183Z |
5193198 | 5193198 | 20240929110839_xqNWG | NZ0010 | 2024-09-30T12:19:10.495Z | 2024-10-07T12:21:24.833Z |
5193179 | 5193179 | 20240929110231_C8dOX | NZ0010 | 2024-09-30T12:19:09.818Z | 2024-10-07T12:21:24.805Z |
5190313 | 5190313 | 20240928163943_CobdO | NZ0010 | 2024-09-30T12:16:42.312Z | 2024-10-06T12:28:19.276Z |
5190200 | 5190200 | 20240928161514_Q2BlD | NZ0010 | 2024-09-30T12:16:36.477Z | 2024-10-06T12:28:19.092Z |
5190045 | 5190045 | 20240928155455_2av2A | NZ0010 | 2024-09-30T12:16:26.730Z | 2024-10-06T12:28:18.811Z |
5188185 | 5188185 | 20240928101534_X5KkA | NZ0010 | 2024-09-30T12:13:45.954Z | 2024-10-06T12:28:14.445Z |
5188171 | 5188171 | 20240928101233_KwpBj | NZ0010 | 2024-09-30T12:13:44.647Z | 2024-10-06T12:28:14.404Z |
5187426 | 5187426 | 20240929094035_Km35i | NZ0010 | 2024-09-30T12:09:21.912Z | 2024-10-07T12:21:24.230Z |
5175534 | 5175534 | 20240923165330_GOKff | NZ0010 | 2024-09-28T12:21:33.209Z | 2024-10-01T12:22:19.871Z |
5175532 | 5175532 | 20240923163014_5p58R | NZ0010 | 2024-09-28T12:21:32.517Z | 2024-10-01T12:22:19.662Z |
5175512 | 5175512 | 20240924100203_25o23 | NZ0010 | 2024-09-28T12:19:58.210Z | 2024-10-02T12:18:55.016Z |
5175510 | 5175510 | 20240924095729_CJMpJ | NZ0010 | 2024-09-28T12:19:57.529Z | 2024-10-02T12:18:54.895Z |
5174332 | 5174332 | 20240927170344_His2Y | NZ0010 | 2024-09-28T12:13:46.561Z | 2024-10-05T12:28:57.805Z |
5174150 | 5174150 | 20240927163058_NHQrz | NZ0010 | 2024-09-28T12:13:24.525Z | 2024-10-05T12:28:57.371Z |
5173921 | 5173921 | 20240927160553_T9veK | NZ0010 | 2024-09-28T12:13:07.835Z | 2024-10-05T12:28:56.407Z |
5173888 | 5173888 | 20240927155903_hJUcd | NZ0010 | 2024-09-28T12:13:06.231Z | 2024-10-05T12:28:56.342Z |
5173787 | 5173787 | 20240927154712_YgEgA | NZ0010 | 2024-09-28T12:12:57.998Z | 2024-10-05T12:28:56.042Z |
5173697 | 5173697 | 20240927153510_4TA4f | NZ0010 | 2024-09-28T12:12:50.438Z | 2024-10-05T12:28:55.910Z |
5173625 | 5173625 | 20240927152039_S9ExU | NZ0010 | 2024-09-28T12:12:43.246Z | 2024-10-05T12:28:55.775Z |
5173256 | 5173256 | 20240927143113_7nL96 | NZ0010 | 2024-09-28T12:12:05.136Z | 2024-10-05T12:28:55.069Z |
5172948 | 5172948 | 20240927140151_gE143 | NZ0010 | 2024-09-28T12:11:36.247Z | 2024-10-05T12:28:54.431Z |
5172711 | 5172711 | 20240927132654_NZ3G2 | NZ0010 | 2024-09-28T12:11:17.886Z | 2024-10-05T12:28:53.408Z |
5171430 | 5171430 | 20240927100702_mJ76C | NZ0010 | 2024-09-28T12:08:31.811Z | 2024-10-05T12:28:45.925Z |
5167987 | 5167987 | 20240926170838_Rdunh | NZ0010 | 2024-09-27T12:06:22.138Z | 2024-10-04T12:25:31.601Z |
5167807 | 5167807 | 20240926153106_NUVUY | NZ0010 | 2024-09-27T12:05:47.446Z | 2024-10-04T12:25:30.271Z |
5167796 | 5167796 | 20240926152824_6KWdi | NZ0010 | 2024-09-27T12:05:46.519Z | 2024-10-04T12:25:30.125Z |
5167745 | 5167745 | 20240926150003_v9ics | NZ0010 | 2024-09-27T12:05:40.427Z | 2024-10-04T12:25:29.629Z |
5167695 | 5167695 | 20240926143035_vzv3m | NZ0010 | 2024-09-27T12:05:33.277Z | 2024-10-04T12:25:29.096Z |
5164424 | 5164424 | 20240924171152_bQ22v | NZ0010 | 2024-09-26T12:12:37.686Z | 2024-10-02T12:19:01.859Z |
5164090 | 5164090 | 20240924162633_6EfCx | NZ0010 | 2024-09-26T12:12:21.490Z | 2024-10-02T12:19:01.069Z |
5163999 | 5163999 | 20240924161228_rMG1K | NZ0010 | 2024-09-26T12:12:17.126Z | 2024-10-02T12:19:00.995Z |
5163762 | 5163762 | 20240924153655_T4gCE | NZ0010 | 2024-09-26T12:12:04.938Z | 2024-10-02T12:19:00.608Z |
5163663 | 5163663 | 20240924152125_PlnTG | NZ0010 | 2024-09-26T12:11:59.577Z | 2024-10-02T12:19:00.387Z |
5163603 | 5163603 | 20240924151035_hv06L | NZ0010 | 2024-09-26T12:11:56.601Z | 2024-10-02T12:19:00.276Z |
5163397 | 5163397 | 20240924143508_AC3jc | NZ0010 | 2024-09-26T12:11:44.666Z | 2024-10-02T12:19:00.063Z |
5163322 | 5163322 | 20240924141501_GlIg8 | NZ0010 | 2024-09-26T12:11:40.021Z | 2024-10-02T12:18:59.989Z |
5163131 | 5163131 | 20240924133706_bLZDT | NZ0010 | 2024-09-26T12:11:27.036Z | 2024-10-02T12:18:59.326Z |
5162372 | 5162372 | 20240924113445_GcnLQ | NZ0010 | 2024-09-26T12:10:44.445Z | 2024-10-02T12:18:57.003Z |
5162055 | 5162055 | 20240924104309_xGaPw | NZ0010 | 2024-09-26T12:10:23.412Z | 2024-10-02T12:18:56.188Z |
5162017 | 5162017 | 20240924103822_XwP22 | NZ0010 | 2024-09-26T12:10:20.610Z | 2024-10-02T12:18:56.110Z |
5157597 | 5157597 | 20240924100300_s5OFW | NZ0010 | 2024-09-25T12:10:54.912Z | 2024-10-02T12:18:55.022Z |
5157593 | 5157593 | 20240924100203_ZcXQm | NZ0010 | 2024-09-25T12:10:54.679Z | 2024-09-27T12:12:42.102Z |
5157504 | 5157504 | 20240924094736_vYhuj | NZ0010 | 2024-09-25T12:10:46.796Z | 2024-10-02T12:18:54.710Z |
5157375 | 5157375 | 20240924092118_TgHTH | NZ0010 | 2024-09-25T12:10:28.437Z | 2024-10-02T12:18:54.318Z |
5153823 | 5153823 | 20240923135927_iQySf | NZ0010 | 2024-09-24T12:07:03.268Z | 2024-10-01T12:22:18.868Z |
5148453 | 5148453 | 20240922105933_3dYFT | NZ0010 | 2024-09-23T12:07:02.162Z | 2024-09-30T12:22:46.354Z |
5148131 | 5148131 | 20240922095833_XXiV5 | NZ0010 | 2024-09-23T12:06:19.104Z | 2024-09-30T12:22:45.640Z |
5147666 | 5147666 | 20240922082207_OdOLa | NZ0010 | 2024-09-23T12:05:37.896Z | 2024-09-30T12:22:44.232Z |
5140763 | 5140763 | 20240920120829_3qPFZ | NZ0010 | 2024-09-21T12:04:32.991Z | 2024-09-28T12:23:23.068Z |
5140636 | 5140636 | 20240920112153_rlB5A | NZ0010 | 2024-09-21T12:04:26.172Z | 2024-09-28T12:23:22.360Z |
5140382 | 5140382 | 20240920100445_tdT2s | NZ0010 | 2024-09-21T12:03:53.380Z | 2024-09-28T12:23:20.747Z |
5140262 | 5140262 | 20240920092923_xZpBx | NZ0010 | 2024-09-21T12:03:40.792Z | 2024-09-28T12:23:19.903Z |
5138292 | 5138292 | 20240919172324_g5PJ2 | NZ0010 | 2024-09-20T12:06:44.179Z | 2024-09-27T12:19:58.617Z |
5138285 | 5138285 | 20240919171526_ZziEa | NZ0010 | 2024-09-20T12:06:43.729Z | 2024-09-27T12:19:58.590Z |
5138191 | 5138191 | 20240919163432_idxdO | NZ0010 | 2024-09-20T12:06:23.791Z | 2024-09-27T12:19:58.096Z |
5138169 | 5138169 | 20240919162315_gMcFK | NZ0010 | 2024-09-20T12:06:21.659Z | 2024-09-27T12:19:58.048Z |
5137251 | 5137251 | 20240919091001_CuRDN | NZ0010 | 2024-09-20T12:04:20.460Z | 2024-09-27T12:19:54.133Z |
5137238 | 5137238 | 20240919090725_jDIsG | NZ0010 | 2024-09-20T12:04:18.944Z | 2024-09-27T12:19:54.130Z |
5137166 | 5137166 | 20240919083839_i2h8a | NZ0010 | 2024-09-20T12:03:59.077Z | 2024-09-27T12:19:53.850Z |
5136985 | 5136985 | 20240919072713_9A41o | NZ0010 | 2024-09-20T12:03:41.240Z | 2024-09-27T12:19:53.218Z |
5135561 | 5135561 | 20240915160214_BIOtR | NZ0010 | 2024-09-19T12:19:33.237Z | 2024-09-23T12:16:40.594Z |
5135549 | 5135549 | 20240915155247_yzLk2 | NZ0010 | 2024-09-19T12:19:33.089Z | 2024-09-23T12:16:40.587Z |
5130965 | 5130965 | 20240917170859_LsgE3 | NZ0010 | 2024-09-19T12:14:01.812Z | 2024-09-25T12:22:52.257Z |
5130801 | 5130801 | 20240917152642_iB5Hi | NZ0010 | 2024-09-19T12:13:50.790Z | 2024-09-25T12:22:49.815Z |
5130732 | 5130732 | 20240917145742_xWSoI | NZ0010 | 2024-09-19T12:13:46.966Z | 2024-09-25T12:22:47.892Z |
5130700 | 5130700 | 20240917144601_zvnBU | NZ0010 | 2024-09-19T12:13:45.804Z | 2024-09-25T12:22:47.625Z |
5124187 | 5124187 | 20240914155851_udFtx | NZ0010 | 2024-09-18T12:12:10.626Z | 2024-09-22T12:18:14.007Z |
5124004 | 5124004 | 20240914132850_mrtzk | NZ0010 | 2024-09-18T12:12:03.012Z | 2024-09-22T12:18:12.667Z |
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);