names

68 rows where place_id = 630805

✎ 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
3796661 1956835 1956835 defendant Crakenell John tanner 630805 630805 Crakenell, John, of Boxforde, tanner 0
3836826 1969420 1969420 defendant Todde Edmund sherman 630805 630805 Todde, Edmund, of Boxforde, sherman 2
3935083 2002041 2002041 defendant Brand William clothier 630805 630805 Brand, William, of Boxforde, clothier 0
3935084 2002041 2002041 defendant Mylner Thomas clothier 630805 630805 Mylner, Thomas, of Boxforde, clothier 1
3935091 2002044 2002044 defendant Mylner Thomas clothier 630805 630805 Mylner, Thomas, of Boxforde, clothier 1
3964687 2012255 2012255 defendant Browghton Robert clothier 630805 630805 Browghton, Robert, of Boxforde, clothier 1
4019018 2031537 2031537 defendant Clark John   630805 630805 Clark, John, of Boxforde, wood setter 0
4019019 2031537 2031537 defendant Coo William clothier 630805 630805 Coo, William, of Boxforde, clothier 1
4042277 2039718 2039718 defendant Goslyn Philip clothier 630805 630805 Goslyn, Philip, of Boxforde, clothier 1
4059082 2045644 2045644 defendant Coo John gent 630805 630805 Coo, John, of Boxforde, gent 2
4059086 2045645 2045645 defendant Coo John gent 630805 630805 Coo, John, of Boxforde, gent 2
4064701 2047663 2047663 defendant Durrant George clothier 630805 630805 Durrant, George, of Boxforde, clothier 0
4073685 2050880 2050880 plaintiff Pote Robert clothier 630805 630805 Pote, Robert, of Boxforde, clothier 0
4073686 2050880 2050880 defendant Whytynge Thomas clithier 630805 630805 Whytynge, Thomas, of Boxforde, clithier 0
4081339 2053635 2053635 plaintiff Whitynge Thomas clothier 630805 630805 Whitynge, Thomas, of Boxforde, clothier 0
4109511 2063664 2063664 defendant Jerrold William clothier 630805 630805 Jerrold, William, of Boxforde, clothier 0
4111144 2064240 2064240 defendant Coo William clothier 630805 630805 Coo, William, of Boxforde, clothier 0
4125234 2069312 2069312 defendant Hyggyn Richard, junior yeoman 630805 630805 Hyggyn, Richard, junior, of Boxforde, yeoman 0
4125237 2069313 2069313 defendant Jarrard William yeoman 630805 630805 Jarrard, William, of Boxforde, yeoman 0
4125238 2069313 2069313 defendant Coppyn Thomas tailor 630805 630805 Coppyn, Thomas, of Boxforde, tailor 1
4125240 2069314 2069314 defendant Smyth Robert weaver 630805 630805 Smyth, Robert, of Boxforde, weaver 0
4125241 2069314 2069314 defendant Lythermer Christopher weaver 630805 630805 Lythermer, Christopher, of Boxforde, weaver 1
4125242 2069314 2069314 defendant Lambe Thomas weaver 630805 630805 Lambe, Thomas, of Boxforde, weaver 2
4125244 2069315 2069315 defendant Teryngton Robert painter 630805 630805 Teryngton, Robert, of Boxforde, painter 0
4125245 2069315 2069315 defendant Wrenche Robert weaver 630805 630805 Wrenche, Robert, of Boxforde, weaver 1
4127068 2069971 2069971 defendant Byrche Gilbert weaver 630805 630805 Byrche, Gilbert, of Boxforde, weaver 2
4143486 2075880 2075880 defendant Broughton Robert clothier 630805 630805 Broughton, Robert, of Boxforde, clothier 2
4173722 2086266 2086266 defendant Durrant George clothier 630805 630805 Durrant, George, of Boxforde, clothier 0
4185738 2090514 2090514 defendant Whyting Thomas clothier 630805 630805 Whyting, Thomas, of Boxforde, clothier 0
4192171 2092826 2092826 defendant Jarrolde William clothier 630805 630805 Jarrolde, William, of Boxforde, clothier 0
4192172 2092826 2092826 defendant Richard George joiner 630805 630805 Richard, George, of Boxforde, joiner 1
4192178 2092828 2092828 defendant Grene John ashburner 630805 630805 Grene, John, of Boxforde, ashburner 0
4192180 2092828 2092828 defendant Waynflete alias Pyper John sherman 630805 630805 Waynflete alias Pyper, John, of Boxforde, sherman 2
4207636 2098230 2098230 defendant Brande Richard, senior clothier 630805 630805 Brande, Richard, senior, of Boxforde, clothier 0
4207637 2098230 2098230 defendant Brande Richard, junior clothier 630805 630805 Brande, Richard, junior, of Boxforde, clothier 1
4207638 2098230 2098230 defendant Lappage Thomas clothier 630805 630805 Lappage, Thomas, of Boxforde, clothier 2
4207641 2098231 2098231 defendant Baker Christopher yeoman 630805 630805 Baker, Christopher, of Boxforde, yeoman 1
4207643 2098231 2098231 defendant Osborne William yeoman 630805 630805 Osborne, William, of Boxforde, yeoman 3
4277199 2121957 2121957 defendant Huggyn Richard clothier 630805 630805 Huggyn, Richard, of Boxforde, clothier 0
4328480 2139840 2139840 defendant Heywarde John mariner 630805 630805 Heywarde, John, of Boxforde, or of Colchester, mariner 0
4348898 2146877 2146877 defendant Poote Robert (legal representative) 630805 630805 Poote, Robert, of Boxforde, clothier, executor of 0
4393391 2162391 2162391 defendant Kynge Robert glover 630805 630805 Kynge, Robert, of Boxforde, glover 1
4393691 2162492 2162492 defendant Sendall William yeoman 630805 630805 Sendall, William, of Boxforde, yeoman 2
4397639 2163787 2163787 defendant Gerroulde William clothier 630805 630805 Gerroulde, William, of Boxforde, clothier 0
4410675 2168163 2168163 defendant Chapman Peter sherman 630805 630805 Chapman, Peter, of Boxforde, sherman 0
4467066 2190369 2190369 defendant Creeke John   630805 630805 Creeke, John, of Boxforde 0
4492760 2198437 2198437 plaintiff Aleyn John   630805 630805 Aleyn, John, of Boxforde, on his own account 0
4501270 2201003 2201003 defendant Jekel John shoemaker 630805 630805 Jekel, John, of Boxforde, shoemaker 0
4516849 2205674 2205674 defendant Stodebroke Thomas   630805 630805 Stodebroke, Thomas, of Boxforde 0
4516850 2205674 2205674 defendant Bowyer John   630805 630805 Bowyer, John, of Boxforde 1
4546698 2214892 2214892 plaintiff Bronde John   630805 630805 Bronde, John, of Boxforde 0
4549524 2215797 2215797 defendant Tille John   630805 630805 Tille, John, of Boxforde 3
4599940 2231202 2231202 defendant Rogges John butcher 630805 630805 Rogges, John, of Boxforde, butcher 0
4663929 2250202 2250202 plaintiff Not Robert   630805 630805 Not, Robert, of Boxforde 2
4670175 2256377 2256377 plaintiff Brond or Broud Henry (legal representative) 630805 630805 Brond or Broud, Henry, of Boxforde, executors of 0
4679989 2259344 2259344 plaintiff Not Robert   630805 630805 Not, Robert, of Boxforde 2
4705656 2267144 2267144 plaintiff Not Robert   630805 630805 Not, Robert, of Boxforde 3
4844021 2309639 2309639 defendant Brounyng Hugh fuller 630805 630805 Brounyng, Hugh, of Boxforde, fuller 0
4906446 2328602 2328602 plaintiff Reve John   630805 630805 Reve, John, of Boxforde 0
4980033 2350982 2350982 plaintiff Smyth Thomas (legal representative) 630805 630805 Smyth, Thomas, of Boxforde, executors of 0
4980036 2350982 2350982 defendant Grygge John husbandman 630805 630805 Grygge, John, of Boxforde, husbandman 0
4983297 2351910 2351910 defendant Brook John yeoman 630805 630805 Brook, John, of Boxforde, yeoman 0
5005131 2358397 2358397 plaintiff Reve John   630805 630805 Reve, John, of Boxforde 0
5005132 2358397 2358397 plaintiff Brond John   630805 630805 Brond, John, of Boxforde 1
5211723 2419169 2419169 defendant Coo John pedder 630805 630805 Coo, John, of Boxforde, pedder 1
5217780 2420929 2420929 defendant Coo John pedder 630805 630805 Coo, John, of Boxforde, pedder 1
5624277 2551541 2551541 plaintiff Not Robert   630805 630805 Not, Robert, of Boxforde 3
5624290 2551543 2551543 plaintiff Not Robert   630805 630805 Not, Robert, of Boxforde 3

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