names

49 rows where place_id = 639665

✎ 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
3850283 1973675 1973675 defendant Agrene Ralph yeoman 639665 639665 Agrene, Ralph, of Partney, yeoman 0
3856888 1975784 1975784 defendant Grene Ralph chapman 639665 639665 Grene, Ralph, of Partney, chapman 0
3865137 1978542 1978542 defendant Agrene Ralph yeoman 639665 639665 Agrene, Ralph, of Partney, yeoman 0
3876406 1982354 1982354 defendant Rawlynson Walter laborer 639665 639665 Rawlynson, Walter, of Partney, laborer 1
3951978 2007755 2007755 defendant Taylor Thomas husbandman 639665 639665 Taylor, Thomas, of Partney, husbandman 1
4012495 2029190 2029190 defendant Grene John yeoman 639665 639665 Grene, John, of Partney, yeoman 0
4033407 2036602 2036602 defendant Wylkynson John husbandman 639665 639665 Wylkynson, John, of Partney, husbandman 0
4041272 2039368 2039368 defendant Skypwith John gent or yeoman 639665 639665 Skypwith, John, of Partney, gent or yeoman 0
4103806 2061634 2061634 defendant Grene Ralph yeoman 639665 639665 Grene, Ralph, of Partney, yeoman 2
4103810 2061635 2061635 defendant Grene Ralph yeoman 639665 639665 Grene, Ralph, of Partney, yeoman 2
4118275 2066823 2066823 defendant Grene Ralph yeoman 639665 639665 Grene, Ralph, of Partney, yeoman 1
4119435 2067243 2067243 defendant Modye William yeoman 639665 639665 Modye, William, of Partney, yeoman 0
4119437 2067244 2067244 defendant Moodye William yeoman 639665 639665 Moodye, William, of Partney, yeoman 0
4119704 2067334 2067334 defendant Buck John butcher 639665 639665 Buck, John, of Partney, butcher 0
4134125 2072529 2072529 defendant Grene alias Burden Ralph yeoman 639665 639665 Grene alias Burden, Ralph, of Partney, yeoman 0
4134127 2072530 2072530 defendant Grene Ralph gent 639665 639665 Grene, Ralph, of Partney, gent 0
4151290 2078574 2078574 defendant Bucke John butcher 639665 639665 Bucke, John, of Partney, butcher 0
4158112 2080905 2080905 defendant Grene alias Burden Ralph yeoman 639665 639665 Grene alias Burden, Ralph, of Partney, yeoman 0
4158116 2080907 2080907 defendant Greene Ralph gent 639665 639665 Greene, Ralph, of Partney, gent 0
4167372 2084088 2084088 defendant Grene alias Burden Ralph gent 639665 639665 Grene alias Burden, Ralph, of Partney, gent 0
4173437 2086166 2086166 defendant Palfrayman Thomas yeoman 639665 639665 Palfrayman, Thomas, of Partney, yeoman 1
4173743 2086273 2086273 defendant Palfreman Thomas yeoman 639665 639665 Palfreman, Thomas, of Partney, yeoman 0
4179318 2088241 2088241 defendant Grene alias Burden Ralph yeoman 639665 639665 Grene alias Burden, Ralph, of Partney, yeoman 0
4179323 2088242 2088242 defendant Grene alias Burden Ralph yeoman 639665 639665 Grene alias Burden, Ralph, of Partney, yeoman 0
4186480 2090757 2090757 defendant Richardson Richard yeoman 639665 639665 Richardson, Richard, of Partney, yeoman 0
4201728 2096150 2096150 defendant Anderson William husbandman 639665 639665 Anderson, William, of Partney, husbandman 0
4233770 2107336 2107336 defendant Baynes Thomas tailor 639665 639665 Baynes, Thomas, of Partney, or of Ingoldmells, tailor 0
4275162 2121260 2121260 defendant Lingard Isaac yeoman 639665 639665 Lingard, Isaac, of Partney, yeoman 1
4275163 2121260 2121260 defendant Francklynge Richard cordwainer 639665 639665 Francklynge, Richard, of Partney, cordwainer 2
4283469 2124124 2124124 defendant Burrell William butcher 639665 639665 Burrell, William, of Partney, butcher 0
4283470 2124124 2124124 defendant Bucke John butcher 639665 639665 Bucke, John, of Partney, butcher 1
4283475 2124125 2124125 defendant Wood John butcher 639665 639665 Wood, John, of Partney, butcher 1
4283479 2124126 2124126 defendant Moody William yeoman 639665 639665 Moody, William, of Partney, yeoman 2
4363084 2151860 2151860 defendant Pickwell Anthony miller 639665 639665 Pickwell, Anthony, of Partney, yeoman, or of Clathrope, miller 0
4367532 2153443 2153443 defendant Anderson Robert tailor 639665 639665 Anderson, Robert, of Partney, tailor 0
4371917 2155016 2155016 defendant Wytton Thomas laborer 639665 639665 Wytton, Thomas, of Partney, laborer 1
4371918 2155016 2155016 defendant Stapleton Robert laborer 639665 639665 Stapleton, Robert, of Partney, laborer 2
4371927 2155020 2155020 defendant Wytton Thomas laborer 639665 639665 Wytton, Thomas, of Partney, laborer 1
4371928 2155020 2155020 defendant Stapleton Robert laborer 639665 639665 Stapleton, Robert, of Partney, laborer 2
4372002 2155048 2155048 defendant Cowper Roger chapman 639665 639665 Cowper, Roger, of Partney, chapman 1
4378772 2157482 2157482 defendant Burwell Thomas butcher 639665 639665 Burwell, Thomas, of Partney, butcher 0
4862589 2315285 2315285 defendant Pynke John barber 639665 639665 Pynke, John, of Partney, barber 0
4909647 2329547 2329547 plaintiff Bynbrok Richard   639665 639665 Bynbrok, Richard, of Partney 1
5061337 2374973 2374973 defendant Wynter William courser 639665 639665 Wynter, William, of Partney, courser 2
5332177 2454699 2454699 defendant Combyrton Thomas yeoman 639665 639665 Combyrton, Thomas, of Partney, yeoman 0
5332178 2454699 2454699 defendant Howe Thomas husbandman 639665 639665 Howe, Thomas, of Partney, husbandman 1
5332179 2454699 2454699 defendant Burnhows John husbandman 639665 639665 Burnhows, John, of Partney, husbandman 2
5530892 2514178 2514178 defendant Makefelde John husbandman 639665 639665 Makefelde, John, of Partney, husbandman 0
5557897 2522263 2522263 defendant Tetnay William butcher 639665 639665 Tetnay, William, of Partney, butcher 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);