names

34 rows where place_id = 688403

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4075574 2051567 2051567 plaintiff Ryland William gent 688403 688403 Ryland, William, of Folkestone, gent 0
4403482 2165736 2165736 defendant Jenkyn Robert yeoman 688403 688403 Jenkyn, Robert, of Folkestone, yeoman 0
4707301 2267661 2267661 plaintiff Mellere John (legal representative) 688403 688403 Mellere, John, of Folkestone, executor of 0
4707304 2267662 2267662 plaintiff Mellere John (legal representative) 688403 688403 Mellere, John, of Folkestone, executor of 0
4709969 2268473 2268473 defendant Hayward William laborer 688403 688403 Hayward, William, of Folkestone, laborer 0
4712402 2269195 2269195 defendant Hert Thomas yeoman 688403 688403 Hert, Thomas, of Folkestone, yeoman 0
4839935 2308403 2308403 defendant Lote William shipman 688403 688403 Lote, William, of Folkestone, shipman 0
4840395 2308538 2308538 defendant Mason Andrew   688403 688403 Mason, Andrew, of Folkestone, mason 0
4840396 2308538 2308538 defendant Hert John husbandman 688403 688403 Hert, John, of Folkestone, husbandman 1
4840397 2308538 2308538 defendant Masoon Alice widow 688403 688403 Masoon, Alice, of Folkestone, widow 2
4986012 2352734 2352734 defendant Nolde William laborer 688403 688403 Nolde, William, of Folkestone, laborer 6
5003320 2357870 2357870 defendant Reede William yeoman 688403 688403 Reede, William, of Folkestone, yeoman 0
5003322 2357870 2357870 defendant Aleyn Richard husbandman 688403 688403 Aleyn, Richard, of Folkestone, husbandman 2
5006058 2358658 2358658 defendant Golston John   688403 688403 Golston, John, of Folkestone, wax chandler 0
5006059 2358658 2358658 defendant Everard John weaver 688403 688403 Everard, John, of Folkestone, weaver 1
5007754 2359160 2359160 defendant Smyth John laborer 688403 688403 Smyth, John, of Folkestone, laborer 1
5147202 2400321 2400321 defendant Goldwort John husbandman 688403 688403 Goldwort, John, of Folkestone, husbandman 2
5159535 2403905 2403905 defendant Swetton John draper & tailor 688403 688403 Swetton, John, of Folkestone, draper & tailor 1
5171019 2407248 2407248 defendant Bukle William husbandman 688403 688403 Bukle, William, of Folkestone, husbandman 1
5174632 2408281 2408281 defendant Swetton John draper & tailor 688403 688403 Swetton, John, of Folkestone, draper & tailor 1
5189215 2412576 2412576 defendant Bukle William husbandman 688403 688403 Bukle, William, of Folkestone, husbandman 1
5192948 2413665 2413665 defendant Brette Thomas barber 688403 688403 Brette, Thomas, of Folkestone, barber 0
5207939 2418056 2418056 defendant Brette Thomas barber 688403 688403 Brette, Thomas, of Folkestone, barber 0
5207941 2418056 2418056 defendant Shotyer John laborer 688403 688403 Shotyer, John, of Folkestone, laborer 2
5210929 2418928 2418928 defendant (not given) Thomas prior of Banys 688403 688403 Banys, Thomas, of Folkestone, prior of the house of the BM & St Eanswithe 0
5269379 2436140 2436140 defendant (not given) Thomas prior of Banys 688403 688403 Banys, Thomas, of Folkestone, prior of the church of Sts Mary & Eauswithe 0
5364981 2464719 2464719 plaintiff (not given) Thomas prior of Banys 688403 688403 Banys, Thomas, of Folkestone, prior of the House & church of Blessed Mary & St Enswithe 0
5364983 2464719 2464719 defendant Swayne Thomas husbandman 688403 688403 Swayne, Thomas, of Folkestone, husbandman 1
5364984 2464719 2464719 defendant Holden Thomas yeoman 688403 688403 Holden, Thomas, of Folkestone, yeoman 2
5381905 2469879 2469879 defendant Stok Joan   688403 688403 Stok, Joan, of Folkestone, widow, formerly wife of William 1
5436161 2485753 2485753 defendant Stok Simon a husbandman 688403 688403 Stok, Simon a, of Folkestone, husbandman 0
5438692 2486505 2486505 plaintiff Thorold Philip (legal representative) 688403 688403 Thorold, Philip, of Folkestone, executors of 0
5468546 2495532 2495532 defendant Taillour William yeoman 688403 688403 Taillour, William, of Folkestone, yeoman 0
5470397 2496066 2496066 defendant (not given) Thomas prior of Banys 688403 688403 Banys, Thomas, of Folkestone, prior of the house or priory of the BM & St Eanswith 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);