names

32 rows where place_id = 774118

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4608298 2233706 2233706 defendant Michell Adam tanner 774118 774118 Michell, Adam, of Neuport, Essex, tanner 0
4712511 2269230 2269230 defendant atte Spytell John husbandman 774118 774118 atte Spytell, John, of Neuport, Essex, husbandman 2
4822660 2303163 2303163 defendant Fraunceys Thomas husbandman 774118 774118 Fraunceys, Thomas, of Neuport, Essex, husbandman 0
4824419 2303691 2303691 defendant Halstyde Robert clerk 774118 774118 Halstyde, Robert, of Neuport, Essex, clerk 3
4905564 2328340 2328340 defendant Clerk Richard   774118 774118 Clerk, Richard, of Neuport, Essex, holy water clerk 0
4930091 2335818 2335818 defendant Harlyng John husbandman 774118 774118 Harlyng, John, of Neuport, Essex, husbandman 0
4943392 2339902 2339902 defendant Hawekyn William yeoman 774118 774118 Hawekyn, William, of Neuport, Essex, yeoman 0
4964660 2346337 2346337 defendant Bolter John pedder 774118 774118 Bolter, John, of Neuport, Essex, pedder 3
5002951 2357766 2357766 defendant Fraunceys John chapman 774118 774118 Fraunceys, John, of Neuport, Essex, chapman 1
5020246 2362811 2362811 defendant Revell John husbandman 774118 774118 Revell, John, of Neuport, Essex, husbandman 0
5023673 2363832 2363832 plaintiff Hawkyn William (legal representative) 774118 774118 Hawkyn, William, of Neuport, Essex, executors of 0
5039162 2368355 2368355 defendant Ponde John   774118 774118 Ponde, John, of Neuport, Essex, cartwright 0
5063222 2375531 2375531 defendant Cole John husbandman 774118 774118 Cole, John, of Neuport, Essex, husbandman 0
5104350 2387696 2387696 defendant Fraunceys John yeoman 774118 774118 Fraunceys, John, of Neuport, Essex, yeoman 0
5118743 2391912 2391912 defendant Asteley Thomas gent 774118 774118 Asteley, Thomas, of Neuport, Essex, gent 1
5217842 2420949 2420949 defendant Stoker John husbandman 774118 774118 Stoker, John, of Neuport, Essex, husbandman 2
5302329 2445665 2445665 defendant Shappe John chapman 774118 774118 Shappe, John, of Neuport, Essex, chapman 0
5309101 2447759 2447759 defendant Ryppyngale Robert husbandman 774118 774118 Ryppyngale, Robert, of Neuport, Essex, husbandman 1
5311110 2448354 2448354 defendant Bedford John clerk 774118 774118 Bedford, John, of Neuport, Essex, clerk 0
5311225 2448384 2448384 defendant Bedford John clerk 774118 774118 Bedford, John, of Neuport, Essex, clerk 0
5340814 2457327 2457327 defendant Sharp John mercer 774118 774118 Sharp, John, of Neuport, Essex, mercer 2
5340819 2457328 2457328 defendant Sharp John mercer 774118 774118 Sharp, John, of Neuport, Essex, mercer 2
5361312 2463560 2463560 defendant Whitmoth Thomas yeoman 774118 774118 Whitmoth, Thomas, of Neuport, Essex, yeoman 0
5406504 2476931 2476931 defendant Moordon William hosier 774118 774118 Moordon, William, of Neuport, Essex, hosier 1
5419598 2480782 2480782 defendant Moordon William hosier 774118 774118 Moordon, William, of Neuport, Essex, hosier 1
5419603 2480783 2480783 defendant Moordon William hosier 774118 774118 Moordon, William, of Neuport, Essex, hosier 1
5457695 2492199 2492199 defendant Holt Thomas husbandman 774118 774118 Holt, Thomas, of Neuport, Essex, husbandman 4
5465697 2494655 2494655 defendant Bredgore John husbandman 774118 774118 Bredgore, John, of Neuport, Essex, husbandman 0
5465700 2494656 2494656 defendant Brodgore John husbandman 774118 774118 Brodgore, John, of Neuport, Essex, husbandman 0
5469541 2495813 2495813 defendant Holt Thomas husbandman 774118 774118 Holt, Thomas, of Neuport, Essex, husbandman 4
5501241 2505326 2505326 defendant Garold homas butcher 774118 774118 Garold, homas, of Neuport, Essex, butcher 2
5545189 2518596 2518596 defendant Chycheley John   774118 774118 Chycheley, John, of Neuport, Essex 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);