names

47 rows where place_id = 597937

✎ 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
3630471 1904363 1904363 defendant Wakeman Richard yeoman 597937 597937 Wakeman, Richard, of Burgham, yeoman 0
3724554 1933965 1933965 defendant Godyn William husbandman 597937 597937 Godyn, William, of Burgham, husbandman 1
3767525 1947480 1947480 defendant Godyn William husbandman 597937 597937 Godyn, William, of Burgham, husbandman 0
3767526 1947480 1947480 defendant Alen John husbandman 597937 597937 Alen, John, of Burgham, husbandman 1
3767527 1947480 1947480 defendant Dey John husbandman 597937 597937 Dey, John, of Burgham, husbandman 2
3838624 1970007 1970007 defendant More John carpenter 597937 597937 More, John, of Burgham, carpenter 0
3857455 1975967 1975967 defendant Godden William husbandman 597937 597937 Godden, William, of Burgham, husbandman 0
3857456 1975967 1975967 defendant Benett Thomas husbandman 597937 597937 Benett, Thomas, of Burgham, husbandman 1
3892913 1987877 1987877 defendant Rosse Alexander yeoman 597937 597937 Rosse, Alexander, of Burgham, yeoman 0
4536187 2211593 2211593 defendant Peek John   597937 597937 Peek, John, of Burgham 1
4563195 2220059 2220059 defendant Crosby Richard   597937 597937 Crosby, Richard, of Burgham, vicar 0
4589854 2228191 2228191 defendant Man John   597937 597937 Man, John, of Burgham 3
4643065 2244081 2244081 plaintiff Mercer Thomas   597937 597937 Mercer, Thomas, of Burgham, parson 2
4691152 2262753 2262753 defendant Travers John esq 597937 597937 Travers, John, of Burgham, esq 0
4693331 2263417 2263417 defendant Priklove William husbandman 597937 597937 Priklove, William, of Burgham, husbandman 0
4721325 2272001 2272001 plaintiff Rowe Thomas   597937 597937 Rowe, Thomas, of Burgham 2
4722230 2272276 2272276 defendant Meburne Thomas yeoman 597937 597937 Meburne, Thomas, of Burgham, yeoman 0
4722685 2272412 2272412 defendant Rowe Thomas husbandman 597937 597937 Rowe, Thomas, of Burgham, husbandman 0
4795854 2294853 2294853 defendant Hamond Richard shoemaker 597937 597937 Hamond, Richard, of Burgham, shoemaker 0
4828941 2305095 2305095 defendant Gate John carpenter 597937 597937 Gate, John, of Burgham, carpenter 0
4833609 2306519 2306519 defendant Alunby John husbandman 597937 597937 Alunby, John, of Burgham, husbandman 3
4881664 2321163 2321163 defendant Gerold John husbandman 597937 597937 Gerold, John, of Burgham, husbandman 0
4915937 2331481 2331481 defendant Oxecombe Thomas farmer 597937 597937 Oxecombe, Thomas, of Burgham, farmer 1
4915939 2331481 2331481 defendant Monger Walter laborer 597937 597937 Monger, Walter, of Burgham, laborer 3
4915940 2331481 2331481 defendant Streter John, senior   597937 597937 Streter, John, senior, of Burgham, shepherd 4
4915941 2331481 2331481 defendant Hayman William laborer 597937 597937 Hayman, William, of Burgham, laborer 5
4925079 2334275 2334275 defendant Baty Thomas gent 597937 597937 Baty, Thomas, of Burgham, gent 0
4941125 2339247 2339247 defendant Monger Walter laborer 597937 597937 Monger, Walter, of Burgham, laborer 3
4941126 2339247 2339247 defendant Streter John, senior   597937 597937 Streter, John, senior, of Burgham, shepherd 4
4941127 2339247 2339247 defendant Hayman William laborer 597937 597937 Hayman, William, of Burgham, laborer 5
4956520 2343908 2343908 defendant Bedell William husbandman 597937 597937 Bedell, William, of Burgham, husbandman 1
5051083 2371932 2371932 defendant Knyller Thomas husbandman 597937 597937 Knyller, Thomas, of Burgham, husbandman 0
5061705 2375096 2375096 defendant Croucher Richard husbandman 597937 597937 Croucher, Richard, of Burgham, husbandman 0
5072687 2378315 2378315 defendant Kneller Thomas husbandman 597937 597937 Kneller, Thomas, of Burgham, husbandman 0
5150168 2401190 2401190 defendant Troucher Richard laborer 597937 597937 Troucher, Richard, of Burgham, laborer 1
5150761 2401366 2401366 defendant Croucher Richard laborer 597937 597937 Croucher, Richard, of Burgham, laborer 1
5168846 2406618 2406618 defendant Croucher Richard laborer 597937 597937 Croucher, Richard, of Burgham, laborer 1
5207482 2417930 2417930 defendant Stonpyk Lawrence laborer 597937 597937 Stonpyk, Lawrence, of Burgham, laborer 0
5244136 2428477 2428477 defendant Crowcher Richard husbandman 597937 597937 Crowcher, Richard, of Burgham, husbandman 0
5283795 2440301 2440301 defendant Chillyng Roger husbandman 597937 597937 Chillyng, Roger, of Burgham, husbandman 5
5283818 2440302 2440302 defendant Chillyng Roger husbandman 597937 597937 Chillyng, Roger, of Burgham, husbandman 10
5315012 2449543 2449543 defendant Philpot William husbandman 597937 597937 Philpot, William, of Burgham, husbandman 0
5357910 2462542 2462542 defendant Medewey Thomas clerk 597937 597937 Medewey, Thomas, of Burgham, clerk 0
5366005 2465026 2465026 defendant Munds William husbandman 597937 597937 Munds, William, of Burgham, husbandman 1
5366006 2465026 2465026 defendant Ware Richard husbandman 597937 597937 Ware, Richard, of Burgham, husbandman 2
5412376 2478647 2478647 defendant Chillyng Roger husbandman 597937 597937 Chillyng, Roger, of Burgham, husbandman 0
5427167 2483067 2483067 defendant Chillyng Roger husbandman 597937 597937 Chillyng, Roger, of Burgham, husbandman 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);