names

39 rows where place_id = 588992

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596213 1866444 1866444 defendant Tornell William gent 588992 588992 Tornell, William, of Holborn St Andrew, gent 0
3674332 1918016 1918016 defendant Aphowell Fulk merchant tailor 588992 588992 Aphowell, Fulk, of Holborn St Andrew, merchant tailor 0
4007821 2027580 2027580 plaintiff Mathyson John   588992 588992 Mathyson, John, of Holborn St Andrew, administrators of 0
4007825 2027581 2027581 plaintiff Mathyson John   588992 588992 Mathyson, John, of Holborn St Andrew, administrators of 0
4007829 2027582 2027582 plaintiff Mathyson John   588992 588992 Mathyson, John, of Holborn St Andrew, administrators of 0
4007833 2027583 2027583 plaintiff Mathyson John   588992 588992 Mathyson, John, of Holborn St Andrew, administrators of 0
4080098 2053190 2053190 plaintiff Wadylowe Hugh innholder 588992 588992 Wadylowe, Hugh, of Holborn St Andrew, innholder 0
4298803 2129669 2129669 defendant Grymshawe William tailor 588992 588992 Grymshawe, William, of Holborn St Andrew, tailor 2
4310571 2133846 2133846 defendant Symondes Robert haberdasher 588992 588992 Symondes, Robert, of Holborn St Andrew, haberdasher 0
4354201 2148699 2148699 defendant Millett Thomas yeoman 588992 588992 Millett, Thomas, of Holborn St Andrew, yeoman 1
4370233 2154414 2154414 defendant Jones William tailor 588992 588992 Jones, William, of Holborn St Andrew, tailor 1
4791613 2293473 2293473 defendant Forster William   588992 588992 Forster, William, of Holborn St Andrew 1
4982418 2351661 2351661 defendant Brigham John brewer 588992 588992 Brigham, John, of Holborn St Andrew, brewer 1
5054813 2373008 2373008 defendant Bradford William gent 588992 588992 Bradford, William, of Holborn St Andrew, gent 5
5054817 2373009 2373009 defendant Gernet William gent 588992 588992 Gernet, William, of Holborn St Andrew, gent 0
5054822 2373009 2373009 defendant Bradford William gent 588992 588992 Bradford, William, of Holborn St Andrew, gent 5
5072246 2378188 2378188 defendant Ratford William cooper 588992 588992 Ratford, William, of Holborn St Andrew, cooper 0
5084591 2381904 2381904 defendant Sperman Henry tailor 588992 588992 Sperman, Henry, of Holborn St Andrew, tailor 0
5108684 2388975 2388975 defendant Nansegles Richard gent 588992 588992 Nansegles, Richard, of Holborn St Andrew, gent 1
5237518 2426557 2426557 defendant Graunt John gent 588992 588992 Graunt, John, of Holborn St Andrew, gent 0
5237520 2426558 2426558 defendant Fortescu Richard gent 588992 588992 Fortescu, Richard, of Holborn St Andrew, gent 0
5237521 2426558 2426558 defendant Grymesby Simon gent 588992 588992 Grymesby, Simon, of Holborn St Andrew, gent 1
5237522 2426558 2426558 defendant Kellowe Thomas gent 588992 588992 Kellowe, Thomas, of Holborn St Andrew, gent 2
5237524 2426559 2426559 defendant Stone Philip gent 588992 588992 Stone, Philip, of Holborn St Andrew, gent 0
5237525 2426559 2426559 defendant Waleys John gent 588992 588992 Waleys, John, of Holborn St Andrew, gent 1
5237527 2426560 2426560 defendant Chesildon John gent 588992 588992 Chesildon, John, of Holborn St Andrew, gent 0
5237528 2426560 2426560 defendant Durward John gent 588992 588992 Durward, John, of Holborn St Andrew, gent 1
5237529 2426560 2426560 defendant Durward William gent 588992 588992 Durward, William, of Holborn St Andrew, gent 2
5237531 2426561 2426561 defendant Benet John gent 588992 588992 Benet, John, of Holborn St Andrew, gent 0
5237532 2426561 2426561 defendant Flemmyng Richard gent 588992 588992 Flemmyng, Richard, of Holborn St Andrew, gent 1
5240314 2427379 2427379 defendant Clerk Walter gent 588992 588992 Clerk, Walter, of Holborn St Andrew, gent 0
5240315 2427379 2427379 defendant Grymmesby Simon gent 588992 588992 Grymmesby, Simon, of Holborn St Andrew, gent 1
5240316 2427379 2427379 defendant Kellowe Thomas gent 588992 588992 Kellowe, Thomas, of Holborn St Andrew, gent 2
5290013 2442085 2442085 defendant Lokton Walter esq 588992 588992 Lokton, Walter, of Holborn St Andrew, esq 2
5503871 2506126 2506126 defendant Rowe John gardner 588992 588992 Rowe, John, of Holborn St Andrew, gardner 3
5531570 2514405 2514405 defendant Smale henry brewer 588992 588992 Smale, henry, of Holborn St Andrew, brewer 0
5547592 2519312 2519312 defendant Wodeforde John esq 588992 588992 Wodeforde, John, of Holborn St Andrew, esq 4
5596097 2533693 2533693 defendant Mychell William butcher 588992 588992 Mychell, William, of Holborn St Andrew, butcher 0
5605294 2536534 2536534 defendant Noble James brewer 588992 588992 Noble, James, of Holborn St Andrew, brewer 0

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