names

80 rows where place_id = 587672

✎ 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
3592099 1865144 1865144 defendant Boneham William clerk 587672 587672 Boneham, William, of Horsted, clerk 1
3592101 1865145 1865145 defendant Boneham William clerk 587672 587672 Boneham, William, of Horsted, clerk 0
3614202 1872110 1872110 defendant Bonn or Boun of William clerk 587672 587672 Bonn or Boun, of William, of Horsted, clerk 0
3617098 1872971 1872971 defendant Ides Robert husbandman 587672 587672 Ides, Robert, of Horsted, husbandman 3
3619653 1873715 1873715 defendant Bonam William clerk 587672 587672 Bonam, William, of Horsted, clerk 0
3619654 1873715 1873715 defendant Mowetyng William husbandman 587672 587672 Mowetyng, William, of Horsted, husbandman 1
3619655 1873715 1873715 defendant Mowetyng John husbandman 587672 587672 Mowetyng, John, of Horsted, husbandman 2
3648310 1909873 1909873 plaintiff Mowtyng Henry   587672 587672 Mowtyng, Henry, of Horsted 0
3648311 1909873 1909873 defendant Pyghlyng John, junior husbandman 587672 587672 Pyghlyng, John, junior, of Horsted, husbandman 0
3738186 1938156 1938156 defendant Pytelyng John miller 587672 587672 Pytelyng, John, of Horsted, miller 2
3766444 1947163 1947163 defendant Pytlyng John miller 587672 587672 Pytlyng, John, of Horsted, miller 0
3810478 1961171 1961171 defendant Salle John husbandman 587672 587672 Salle, John, of Horsted, husbandman 0
3820365 1964248 1964248 defendant Harvy William yeoman 587672 587672 Harvy, William, of Horsted, yeoman 1
3836374 1969285 1969285 plaintiff Reve John husbandman 587672 587672 Reve, John, of Horsted, husbandman 0
3842429 1971166 1971166 defendant Sall John   587672 587672 (Sall, John, of Horsted, worsted weaver 2
3876098 1982256 1982256 defendant Piklyng John husbandman 587672 587672 Piklyng, John, of Horsted, husbandman 2
3884013 1984922 1984922 defendant Knoke Peter smith 587672 587672 Knoke, Peter, of Horsted, smith 4
3915757 1995647 1995647 defendant Russhebroke Joan widow 587672 587672 Russhebroke, Joan, of Horsted, widow 3
3956101 2009204 2009204 defendant Tankerell Roger ironfounder 587672 587672 Tankerell, Roger, of Horsted, ironfounder 0
3965427 2012520 2012520 defendant Palmer Philip grocer 587672 587672 Palmer, Philip, of Horsted, grocer 0
3984240 2019131 2019131 defendant Dixson Richard clerk 587672 587672 Dixson, Richard, of Horsted, clerk 3
4048041 2041740 2041740 defendant Palmer Philip yeoman 587672 587672 Palmer, Philip, of Horsted, yeoman 3
4050108 2042469 2042469 plaintiff Ward Richard gent 587672 587672 Ward, Richard, of Horsted, gent 0
4050154 2042486 2042486 plaintiff Warde Richard gent 587672 587672 Warde, Richard, of Horsted, gent 0
4087432 2055798 2055798 defendant Palmer Philip grocer 587672 587672 Palmer, Philip, of Horsted, grocer 2
4088824 2056303 2056303 defendant Beane John husbandman 587672 587672 Beane, John, of Horsted, husbandman 3
4088826 2056303 2056303 defendant Hull Thomas miller 587672 587672 Hull, Thomas, of Horsted, miller 5
4129247 2070761 2070761 defendant Graye Thomas husbandman 587672 587672 Graye, Thomas, of Horsted, husbandman 0
4141225 2075090 2075090 defendant Pyghtlyn Richard yeoman 587672 587672 Pyghtlyn, Richard, of Horsted, yeoman 1
4141226 2075090 2075090 defendant Rose Walter yeoman 587672 587672 Rose, Walter, of Horsted, yeoman 2
4145386 2076544 2076544 defendant Dennys Thomas turner 587672 587672 Dennys, Thomas, of Horsted, turner 1
4224645 2104095 2104095 defendant Ward Robert yeoman 587672 587672 Ward, Robert, of Horsted, yeoman 0
4224646 2104095 2104095 defendant Malle Robert yeoman 587672 587672 Malle, Robert, of Horsted, yeoman 1
4224647 2104095 2104095 defendant Woodcock Richard husbandman 587672 587672 Woodcock, Richard, of Horsted, husbandman 2
4224648 2104095 2104095 defendant Cullyer Edmund yeoman 587672 587672 Cullyer, Edmund, of Horsted, yeoman 3
4250903 2113280 2113280 defendant Browne William miller 587672 587672 Browne, William, of Horsted, miller 3
4258643 2115852 2115852 defendant Kynge Thomas yeoman 587672 587672 Kynge, Thomas, of Horsted, yeoman 2
4258902 2115948 2115948 defendant Shreve Henry   587672 587672 Shreve, Henry, of Horsted 6
4283740 2124224 2124224 defendant Same John butcher 587672 587672 Same, John, of Horsted, butcher 0
4330093 2140363 2140363 defendant Gestlynge John gent 587672 587672 Gestlynge, John, of Horsted, gent 2
4624345 2238593 2238593 defendant Holme John   587672 587672 Holme, John, of Horsted 2
4911054 2329969 2329969 defendant Reve John yeoman 587672 587672 Reve, John, of Horsted, yeoman 0
4911681 2330155 2330155 defendant Clerk John   587672 587672 Clerk, John, of Horsted, parson 0
4976270 2349854 2349854 defendant Dowe John sawyer 587672 587672 Dowe, John, of Horsted, sawyer 1
4976273 2349855 2349855 defendant Dowe John sawyer 587672 587672 Dowe, John, of Horsted, sawyer 1
4979200 2350738 2350738 defendant Dowe John sawyer 587672 587672 Dowe, John, of Horsted, sawyer 0
4995344 2355452 2355452 defendant Cay John husbandman 587672 587672 Cay, John, of Horsted, husbandman 1
5002978 2357774 2357774 defendant Reve John weaver 587672 587672 Reve, John, of Horsted, weaver 0
5006564 2358820 2358820 defendant Berd John husbandman 587672 587672 Berd, John, of Horsted, husbandman 1
5008575 2359401 2359401 defendant Clerk John   587672 587672 Clerk, John, of Horsted, parson & clerk 0
5017779 2362078 2362078 plaintiff Reve John   587672 587672 Reve, John, of Horsted 1
5017780 2362078 2362078 defendant Deye Robert husbandman 587672 587672 Deye, Robert, of Horsted, husbandman 0
5080761 2380736 2380736 defendant Clerk Peter husbandman 587672 587672 Clerk, Peter, of Horsted, husbandman 1
5092236 2384111 2384111 defendant Kay John husbandman 587672 587672 Kay, John, of Horsted, husbandman 1
5148397 2400664 2400664 defendant Roper Richard laborer 587672 587672 Roper, Richard, of Horsted, laborer 15
5158710 2403668 2403668 plaintiff Randolf John   587672 587672 Randolf, John, of Horsted 0
5160547 2404175 2404175 defendant Smyth Simon   587672 587672 Smyth, Simon, of Horsted, pedlar 2
5167685 2406269 2406269 defendant Roper Richard laborer 587672 587672 Roper, Richard, of Horsted, laborer 15
5175314 2408471 2408471 defendant Smyth Simon   587672 587672 Smyth, Simon, of Horsted, pedlar 2
5253242 2431112 2431112 defendant Woderove John husbandman 587672 587672 Woderove, John, of Horsted, husbandman 0
5279209 2439017 2439017 defendant Tayllour William tailor 587672 587672 Tayllour, William, of Horsted, tailor 1
5279410 2439063 2439063 defendant Woderove John, senior miller 587672 587672 Woderove, John, senior, of Horsted, miller 0
5279411 2439063 2439063 defendant Woderove John, junior husbandman 587672 587672 Woderove, John, junior, of Horsted, husbandman 1
5297235 2444187 2444187 defendant Lenedy John fuller 587672 587672 Lenedy, John, of Horsted, fuller 1
5297238 2444187 2444187 defendant Smyth Simon husbandman 587672 587672 Smyth, Simon, of Horsted, husbandman 4
5313314 2449020 2449020 defendant Woderove John yeoman 587672 587672 Woderove, John, of Horsted, yeoman 2
5319831 2451024 2451024 defendant Freston Richard gent 587672 587672 Freston, Richard, of Horsted, gent 0
5333395 2455057 2455057 defendant Canon JOhn husbandman 587672 587672 Canon, JOhn, of Horsted, husbandman 17
5348242 2459596 2459596 defendant Lenedy or Levedy John husbandman 587672 587672 Lenedy or Levedy, John, of Horsted, husbandman 2
5350170 2460174 2460174 defendant Ginson Robert husbandman 587672 587672 Ginson, Robert, of Horsted, husbandman 1
5355001 2461633 2461633 defendant Berd Henry yeoman 587672 587672 Berd, Henry, of Horsted, yeoman 0
5359399 2462976 2462976 defendant Smyth Simon gusbandman 587672 587672 Smyth, Simon, of Horsted, gusbandman 2
5372472 2466986 2466986 defendant Bowere John husbandman 587672 587672 Bowere, John, of Horsted, husbandman 0
5377452 2468531 2468531 defendant Denham Stephen chapman 587672 587672 Denham, Stephen, of Horsted, chapman 1
5391318 2472598 2472598 defendant Aleyn Nicholas husbandman 587672 587672 Aleyn, Nicholas, of Horsted, husbandman 1
5404269 2476298 2476298 defendant Aleyn Nicholas husbandman 587672 587672 Aleyn, Nicholas, of Horsted, husbandman 1
5495220 2503465 2503465 defendant Levedy or Lenedy Agnes widow 587672 587672 Levedy or Lenedy, Agnes, of Horsted, widow 0
5514199 2509285 2509285 defendant Houchons Peter husbandman 587672 587672 Houchons, Peter, of Horsted, husbandman 0
5590649 2532045 2532045 defendant Mowetyng Henry husbandman 587672 587672 Mowetyng, Henry, of Horsted, husbandman 1
5620500 2550271 2550271 defendant Payn John   587672 587672 Payn, John, of Horsted 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);