names

53 rows where case_id = 2268285

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
4709326 2268285 2268285 plaintiff Pelham John knight   Pelham, John, knight 0
4709327 2268285 2268285 plaintiff Halle John, sen     Halle, John, sen 1
4709328 2268285 2268285 plaintiff Halle John jun   Halle, John, jun 2
4709329 2268285 2268285 plaintiff Oxenbregge Robert     Oxenbregge, Robert 3
4709330 2268285 2268285 plaintiff St Just Stephen     St Just, Stephen 4
4709331 2268285 2268285 plaintiff Assheburnham Thomas   603888 603888 Assheburnham, Thomas, of Sevenoaks 5
4709332 2268285 2268285 defendant Romchede John     Romchede, John 0
4709333 2268285 2268285 defendant Gyles William     Gyles, William 1
4709334 2268285 2268285 defendant Gyles Richard     Gyles, Richard 2
4709335 2268285 2268285 defendant Banbourgh John     Banbourgh, John 3
4709336 2268285 2268285 defendant Bore John     Bore, John 4
4709337 2268285 2268285 defendant Wybarn John     Wybarn, John 5
4709338 2268285 2268285 defendant Smyth Robert     Smyth, Robert 6
4709339 2268285 2268285 defendant Chaundeler John     Chaundeler, John 7
4709340 2268285 2268285 defendant Dryver John     Dryver, John 8
4709341 2268285 2268285 defendant Frende Agnes     Frende, Agnes 9
4709342 2268285 2268285 defendant Champion John     Champion, John 10
4709343 2268285 2268285 defendant Bele John, sen     Bele, John, sen 11
4709344 2268285 2268285 defendant Bele John jun   Bele, John, jun 12
4709345 2268285 2268285 defendant Rayner John     Rayner, John 13
4709346 2268285 2268285 defendant Tothirst John     Tothirst, John 14
4709347 2268285 2268285 defendant Fyssher Baldewin arrow maker   Fyssher, Baldewin, arrow maker 15
4709348 2268285 2268285 defendant Aleyn Richard     Aleyn, Richard 16
4709349 2268285 2268285 defendant Clerk John     Clerk, John 17
4709350 2268285 2268285 defendant Skele John     Skele, John 18
4709351 2268285 2268285 defendant Cristemesse Richard     Cristemesse, Richard 19
4709352 2268285 2268285 defendant Hoode John     Hoode, John 20
4709353 2268285 2268285 defendant Nutte John     Nutte, John 21
4709354 2268285 2268285 defendant Wilkyn John     Wilkyn, John 22
4709355 2268285 2268285 defendant Hay William     Hay, William 23
4709356 2268285 2268285 defendant Studolf David     Studolf, David 24
4709357 2268285 2268285 defendant Frenche Robert     Frenche, Robert 25
4709358 2268285 2268285 defendant Meller Isabel     Meller, Isabel 26
4709359 2268285 2268285 defendant Crowhirst Robert     Crowhirst, Robert 27
4709360 2268285 2268285 defendant atte Teghe Stephen     atte Teghe, Stephen 28
4709361 2268285 2268285 defendant Pantere Thomas     Pantere, Thomas 29
4709362 2268285 2268285 defendant Romchete John     Romchete, John 30
4709363 2268285 2268285 defendant Couper Richard     Couper, Richard 31
4709364 2268285 2268285 defendant Elsy Roger     Elsy, Roger 32
4709365 2268285 2268285 defendant Nesell John     Nesell, John 33
4709366 2268285 2268285 defendant Sagheer John     Sagheer, John 34
4709367 2268285 2268285 defendant Wykehirst Thomas     Wykehirst, Thomas 35
4709368 2268285 2268285 defendant Michell William     Michell, William 36
4709369 2268285 2268285 defendant Brewer Thomas     Brewer, Thomas 37
4709370 2268285 2268285 defendant Pyndefoghel John     Pyndefoghel, John 38
4709371 2268285 2268285 defendant Baker Alice     Baker, Alice 39
4709372 2268285 2268285 defendant Thomas Philip chandler   Thomas, Philip, chandler 40
4709373 2268285 2268285 defendant Mellere Thomas     Mellere, Thomas 41
4709374 2268285 2268285 defendant Bocher Walter     Bocher, Walter 42
4709375 2268285 2268285 defendant Thomas Gower Gillian     Thomas Gower, Gillian 43
4709376 2268285 2268285 defendant Smyth Richard & Denise     Smyth, Richard & Denise 44
4709377 2268285 2268285 defendant Alfew John     Alfew, John 45
4709378 2268285 2268285 defendant Alfew William     Alfew, William 46

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);