names

44 rows where place_id = 598869

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634382 1905552 1905552 defendant Partriche Thomas   598869 598869 Partriche, Thomas, of Osprynge 0
3777207 1950622 1950622 defendant Exbregge Robert gent 598869 598869 Exbregge, Robert, of Osprynge, gent 0
4158392 2081006 2081006 defendant Fynche Elizabeth widow 598869 598869 Fynche, Elizabeth, of Osprynge, widow 1
4210616 2099269 2099269 defendant Sougate Robert husbandman 598869 598869 Sougate, Robert, of Osprynge, husbandman 1
4210617 2099269 2099269 defendant Sprott Robert husbandman 598869 598869 Sprott, Robert, of Osprynge, husbandman 2
4486139 2196365 2196365 defendant Wade John   598869 598869 Wade, John, of Osprynge 2
4532676 2210487 2210487 defendant Norman William   598869 598869 Norman, William, of Osprynge, hackney man 0
4673073 2257222 2257222 defendant Deye Nicholas taverner 598869 598869 Deye, Nicholas, of Osprynge, taverner 0
4958340 2344460 2344460 defendant Dancastre William hosteler 598869 598869 Dancastre, William, of Osprynge, hosteler 2
4966522 2346920 2346920 defendant Dodyngton Thomas smith 598869 598869 Dodyngton, Thomas, of Osprynge, smith 0
4975374 2349593 2349593 defendant Furnour Thomas husbandman 598869 598869 Furnour, Thomas, of Osprynge, husbandman 4
4986620 2352930 2352930 defendant Da_ William ostler 598869 598869 Da_, William, of Osprynge, ostler 0
4992554 2354657 2354657 defendant Stonstrete John laborer 598869 598869 Stonstrete, John, of Osprynge, laborer 0
5006107 2358675 2358675 defendant Savage Richard husbandman 598869 598869 Savage, Richard, of Osprynge, husbandman 0
5012785 2360571 2360571 plaintiff Adamys Alexander   598869 598869 Adamys, Alexander, of Osprynge 0
5049773 2371560 2371560 defendant Doncastre William hosteler 598869 598869 Doncastre, William, of Osprynge, hosteler 0
5057607 2373843 2373843 defendant Savage Nicholas smith 598869 598869 Savage, Nicholas, of Osprynge, smith 1
5077777 2379848 2379848 defendant Wade John yeoman 598869 598869 Wade, John, of Osprynge, yeoman 0
5090938 2383745 2383745 defendant Bachelor John clerk 598869 598869 Bachelor, John, of Osprynge, clerk 0
5091968 2384030 2384030 defendant Savage Nicholas smith 598869 598869 Savage, Nicholas, of Osprynge, smith 0
5184240 2411134 2411134 defendant Savage William laborer 598869 598869 Savage, William, of Osprynge, laborer 0
5184242 2411134 2411134 defendant Savage John smith 598869 598869 Savage, John, of Osprynge, smith 2
5214548 2419983 2419983 defendant Wellys John husbandman 598869 598869 Wellys, John, of Osprynge, husbandman 0
5231984 2424924 2424924 defendant Pende James husbandman 598869 598869 Pende, James, of Osprynge, husbandman 0
5240893 2427542 2427542 plaintiff Kyng Thomas   598869 598869 Kyng, Thomas, of Osprynge 0
5265909 2435092 2435092 defendant Brokdale Thomas husbandman 598869 598869 Brokdale, Thomas, of Osprynge, husbandman 0
5265912 2435092 2435092 defendant Benet Michael laborer 598869 598869 Benet, Michael, of Osprynge, laborer 3
5266376 2435234 2435234 defendant Wade John husbandman 598869 598869 Wade, John, of Osprynge, husbandman 2
5269796 2436276 2436276 defendant Chyldmell Robert ostler 598869 598869 Chyldmell, Robert, of Osprynge, ostler 0
5316167 2449912 2449912 defendant Lynd Nicholas husbandman 598869 598869 Lynd, Nicholas, of Osprynge, husbandman 0
5321207 2451439 2451439 defendant atte Seathe Peter husbandman 598869 598869 atte Seathe, Peter, of Osprynge, husbandman 0
5323739 2452185 2452185 defendant Woode Richard yeoman 598869 598869 Woode, Richard, of Osprynge, yeoman 1
5323740 2452185 2452185 defendant Axbrigge Thomas ostler 598869 598869 Axbrigge, Thomas, of Osprynge, ostler 2
5323741 2452185 2452185 defendant Colyns John husbandman 598869 598869 Colyns, John, of Osprynge, husbandman 3
5333873 2455204 2455204 defendant Cok Elias innholder 598869 598869 Cok, Elias, of Osprynge, innholder 0
5548423 2519573 2519573 defendant Potyn John husbandman 598869 598869 Potyn, John, of Osprynge, husbandman 0
5570111 2525833 2525833 defendant ac Seeth Peter husbandman 598869 598869 ac Seeth, Peter, of Osprynge, husbandman 0
5587933 2531236 2531236 defendant White John husbandman 598869 598869 White, John, of Osprynge, husbandman 1
5593818 2533052 2533052 defendant Brice Thomas butcher 598869 598869 Brice, Thomas, of Osprynge, butcher 0
5593819 2533052 2533052 defendant Sterysasshe Thomas husbandman 598869 598869 Sterysasshe, Thomas, of Osprynge, husbandman 1
5593820 2533052 2533052 defendant Owlett John husbandman 598869 598869 Owlett, John, of Osprynge, husbandman 2
5593821 2533052 2533052 defendant Herydnen Thomas laborer 598869 598869 Herydnen, Thomas, of Osprynge, laborer 3
5598593 2534442 2534442 defendant Stanley Agnes widow 598869 598869 Stanley, Agnes, of Osprynge, widow 0
5610793 2547098 2547098 defendant Apuldre William   598869 598869 Apuldre, William, of Osprynge 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);