names

62 rows where place_id = 588520

✎ 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
3594798 1866000 1866000 plaintiff Lematon Walter   588520 588520 Lematon, Walter, of Fylby 0
3594800 1866001 1866001 plaintiff Lematon Walter   588520 588520 Lematon, Walter, of Fylby 0
3608308 1870256 1870256 defendant Pykeryng John yeoman 588520 588520 Pykeryng, John, of Fylby, yeoman 0
3619989 1873823 1873823 defendant Hawe Walter yeoman 588520 588520 Hawe, Walter, of Fylby, yeoman 0
3622363 1874531 1874531 plaintiff Poytwyn Nicholas yeoman 588520 588520 Poytwyn, Nicholas, of Fylby, yeoman 0
3690470 1923186 1923186 defendant Cryton John butcher 588520 588520 Cryton, John, of Fylby, butcher 1
3706367 1928281 1928281 plaintiff Hunter William chaplain 588520 588520 Hunter, William, of Fylby, chaplain 0
3706368 1928281 1928281 plaintiff Osborn Alan   588520 588520 Osborn, Alan, of Fylby 1
3708924 1929082 1929082 defendant Havyn William husbandman 588520 588520 Havyn, William, of Fylby, husbandman 1
3764498 1946559 1946559 plaintiff Hunt William (legal representative) 588520 588520 Hunt, William, of Fylby, chaplain, executors of 0
3791176 1955072 1955072 defendant Lesyngham Robert husbandman 588520 588520 Lesyngham, Robert, of Fylby, husbandman 0
3791177 1955072 1955072 defendant Osburn Thomas husbandman 588520 588520 Osburn, Thomas, of Fylby, husbandman 1
3815256 1962687 1962687 defendant Garrard Elizabeth widow 588520 588520 Garrard, Elizabeth, of Fylby, widow 2
3874556 1981710 1981710 defendant Kubytt Margaret widow 588520 588520 Kubytt, Margaret, of Fylby, widow 0
3874557 1981710 1981710 defendant Love William husbandman 588520 588520 Love, William, of Fylby, husbandman 1
3878161 1982942 1982942 defendant Semere William clerk 588520 588520 Semere, William, of Fylby, clerk 4
3981427 2018122 2018122 defendant Berry John cordwainer 588520 588520 Berry, John, of Fylby, cordwainer 0
3990282 2021279 2021279 defendant Bery alias Shomaker John cordwainer 588520 588520 Bery alias Shomaker, John, of Fylby, cordwainer 1
4019078 2031562 2031562 plaintiff Warde Roger yeoman 588520 588520 Warde, Roger, of Fylby, yeoman 0
4063588 2047267 2047267 defendant Morris William husbandman 588520 588520 Morris, William, of Fylby, husbandman 0
4181234 2088915 2088915 defendant Callowe Christopher laborer 588520 588520 Callowe, Christopher, of Fylby, laborer 0
4257837 2115596 2115596 defendant Warde John, senior husbandman 588520 588520 Warde, John, senior, of Fylby, husbandman 0
4257838 2115596 2115596 defendant Leve or Love William, junior husbandman 588520 588520 Leve or Love, William, junior, of Fylby, husbandman 1
4285263 2124781 2124781 defendant Mathewes John, senior husbandman 588520 588520 Mathewes, John, senior, of Fylby, husbandman 0
4285264 2124781 2124781 defendant Loveledge Francis laborer 588520 588520 Loveledge, Francis, of Fylby, laborer 1
4285265 2124781 2124781 defendant Whelpesdale Henry husbandman 588520 588520 Whelpesdale, Henry, of Fylby, husbandman 2
4285267 2124781 2124781 defendant Jexe John husbandman 588520 588520 Jexe, John, of Fylby, husbandman 4
4287868 2125709 2125709 defendant Muntforth William yeoman 588520 588520 Muntforth, William, of Fylby, yeoman 0
4325746 2138988 2138988 defendant Mathewe John, senior husbandman 588520 588520 Mathewe, John, senior, of Fylby, husbandman 0
4326661 2139276 2139276 defendant Browne Benedict yeoman 588520 588520 Browne, Benedict, of Fylby, yeoman 0
4326662 2139276 2139276 defendant Bery William tailor 588520 588520 Bery, William, of Fylby, tailor 1
4338204 2143103 2143103 defendant Gymyngham Robert husbandman 588520 588520 Gymyngham, Robert, of Fylby, husbandman 1
4405396 2166384 2166384 defendant Munforth William weaver 588520 588520 Munforth, William, of Fylby, weaver 0
4405397 2166384 2166384 defendant Porter Edward husbandman 588520 588520 Porter, Edward, of Fylby, husbandman 1
4710368 2268597 2268597 plaintiff Pykeryng William   588520 588520 Pykeryng, William, of Fylby 0
4768691 2286186 2286186 defendant Bakton Richard   588520 588520 Bakton, Richard, of Fylby, wright 0
4793274 2293992 2293992 defendant Oxon John chaplain 588520 588520 Oxon, John, of Fylby, chaplain 0
4849598 2311349 2311349 defendant Mage John yeoman 588520 588520 Mage, John, of Fylby, yeoman 0
4901161 2326979 2326979 defendant Here John husbandman 588520 588520 Here, John, of Fylby, husbandman 5
4902482 2327391 2327391 defendant Hare Robert yeopman 588520 588520 Hare, Robert, of Fylby, yeopman 2
4915717 2331415 2331415 defendant Smyth Nicholas smith 588520 588520 Smyth, Nicholas, of Fylby, smith 1
4925319 2334351 2334351 plaintiff Drye William   588520 588520 Drye, William, of Fylby 1
4926298 2334651 2334651 plaintiff Pykeryng Nicholas   588520 588520 Pykeryng, Nicholas, of Fylby 0
4926299 2334651 2334651 defendant Pykeryng Nicholas   588520 588520 Pykeryng, Nicholas, of Fylby 0
4979780 2350908 2350908 defendant Gargrave John tailor 588520 588520 Gargrave, John, of Fylby, tailor 0
5004590 2358244 2358244 plaintiff Pykeryng Nicholas   588520 588520 Pykeryng, Nicholas, of Fylby 0
5147746 2400481 2400481 defendant Pykeryng Alice   588520 588520 Pykeryng, Alice, of Fylby, widow, formerly wife of Nicholas 0
5232983 2425229 2425229 defendant Osborn John husbandman 588520 588520 Osborn, John, of Fylby, husbandman 0
5274142 2437515 2437515 defendant Bulfynch alias Beryn Thomas husbandman 588520 588520 Bulfynch alias Beryn, Thomas, of Fylby, husbandman 1
5278853 2438925 2438925 defendant Freman William clerk 588520 588520 Freman, William, of Fylby, clerk 1
5310961 2448316 2448316 defendant Freman William chaplain 588520 588520 Freman, William, of Fylby, chaplain 0
5311628 2448500 2448500 defendant Norman Bartholomew husbandman 588520 588520 Norman, Bartholomew, of Fylby, husbandman 1
5326705 2453056 2453056 defendant Osbern John yeoman 588520 588520 Osbern, John, of Fylby, yeoman 0
5326706 2453056 2453056 defendant Peytwyn John, junior yeoman 588520 588520 Peytwyn, John, junior, of Fylby, yeoman 1
5365294 2464819 2464819 defendant Pekeryng John husbandman 588520 588520 Pekeryng, John, of Fylby, husbandman 3
5498873 2504603 2504603 defendant Founke Robert butcher 588520 588520 Founke, Robert, of Fylby, butcher 0
5529844 2513844 2513844 plaintiff Osbern Alan yeoman 588520 588520 Osbern, Alan, of Fylby, yeoman 1
5556112 2521784 2521784 plaintiff Lematon Walter (legal representative) 588520 588520 Lematon, Walter, of Fylby, gent, executors of 0
5556118 2521785 2521785 plaintiff Lematon Walter   588520 588520 Lematon, Walter, of Fylby, gent, executrs of 0
5569376 2525602 2525602 defendant Nodde James husbandman 588520 588520 Nodde, James, of Fylby, husbandman 2
5599700 2534796 2534796 defendant Nudde James husbandman 588520 588520 Nudde, James, of Fylby, husbandman 0
5599701 2534796 2534796 defendant Tebbe Thomas husbandman 588520 588520 Tebbe, Thomas, of Fylby, husbandman 1

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