names

80 rows where case_id = 2023812

✎ 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
3997315 2023812 2023812 plaintiff Dutton Hugh gent, treasurer of Lyons Inn   Dutton, Hugh, gent, treasurer of Lyons Inn 0
3997316 2023812 2023812 defendant Chatterton William gent 663651 663651 Chatterton, William, of Lyons Inn, gent 0
3997317 2023812 2023812 defendant Chatterton Lawrence gent 663651 663651 Chatterton, Lawrence, of Lyons Inn, gent 1
3997318 2023812 2023812 defendant Draper Thomas gent 663651 663651 Draper, Thomas, of Lyons Inn, gent 2
3997319 2023812 2023812 defendant Draper Andrew     Draper, Andrew 3
3997320 2023812 2023812 defendant Beamont Henry     Beamont, Henry 4
3997321 2023812 2023812 defendant Geffreis Henry     Geffreis, Henry 5
3997322 2023812 2023812 defendant Richard John     Richard, John 6
3997323 2023812 2023812 defendant Strobridge John     Strobridge, John 7
3997324 2023812 2023812 defendant Whelor John     Whelor, John 8
3997325 2023812 2023812 defendant Freye Robert     Freye, Robert 9
3997326 2023812 2023812 defendant Trevillian John     Trevillian, John 10
3997327 2023812 2023812 defendant Forde John     Forde, John 11
3997328 2023812 2023812 defendant Gryne Richard     Gryne, Richard 12
3997329 2023812 2023812 defendant Fountayne William     Fountayne, William 13
3997330 2023812 2023812 defendant Hodges John     Hodges, John 14
3997331 2023812 2023812 defendant Gyles John     Gyles, John 15
3997332 2023812 2023812 defendant Greme Thomas     Greme, Thomas 16
3997333 2023812 2023812 defendant Wittington Francis     Wittington, Francis 17
3997334 2023812 2023812 defendant Patsall Humphrey     Patsall, Humphrey 18
3997335 2023812 2023812 defendant Polloxphen Nicholas     Polloxphen, Nicholas 19
3997336 2023812 2023812 defendant Collyns Thomas     Collyns, Thomas 20
3997337 2023812 2023812 defendant Stevenson John     Stevenson, John 21
3997338 2023812 2023812 defendant Lougher Robert     Lougher, Robert 22
3997339 2023812 2023812 defendant Banester William     Banester, William 23
3997340 2023812 2023812 defendant Byrigton Thomas     Byrigton, Thomas 24
3997341 2023812 2023812 defendant Hoddye John     Hoddye, John 25
3997342 2023812 2023812 defendant Ferne John     Ferne, John 26
3997343 2023812 2023812 defendant Reinold Thomas     Reinold, Thomas 27
3997344 2023812 2023812 defendant Creswall George     Creswall, George 28
3997345 2023812 2023812 defendant Langysford Robert     Langysford, Robert 29
3997346 2023812 2023812 defendant Jeffreis John     Jeffreis, John 30
3997347 2023812 2023812 defendant Trylo Lewis     Trylo, Lewis 31
3997348 2023812 2023812 defendant Hunte Thomas     Hunte, Thomas 32
3997349 2023812 2023812 defendant Penn Thomas     Penn, Thomas 33
3997350 2023812 2023812 defendant Huyd Thomas     Huyd, Thomas 34
3997351 2023812 2023812 defendant Boutcher Richard     Boutcher, Richard 35
3997352 2023812 2023812 defendant Cuffe Thomas     Cuffe, Thomas 36
3997353 2023812 2023812 defendant Robert John     Robert, John 37
3997354 2023812 2023812 defendant Wytchall Thomas     Wytchall, Thomas 38
3997355 2023812 2023812 defendant Bevyn Elias     Bevyn, Elias 39
3997356 2023812 2023812 defendant beager George     beager, George 40
3997357 2023812 2023812 defendant Grafton Edward     Grafton, Edward 41
3997358 2023812 2023812 defendant Fountayne John     Fountayne, John 42
3997359 2023812 2023812 defendant Servington Richard     Servington, Richard 43
3997360 2023812 2023812 defendant Ewine Hugh     Ewine, Hugh 44
3997361 2023812 2023812 defendant Starneholde John     Starneholde, John 45
3997362 2023812 2023812 defendant Turke Sebastian     Turke, Sebastian 46
3997363 2023812 2023812 defendant Mawrie Gregory     Mawrie, Gregory 47
3997364 2023812 2023812 defendant Yearworth Thomas     Yearworth, Thomas 48
3997365 2023812 2023812 defendant Worliche Charles     Worliche, Charles 49
3997366 2023812 2023812 defendant Wallrond John     Wallrond, John 50
3997367 2023812 2023812 defendant Esmunde William     Esmunde, William 51
3997368 2023812 2023812 defendant Fitche Oswald     Fitche, Oswald 52
3997369 2023812 2023812 defendant Butler Philip     Butler, Philip 53
3997370 2023812 2023812 defendant Godolphyn William     Godolphyn, William 54
3997371 2023812 2023812 defendant Homchirche John     Homchirche, John 55
3997372 2023812 2023812 defendant Wheiler Richard     Wheiler, Richard 56
3997373 2023812 2023812 defendant Readinge Richard     Readinge, Richard 57
3997374 2023812 2023812 defendant Cuffe William     Cuffe, William 58
3997375 2023812 2023812 defendant Kensham George     Kensham, George 59
3997376 2023812 2023812 defendant Witchall Richard     Witchall, Richard 60
3997377 2023812 2023812 defendant Squibbe Henry     Squibbe, Henry 61
3997378 2023812 2023812 defendant Campion John     Campion, John 62
3997379 2023812 2023812 defendant Wyse John     Wyse, John 63
3997380 2023812 2023812 defendant Goddrington Simon     Goddrington, Simon 64
3997381 2023812 2023812 defendant Bythell Hugh     Bythell, Hugh 65
3997382 2023812 2023812 defendant Coventrye Richard     Coventrye, Richard 66
3997383 2023812 2023812 defendant Lowman John     Lowman, John 67
3997384 2023812 2023812 defendant Saunders John     Saunders, John 68
3997385 2023812 2023812 defendant Olyver Walter     Olyver, Walter 69
3997386 2023812 2023812 defendant Callmadye Richard     Callmadye, Richard 70
3997387 2023812 2023812 defendant Browke John     Browke, John 71
3997388 2023812 2023812 defendant Pease Robert     Pease, Robert 72
3997389 2023812 2023812 defendant Stapollhyll Hugh     Stapollhyll, Hugh 73
3997390 2023812 2023812 defendant Hutchyns Edmund     Hutchyns, Edmund 74
3997391 2023812 2023812 defendant Summaster John     Summaster, John 75
3997392 2023812 2023812 defendant Arrondell Alexander     Arrondell, Alexander 76
3997393 2023812 2023812 defendant Willies Nicholas     Willies, Nicholas 77
3997394 2023812 2023812 defendant Sharpham Richard all of Lyons Inn, gent   Sharpham, Richard, all of Lyons Inn, gent 78

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