names

45 rows where place_id = 610857

✎ 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
3685602 1921649 1921649 defendant Love Thomas husbandman 610857 610857 Love, Thomas, of Boxsted, husbandman 1
3712604 1930257 1930257 defendant Rolff John husbandman 610857 610857 Rolff, John, of Boxsted, husbandman 2
3713521 1930540 1930540 defendant Seger Robert, senior husbandman 610857 610857 Seger, Robert, senior, of Boxsted, husbandman 0
3786393 1953531 1953531 defendant Bruar William carpenter 610857 610857 Bruar, William, of Boxsted, carpenter 1
3835318 1968985 1968985 defendant Hynde John glover 610857 610857 Hynde, John, of Boxsted, glover 2
3840109 1970479 1970479 defendant Bruer William carpenter 610857 610857 Bruer, William, of Boxsted, carpenter 1
3902696 1991134 1991134 plaintiff Farmor John husbandman 610857 610857 Farmor, John, of Boxsted, husbandman 0
3938129 2003087 2003087 plaintiff Poley John gent 610857 610857 Poley, John, of Boxsted, gent 0
3938131 2003088 2003088 plaintiff Poley John gent 610857 610857 Poley, John, of Boxsted, gent 0
4025770 2033870 2033870 defendant Mansyn William smith 610857 610857 Mansyn, William, of Boxsted, smith 3
4123681 2068772 2068772 defendant Fermer John husbandman 610857 610857 Fermer, John, of Boxsted, husbandman 0
4124427 2069031 2069031 defendant Bogas John clothier 610857 610857 Bogas, John, of Boxsted, clothier 0
4145356 2076538 2076538 defendant Fermor John husbandman 610857 610857 Fermor, John, of Boxsted, husbandman 0
4172624 2085883 2085883 defendant Begas John clothier 610857 610857 Begas, John, of Boxsted, clothier 0
4233946 2107397 2107397 defendant Hunt George clothier 610857 610857 Hunt, George, of Boxsted, clothier 20
4233947 2107397 2107397 defendant Luffkyn Richard clothier 610857 610857 Luffkyn, Richard, of Boxsted, clothier 21
4276254 2121637 2121637 defendant Fissher Henry yeoman 610857 610857 Fissher, Henry, of Boxsted, yeoman 0
4348442 2146707 2146707 defendant Colte Thomas gent 610857 610857 Colte, Thomas, of Boxsted, gent 0
4400380 2164722 2164722 defendant Grigges Richard yeoman 610857 610857 Grigges, Richard, of Boxsted, yeoman 0
4409838 2167893 2167893 defendant Cockerell Nicholas yeoman 610857 610857 Cockerell, Nicholas, of Boxsted, yeoman 0
4432705 2174982 2174982 defendant fitz Stevene William   610857 610857 fitz Stevene, William, of Boxsted 0
4557052 2218133 2218133 defendant Calk John shoemaker 610857 610857 Calk, John, of Boxsted, shoemaker 1
4557057 2218134 2218134 defendant Calk John shoemaker 610857 610857 Calk, John, of Boxsted, shoemaker 1
4610488 2234352 2234352 plaintiff Carter Maud   610857 610857 Carter, Maud, of Boxsted 0
4726818 2273658 2273658 defendant Herde Thomas husbandman 610857 610857 Herde, Thomas, of Boxsted, husbandman 1
4866628 2316523 2316523 defendant Badwell John esq 610857 610857 Badwell, John, of Boxsted, esq 0
4899500 2326483 2326483 defendant Badewell John (legal representative) 610857 610857 Badewell, John, of Boxsted, gent, executors of 0
4899501 2326483 2326483 defendant Badewell Elizabeth widow 610857 610857 (Badewell, Elizabeth, of Boxsted, widow 1
4899503 2326483 2326483 defendant Foster Robert husbandman 610857 610857 Foster, Robert, of Boxsted, husbandman 3
4918746 2332375 2332375 defendant Poteer Thomas husbandman 610857 610857 Poteer, Thomas, of Boxsted, husbandman 1
4936614 2337835 2337835 defendant Squyer John tiler 610857 610857 Squyer, John, of Boxsted, tiler 0
4942837 2339731 2339731 plaintiff Fulthorp William (legal representative) 610857 610857 Fulthorp, William, of Boxsted esq, executrix of 0
4956341 2343860 2343860 defendant Bokkyng John butcher 610857 610857 Bokkyng, John, of Boxsted, butcher 1
4965495 2346596 2346596 defendant Gardener Thomas husbandman 610857 610857 Gardener, Thomas, of Boxsted, husbandman 0
4965496 2346596 2346596 defendant Gardener John laborer 610857 610857 Gardener, John, of Boxsted, laborer 1
5020167 2362787 2362787 defendant Pakewode Felicia widow 610857 610857 Pakewode, Felicia, of Boxsted, widow 0
5059059 2374274 2374274 defendant Pakwode John husbandman 610857 610857 Pakwode, John, of Boxsted, husbandman 0
5105042 2387907 2387907 defendant Mawedyn William yeoman 610857 610857 Mawedyn, William, of Boxsted, yeoman 1
5140746 2398408 2398408 defendant Pulter John husbandman 610857 610857 Pulter, John, of Boxsted, husbandman 0
5161862 2404578 2404578 defendant Pulter John husbandman 610857 610857 Pulter, John, of Boxsted, husbandman 0
5178736 2409500 2409500 defendant Bokkyng John butcher 610857 610857 Bokkyng, John, of Boxsted, butcher 1
5284494 2440476 2440476 defendant Hervy John roper 610857 610857 Hervy, John, of Boxsted, roper 0
5367759 2465546 2465546 plaintiff Comberton Robert gent 610857 610857 Comberton, Robert, of Boxsted, gent 0
5539105 2516714 2516714 defendant Culpak John husbandman 610857 610857 Culpak, John, of Boxsted, husbandman 0
5634731 2554860 2554860 plaintiff Goodwe John   610857 610857 Goodwe, John, of Boxsted 1

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