names

103 rows where place_id = 603225

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653892 1911482 1911482 plaintiff Nykke or Nix Richard   603225 603225 Nykke or Nix, Richard, of Norwich, Bishop 0
3662964 1914329 1914329 plaintiff Nikke or Nix Richard   603225 603225 Nikke or Nix, Richard, of Norwich, Bishop 0
3663099 1914370 1914370 plaintiff Nykke or Nix Richard   603225 603225 Nykke or Nix, Richard, of Norwich, Bishop 0
3663102 1914371 1914371 plaintiff Nykke or Nix Richard   603225 603225 Nykke or Nix, Richard, of Norwich, Bishop 0
4689586 2262301 2262301 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4689588 2262302 2262302 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4752315 2281139 2281139 defendant Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4752322 2281140 2281140 defendant Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753244 2281400 2281400 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753248 2281401 2281401 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753254 2281402 2281402 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753259 2281403 2281403 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753263 2281404 2281404 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753267 2281405 2281405 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753270 2281406 2281406 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753276 2281407 2281407 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753279 2281408 2281408 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753284 2281409 2281409 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753290 2281410 2281410 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753293 2281411 2281411 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753297 2281412 2281412 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753302 2281413 2281413 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753304 2281414 2281414 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753308 2281415 2281415 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753312 2281416 2281416 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753316 2281417 2281417 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4753323 2281418 2281418 plaintiff Wakeryng John   603225 603225 Wakeryng, John, of Norwich, bishop 0
4802366 2296933 2296933 plaintiff Alnwick William   603225 603225 Alnwick, William, of Norwich, bishop 0
4802370 2296934 2296934 plaintiff Alnwick William   603225 603225 Alnwick, William, of Norwich, bishop 0
4802375 2296935 2296935 plaintiff Alnwick William   603225 603225 Alnwick, William, of Norwich, bishop 0
4802377 2296936 2296936 plaintiff Alnwick William   603225 603225 Alnwick, William, of Norwich, bishop 0
4802379 2296937 2296937 plaintiff Alnwick William   603225 603225 Alnwick, William, of Norwich, bishop 0
4802381 2296938 2296938 plaintiff Alnwick William   603225 603225 Alnwick, William, of Norwich, bishop 0
4802405 2296944 2296944 plaintiff Alwyk or Alnwyk William   603225 603225 Alwyk or Alnwyk, William, of Norwich, bishop 0
4825850 2304120 2304120 plaintiff Wakeryng John (legal representative) 603225 603225 Wakeryng, John, of Norwich, bishop, executors of 0
4911602 2330130 2330130 plaintiff Brouns Thomas   603225 603225 Brouns, Thomas, of Norwich, bishop 0
4911655 2330148 2330148 plaintiff Brunce or Bruns Thomas   603225 603225 Brunce or Bruns, Thomas, of Norwich, bishop 0
4911662 2330149 2330149 plaintiff Brunce or Bruns Thomas   603225 603225 Brunce or Bruns, Thomas, of Norwich, bishop 0
4911665 2330150 2330150 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911669 2330151 2330151 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911674 2330152 2330152 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911676 2330153 2330153 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911677 2330153 2330153 defendant Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911678 2330154 2330154 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911680 2330155 2330155 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911684 2330156 2330156 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911687 2330157 2330157 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911692 2330158 2330158 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911694 2330159 2330159 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911698 2330160 2330160 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911700 2330161 2330161 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911702 2330162 2330162 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911706 2330163 2330163 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911711 2330164 2330164 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911715 2330165 2330165 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
4911719 2330166 2330166 plaintiff Brunce Thomas   603225 603225 Brunce, Thomas, of Norwich, bishop 0
5042448 2369350 2369350 defendant Bruns or Brunce Thomas (legal representative) 603225 603225 Bruns or Brunce, Thomas, of Norwich, bishop, executors of 0
5046057 2370449 2370449 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5046066 2370450 2370450 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, Bishop 0
5046069 2370451 2370451 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5126234 2394156 2394156 defendant Lyert Walter   603225 603225 Lyert, Walter, of Norwich, Bishop 0
5127030 2394381 2394381 plaintiff Brouns Thomas (legal representative) 603225 603225 Brouns, Thomas, of Norwich, bishop, executor of 0
5134949 2396724 2396724 plaintiff Lyert or Lyhert Walter   603225 603225 Lyert or Lyhert, Walter, of Norwich, Bishop 0
5134955 2396725 2396725 plaintiff Lyert Walter   603225 603225 Lyert, Walter, of Norwich, Bishop 0
5134985 2396732 2396732 plaintiff Lyhert or Hart Walter   603225 603225 Lyhert or Hart, Walter, of Norwich, Bishop 0
5134990 2396733 2396733 plaintiff Lyhert or Hart Walter   603225 603225 Lyhert or Hart, Walter, of Norwich, Bishop 0
5134995 2396734 2396734 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, Bishop 0
5134997 2396735 2396735 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5155086 2402638 2402638 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5155091 2402639 2402639 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5166160 2405832 2405832 plaintiff Brouns Thomas (legal representative) 603225 603225 Brouns, Thomas, of Norwich, bishop, executor of 0
5171838 2407481 2407481 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5171843 2407482 2407482 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5171849 2407483 2407483 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5171855 2407484 2407484 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5273091 2437204 2437204 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5273096 2437205 2437205 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5273102 2437206 2437206 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5273108 2437207 2437207 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5273114 2437208 2437208 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5273120 2437209 2437209 plaintiff Lyhert Walter   603225 603225 Lyhert, Walter, of Norwich, bishop 0
5305777 2446737 2446737 plaintiff Lyherd Walter (legal representative) 603225 603225 Lyherd, Walter, of Norwich, bishop, executors of 0
5305825 2446742 2446742 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305835 2446743 2446743 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305844 2446744 2446744 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305852 2446745 2446745 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305862 2446746 2446746 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305868 2446747 2446747 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305878 2446748 2446748 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305888 2446749 2446749 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5305898 2446750 2446750 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5365402 2464854 2464854 defendant Goldwell James   603225 603225 Goldwell, James, of Norwich, bishop 1
5370353 2466316 2466316 plaintiff Goldwell James   603225 603225 Goldwell, James, of Norwich, Bishop 0
5390120 2472236 2472236 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5402903 2475912 2475912 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, Bishop, executors of 0
5415867 2479679 2479679 plaintiff Lyhert Walter (legal representative) 603225 603225 Lyhert, Walter, of Norwich, bishop, executors of 0
5429164 2483652 2483652 plaintiff Goldwell James   603225 603225 Goldwell, James, of Norwich, bishop 0
5432401 2484662 2484662 plaintiff Lyhard Walter (legal representative) 603225 603225 Lyhard, Walter, of Norwich, bishop, executors of 0
5432407 2484663 2484663 plaintiff Lyhart Walter (legal representative) 603225 603225 Lyhart, Walter, of Norwich, bishop, executors of 0
5446284 2488783 2488783 plaintiff Goldwell James   603225 603225 Goldwell, James, of Norwich, bishop 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);