names

75 rows where place_id = 600587

✎ 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
3641658 1907848 1907848 defendant Prowde William husbandman 600587 600587 Prowde, William, of Petham, husbandman 0
3781331 1951904 1951904 defendant Wedy Christopher husbandman 600587 600587 Wedy, Christopher, of Petham, husbandman 1
3868120 1979573 1979573 defendant Colman Henry gent 600587 600587 Colman, Henry, of Petham, gent 0
3995022 2022966 2022966 defendant Gaye Edmund gent 600587 600587 Gaye, Edmund, of Petham, gent 1
4041691 2039511 2039511 defendant Gaye Edmund gent 600587 600587 Gaye, Edmund, of Petham, gent 0
4041693 2039512 2039512 defendant Gaye Edmund gent 600587 600587 Gaye, Edmund, of Petham, gent 0
4052814 2043442 2043442 defendant Adman Nicholas husbandman 600587 600587 Adman, Nicholas, of Petham, husbandman 0
4196554 2094341 2094341 defendant Colman John, senior husbandman 600587 600587 Colman, John, senior, of Petham, husbandman 0
4196555 2094341 2094341 defendant Colman John gent 600587 600587 Colman, John, of Petham, gent 1
4196557 2094342 2094342 defendant Colman John, senior husbandman 600587 600587 Colman, John, senior, of Petham, husbandman 0
4196558 2094342 2094342 defendant Colman John gent 600587 600587 Colman, John, of Petham, gent 1
4314991 2135355 2135355 defendant Cloke Christopher yeoman 600587 600587 Cloke, Christopher, of Petham, yeoman 0
4362409 2151606 2151606 defendant Maxsted William yeoman 600587 600587 Maxsted, William, of Petham, yeoman 0
4369342 2154100 2154100 defendant Cloke Christopher husbandman 600587 600587 Cloke, Christopher, of Petham, husbandman 0
4375663 2156356 2156356 defendant Harte Thomas tailor 600587 600587 Harte, Thomas, of Petham, tailor 0
4404492 2166070 2166070 defendant Harte Thomas tailor 600587 600587 Harte, Thomas, of Petham, tailor 0
4456886 2187165 2187165 defendant Poleyn John   600587 600587 Poleyn, John, of Petham 0
4475131 2192893 2192893 defendant Dawe Roger   600587 600587 Dawe, Roger, of Petham 0
4488787 2197214 2197214 plaintiff D--- Thomas   600587 600587 D---, Thomas, of Petham 5
4488802 2197217 2197217 defendant Doul Thomas   600587 600587 Doul, Thomas, of Petham 4
4488813 2197217 2197217 defendant Wyght Richard   600587 600587 Wyght, Richard, of Petham 15
4499942 2200618 2200618 defendant Raulyn Roger   600587 600587 Raulyn, Roger, of Petham 0
4503836 2201761 2201761 defendant Colkyn John   600587 600587 Colkyn, John, of Petham 0
4517360 2205832 2205832 defendant Staple John   600587 600587 Staple, John, of Petham 0
4590848 2228487 2228487 defendant Boydon Hamon   600587 600587 Boydon, Hamon, of Petham 0
4626940 2239373 2239373 plaintiff Raulyn Sarah   600587 600587 Raulyn, Sarah, of Petham, formerly wife of Roger 0
4640315 2243282 2243282 defendant Gundy John   600587 600587 Gundy, John, of Petham 1
4647334 2245275 2245275 defendant Tropham William   600587 600587 Tropham, William, of Petham 0
4702493 2266193 2266193 plaintiff Halk Sampson   600587 600587 Halk, Sampson, of Petham 0
4702494 2266193 2266193 plaintiff Grym Robert   600587 600587 Grym, Robert, of Petham 1
4708981 2268178 2268178 defendant Lukke Richard husbandman 600587 600587 Lukke, Richard, of Petham, husbandman 2
4726583 2273590 2273590 plaintiff Hall Sampson   600587 600587 Hall, Sampson, of Petham 0
4726584 2273590 2273590 plaintiff Grym Robert   600587 600587 Grym, Robert, of Petham 1
4742834 2278412 2278412 defendant Scot John husbandman 600587 600587 Scot, John, of Petham, husbandman 0
4742835 2278412 2278412 defendant Scot Sampson husbandman 600587 600587 Scot, Sampson, of Petham, husbandman 1
4761236 2283862 2283862 defendant Aleyn Robert laborer 600587 600587 Aleyn, Robert, of Petham, laborer 0
4764060 2284747 2284747 defendant Carpenter Thomas husbandman 600587 600587 Carpenter, Thomas, of Petham, husbandman 0
4784301 2291088 2291088 defendant Coppe Robert laborer 600587 600587 Coppe, Robert, of Petham, laborer 1
4787882 2292276 2292276 defendant Doull William husbandman 600587 600587 Doull, William, of Petham, husbandman 0
4870727 2317822 2317822 defendant Maghefeld John farmer 600587 600587 Maghefeld, John, of Petham, farmer 0
4884247 2321981 2321981 defendant Fleccher Richard husbandman 600587 600587 Fleccher, Richard, of Petham, husbandman 2
4894505 2324955 2324955 defendant Penylond Nicholas husbandman 600587 600587 Penylond, Nicholas, of Petham, husbandman 1
4902211 2327299 2327299 defendant Penylond Nicholas husbandman 600587 600587 Penylond, Nicholas, of Petham, husbandman 0
4915270 2331281 2331281 defendant Beek Peter husbandman 600587 600587 Beek, Peter, of Petham, husbandman 0
4915271 2331281 2331281 defendant Halkare Robert husbandman 600587 600587 Halkare, Robert, of Petham, husbandman 1
4918765 2332381 2332381 defendant Moynne Nicholas laborer 600587 600587 Moynne, Nicholas, of Petham, laborer 3
4925529 2334418 2334418 defendant Beek Peter husbandman 600587 600587 Beek, Peter, of Petham, husbandman 0
4925530 2334418 2334418 defendant Halke or Hawe John husbandman 600587 600587 Halke or Hawe, John, of Petham, husbandman 1
4939137 2338627 2338627 defendant Halke John husbandman 600587 600587 Halke, John, of Petham, husbandman 0
4943555 2339955 2339955 defendant Hamond John husbandman 600587 600587 Hamond, John, of Petham, husbandman 0
4994978 2355357 2355357 defendant Kenton William laborer 600587 600587 Kenton, William, of Petham, laborer 0
5005251 2358433 2358433 defendant Halke John husbandman 600587 600587 Halke, John, of Petham, husbandman 1
5145711 2399889 2399889 defendant Renkyn Robert husbandman 600587 600587 Renkyn, Robert, of Petham, husbandman 0
5166052 2405815 2405815 defendant Roukyn Roger husbandman 600587 600587 Roukyn, Roger, of Petham, husbandman 0
5173093 2407839 2407839 defendant Sadeler John yeoman 600587 600587 Sadeler, John, of Petham, yeoman 1
5173095 2407839 2407839 defendant Adam Thomas yeoman 600587 600587 Adam, Thomas, of Petham, yeoman 3
5173096 2407839 2407839 defendant Wyse Thomas yeoman 600587 600587 Wyse, Thomas, of Petham, yeoman 4
5319790 2451012 2451012 defendant Taillour William husbandman 600587 600587 Taillour, William, of Petham, husbandman 0
5319791 2451012 2451012 defendant Cullyng Edmund husbandman 600587 600587 Cullyng, Edmund, of Petham, husbandman 1
5353676 2461216 2461216 defendant Neell John yeoman 600587 600587 Neell, John, of Petham, yeoman 0
5405183 2476566 2476566 defendant Stretende Thomas   600587 600587 Stretende, Thomas, of Petham, parish clerk 0
5418268 2480390 2480390 defendant Stretende Thomas   600587 600587 Stretende, Thomas, of Petham, parish clerk 0
5436152 2485750 2485750 defendant Stretende Thomas   600587 600587 Stretende, Thomas, of Petham, parish clerk 0
5459192 2492652 2492652 defendant Rose Nichola widow 600587 600587 Rose, Nichola, of Petham, widow 1
5459193 2492652 2492652 defendant Bere Thomas laborer 600587 600587 Bere, Thomas, of Petham, laborer 2
5470848 2496209 2496209 defendant Beer Thomas laborer 600587 600587 Beer, Thomas, of Petham, laborer 3
5472400 2496711 2496711 defendant Baifeld Nicholas husbandman 600587 600587 Baifeld, Nicholas, of Petham, husbandman 0
5472750 2496817 2496817 defendant Stowephelde John yeoman 600587 600587 Stowephelde, John, of Petham, yeoman 3
5482303 2499651 2499651 defendant Curtes John husbandman 600587 600587 Curtes, John, of Petham, husbandman 0
5484352 2500241 2500241 plaintiff Meredith Morgan   600587 600587 Meredith, Morgan, of Petham, esq, administrators of 0
5484354 2500241 2500241 defendant Stowephelde John yeoman 600587 600587 Stowephelde, John, of Petham, yeoman 0
5547488 2519284 2519284 defendant Lotte John butcher 600587 600587 Lotte, John, of Petham, butcher 0
5610241 2546917 2546917 plaintiff Jakyn Richard   600587 600587 Jakyn, Richard, of Petham 1
5617393 2549258 2549258 defendant Colle Thomas   600587 600587 Colle, Thomas, of Petham 9
5629602 2553246 2553246 defendant Coppe Robert farmer 600587 600587 Coppe, Robert, of Petham, farmer 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);