names

72 rows where place_id = 762298

✎ 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
3600099 1867682 1867682 defendant Packer John husbandman 762298 762298 Packer, John, of Chilmelegh Maner, husbandman 0
4486519 2196492 2196492 plaintiff Saltere John   762298 762298 Saltere, John, of Chilmelegh 0
4526623 2208604 2208604 defendant Salter John   762298 762298 Salter, John, of Chilmelegh 0
4526624 2208604 2208604 defendant Cokkeshead William   762298 762298 Cokkeshead, William, of Chilmelegh 1
4530432 2209811 2209811 defendant Salter John   762298 762298 Salter, John, of Chilmelegh 0
4533859 2210860 2210860 defendant Philipp Henry   762298 762298 Philipp, Henry, of Chilmelegh 0
4540248 2212851 2212851 defendant Salter John   762298 762298 Salter, John, of Chilmelegh 0
4554419 2217314 2217314 defendant Salter John   762298 762298 Salter, John, of Chilmelegh 0
4580876 2225500 2225500 defendant Beare John   762298 762298 Beare, John, of Chilmelegh 0
4585074 2226753 2226753 defendant Salter John   762298 762298 Salter, John, of Chilmelegh 0
4585171 2226784 2226784 defendant Saltere John   762298 762298 Saltere, John, of Chilmelegh 0
4639315 2243013 2243013 defendant Lane William   762298 762298 Lane, William, of Chilmelegh, parson 4
4656416 2247899 2247899 defendant Monlond William husbandman 762298 762298 Monlond, William, of Chilmelegh, husbandman 1
4657753 2248307 2248307 defendant Isbell William yeoman 762298 762298 Isbell, William, of Chilmelegh,, yeoman 3
4664073 2250252 2250252 defendant Rewe John fisher 762298 762298 Rewe, John, of Chilmelegh, fisher 0
4664074 2250252 2250252 defendant Rewe Robert husbandman 762298 762298 Rewe, Robert, of Chilmelegh, husbandman 1
4675512 2257952 2257952 defendant Beare William laborer 762298 762298 Beare, William, of Chilmelegh, laborer 2
4677132 2258464 2258464 defendant Prente John   762298 762298 Prente, John, of Chilmelegh, bailiff 1
4727405 2273817 2273817 defendant Degh William laborer 762298 762298 Degh, William, of Chilmelegh, laborer 2
4784435 2291136 2291136 defendant Dolyn John shoemaker 762298 762298 Dolyn, John, of Chilmelegh, shoemaker 0
4784436 2291136 2291136 defendant Dobyn John Jonysservant shoemaker 762298 762298 Dobyn, John Jonysservant, of Chilmelegh, shoemaker 1
4784437 2291136 2291136 defendant Canne John shoemaker 762298 762298 Canne, John, of Chilmelegh, shoemaker 2
4784438 2291136 2291136 defendant Hill Thomas laborer 762298 762298 Hill, Thomas, of Chilmelegh, laborer 3
4795150 2294630 2294630 defendant Payneme Joan widow 762298 762298 Payneme, Joan, of Chilmelegh, widow 0
4796187 2294959 2294959 defendant Martyn Thomas saddler 762298 762298 Martyn, Thomas, of Chilmelegh, saddler 0
4825544 2304030 2304030 defendant Prous John parker 762298 762298 Prous, John, of Chilmelegh, parker 2
4859090 2314220 2314220 defendant Cornyssh Roger tailor 762298 762298 together with Cornyssh, Roger, of Chilmelegh, tailor 4
4859091 2314220 2314220 defendant Panymede John husbandman 762298 762298 Panymede, John, of Chilmelegh, husbandman 5
4919409 2332581 2332581 defendant Pleymark John clerk 762298 762298 Pleymark, John, of Chilmelegh, clerk 0
4919410 2332581 2332581 defendant Cornysshe Roger tailor 762298 762298 Cornysshe, Roger, of Chilmelegh, tailor 1
4951948 2342556 2342556 defendant Hore John chapman 762298 762298 Hore, John, of Chilmelegh, chapman 0
4951949 2342556 2342556 defendant Trekys Thomas, senior smith 762298 762298 Trekys, Thomas, senior, of Chilmelegh, smith 1
4951950 2342556 2342556 defendant Trekys Thomas, junior smith 762298 762298 Trekys, Thomas, junior, of Chilmelegh, smith 2
4951951 2342556 2342556 defendant Trekys William butcher 762298 762298 Trekys, William, of Chilmelegh, butcher 3
4951952 2342556 2342556 defendant Trekys David   762298 762298 Trekys, David, of Chilmelegh, groom 4
4970455 2348109 2348109 defendant Hora John chapman 762298 762298 Hora, John, of Chilmelegh, chapman 4
5038953 2368296 2368296 defendant Cole John mercer 762298 762298 Cole, John, of Chilmelegh, mercer 0
5128955 2394953 2394953 defendant Noreys John yeoman 762298 762298 Noreys, John, of Chilmelegh, yeoman 1
5128977 2394960 2394960 defendant Noreys John yeoman 762298 762298 Noreys, John, of Chilmelegh, yeoman 1
5153983 2402325 2402325 defendant Dobbe Robert gent 762298 762298 Dobbe, Robert, of Chilmelegh, gent 0
5171216 2407305 2407305 defendant Dobbe Robert gent 762298 762298 Dobbe, Robert, of Chilmelegh, gent 0
5188278 2412283 2412283 defendant Lechelond John, sen husbandman 762298 762298 Lechelond, John, sen, of Chilmelegh, husbandman 2
5188286 2412284 2412284 defendant Lechelond John, sen husbandman 762298 762298 Lechelond, John, sen, of Chilmelegh, husbandman 4
5189499 2412668 2412668 defendant Dobbe Robert gent 762298 762298 Dobbe, Robert, of Chilmelegh, gent 0
5189501 2412669 2412669 defendant Dobbe Robert gent 762298 762298 Dobbe, Robert, of Chilmelegh, gent 0
5205976 2417480 2417480 defendant Lechelonc John, sen husbandman 762298 762298 Lechelonc, John, sen, of Chilmelegh, husbandman 2
5221456 2421971 2421971 defendant Lampray William butcher 762298 762298 Lampray, William, of Chilmelegh, butcher 0
5221458 2421972 2421972 defendant Lampray William butcher 762298 762298 Lampray, William, of Chilmelegh, butcher 0
5225194 2423041 2423041 defendant Hokker Richard yeoman 762298 762298 Hokker, Richard, of Chilmelegh, yeoman 0
5230123 2424426 2424426 defendant Dobbe Robert gent 762298 762298 Dobbe, Robert, of Chilmelegh, gent 1
5269745 2436261 2436261 defendant Lechelond John, junior husbandman 762298 762298 Lechelond, John, junior, of Chilmelegh, husbandman 0
5272925 2437155 2437155 defendant Dobbe William husbandman 762298 762298 Dobbe, William, of Chilmelegh, husbandman 0
5285841 2440885 2440885 defendant Dobbe Robert gent 762298 762298 Dobbe, Robert, of Chilmelegh, gent 0
5285842 2440885 2440885 defendant Torner William husbandman 762298 762298 Torner, William, of Chilmelegh, husbandman 1
5297070 2444139 2444139 defendant Heydon John (legal representative) 762298 762298 Heydon, John, of Chilmelegh, administratrix of 4
5297071 2444139 2444139 defendant Heydon Agnes widow 762298 762298 Heydon, Agnes, of Chilmelegh, widow 5
5301841 2445507 2445507 defendant Doble Hugh yeoman 762298 762298 Doble, Hugh, of Chilmelegh, yeoman 0
5301843 2445507 2445507 defendant Lanpray Agnes widow 762298 762298 Lanpray, Agnes, of Chilmelegh, widow 2
5311622 2448498 2448498 defendant London Lawrence chaplain 762298 762298 London, Lawrence, of Chilmelegh, chaplain 0
5316824 2450118 2450118 defendant Dobbe Hugh gent 762298 762298 Dobbe, Hugh, of Chilmelegh, gent 0
5324070 2452286 2452286 defendant Calley Robert yeoman 762298 762298 Calley, Robert, of Chilmelegh, yeoman 1
5335336 2455639 2455639 defendant Cokerham John husbandman 762298 762298 Cokerham, John, of Chilmelegh, husbandman 0
5351627 2460608 2460608 defendant Cadbury William husbandman 762298 762298 Cadbury, William, of Chilmelegh, husbandman 0
5402480 2475779 2475779 defendant Norys William husbandman 762298 762298 Norys, William, of Chilmelegh, husbandman 0
5425814 2482687 2482687 defendant Alyn John husbandman 762298 762298 Alyn, John, of Chilmelegh, husbandman 1
5509261 2507750 2507750 defendant Cleyford John husbandman 762298 762298 Cleyford, John, of Chilmelegh, husbandman 14
5509262 2507750 2507750 defendant Mersford Richard husbandman 762298 762298 Mersford, Richard, of Chilmelegh, husbandman 15
5509263 2507750 2507750 defendant Bunston William, junior husbandman 762298 762298 Bunston, William, junior, of Chilmelegh, husbandman 16
5530157 2513938 2513938 defendant Wyllesdon William   762298 762298 Wyllesdon, William, of Chilmelegh, franklin 0
5530158 2513938 2513938 defendant Fyssher John   762298 762298 Fyssher, John, of Chilmelegh, groom 1
5531234 2514285 2514285 defendant Willesdon William   762298 762298 Willesdon, William, of Chilmelegh, franklin 0
5632481 2554194 2554194 defendant Wiche Roger mercer 762298 762298 Wiche, Roger, of Chilmelegh, mercer 6

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