names

81 rows where place_id = 601339

✎ 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
3644894 1908814 1908814 defendant Swan William gent 601339 601339 Swan, William, of Southflete, gent 0
3644895 1908814 1908814 defendant White John laborer 601339 601339 White, John, of Southflete, laborer 1
3647488 1909604 1909604 defendant Hogeston Christopher yeoman 601339 601339 Hogeston, Christopher, of Southflete, yeoman 0
3658637 1912956 1912956 defendant Byrde Giles husbandman 601339 601339 Byrde, Giles, of Southflete, husbandman 0
3673920 1917880 1917880 defendant Swan William gent 601339 601339 Swan, William, of Southflete, gent 0
3673921 1917880 1917880 defendant White John laborer 601339 601339 White, John, of Southflete, laborer 1
3673922 1917880 1917880 defendant Bele Richard laborer 601339 601339 Bele, Richard, of Southflete, laborer 2
3673923 1917880 1917880 defendant Dyrryk Gabriel laborer 601339 601339 Dyrryk, Gabriel, of Southflete, laborer 3
3673924 1917880 1917880 defendant Lomysden John laborer 601339 601339 Lomysden, John, of Southflete, laborer 4
3681606 1920339 1920339 defendant Harper alias Thumwode John husbandman 601339 601339 Harper alias Thumwode, John, of Southflete, husbandman 0
3704472 1927694 1927694 defendant Swan William, junior gent 601339 601339 Swan, William, junior, of Southflete, gent 0
3704473 1927694 1927694 defendant Swan William, senior gent 601339 601339 Swan, William, senior, of Southflete, gent 1
3704475 1927695 1927695 defendant Swan William, senior gent 601339 601339 Swan, William, senior, of Southflete, gent 0
3704476 1927695 1927695 defendant Swan William, junior gent 601339 601339 Swan, William, junior, of Southflete, gent 1
3716088 1931317 1931317 defendant Swan William, junior gent 601339 601339 Swan, William, junior, of Southflete, gent 0
3878051 1982903 1982903 defendant Sedley William gent 601339 601339 Sedley, William, of Southflete, gent 0
3881452 1984063 1984063 plaintiff Sedley William esq 601339 601339 Sedley, William, of Southflete, esq 0
3900494 1990395 1990395 defendant Fuller John tanner 601339 601339 Fuller, John, of Southflete, tanner 4
3972697 2015025 2015025 plaintiff Gens Robert yeoman 601339 601339 Gens, Robert, of Southflete, yeoman 0
3972896 2015093 2015093 defendant Swan William gent 601339 601339 Swan, William, of Southflete, gent 1
4038436 2038385 2038385 defendant Swan Francis gent 601339 601339 Swan, Francis, of Southflete, gent 0
4038440 2038386 2038386 defendant Swan Francis gent 601339 601339 Swan, Francis, of Southflete, gent 0
4090028 2056716 2056716 defendant Hartroppe Richard laborer 601339 601339 Hartroppe, Richard, of Southflete, laborer 1
4092238 2057525 2057525 defendant Taster Edward tailor 601339 601339 Taster, Edward, of Southflete, tailor 1
4113405 2065065 2065065 defendant Swanne Francis gent 601339 601339 Swanne, Francis, of Southflete, gent 0
4132424 2071913 2071913 defendant Hudson John laborer 601339 601339 Hudson, John, of Southflete, laborer 0
4201132 2095945 2095945 defendant Swanne William gent 601339 601339 Swanne, William, of Southflete, gent 0
4508965 2203282 2203282 defendant Scathebery Robert   601339 601339 Scathebery, Robert, of Southflete 0
4508966 2203282 2203282 defendant Tanner Simon   601339 601339 Tanner, Simon, of Southflete 1
4563239 2220073 2220073 defendant Cotes John   601339 601339 Cotes, John, of Southflete 1
4567320 2221336 2221336 defendant Edmond William   601339 601339 Edmond, William, of Southflete 0
4601156 2231594 2231594 defendant Baker Robert   601339 601339 Baker, Robert, of southflete 1
4601540 2231705 2231705 defendant Orgor Robert   601339 601339 Orgor, Robert, of Southflete 1
4714919 2269998 2269998 defendant Wrenne William gent 601339 601339 Wrenne, William, of Southflete, gent 0
4743266 2278558 2278558 defendant Edmund William laborer 601339 601339 Edmund, William, of Southflete, laborer 0
4743269 2278559 2278559 defendant Edmund William laborer 601339 601339 Edmund, William, of Southflete, laborer 0
4803919 2297406 2297406 defendant Middelton Richard chaplain 601339 601339 Middelton, Richard, of Southflete, chaplain 0
4803922 2297407 2297407 defendant Middelton Richard chaplain 601339 601339 Middelton, Richard, of Southflete, chaplain 0
4859957 2314481 2314481 defendant Wykes William husbandman 601339 601339 Wykes, William, of Southflete, husbandman 0
4862580 2315282 2315282 defendant Wrenne John husbandman 601339 601339 Wrenne, John, of Southflete, husbandman 1
4864174 2315772 2315772 defendant Wyke William husbandman 601339 601339 Wyke, William, of Southflete, husbandman 0
4940667 2339109 2339109 defendant Shopman John laborer 601339 601339 Shopman, John, of Southflete, laborer 0
4955174 2343505 2343505 defendant Jurdan Thomas husbandman 601339 601339 Jurdan, Thomas, of Southflete, husbandman 2
4955175 2343505 2343505 defendant Lardyner John husbandman 601339 601339 Lardyner, John, of Southflete, husbandman 3
4955176 2343505 2343505 defendant Lane John husbandman 601339 601339 Lane, John, of Southflete, husbandman 4
4980405 2351080 2351080 defendant Paxston John laborer 601339 601339 Paxston, John, of Southflete, laborer 1
5009598 2359685 2359685 defendant Baker Robert yeoman 601339 601339 Baker, Robert, of Southflete, yeoman 0
5069802 2377461 2377461 defendant London John husbandman 601339 601339 London, John, of Southflete, husbandman 2
5087693 2382787 2382787 defendant Gerard William laborer 601339 601339 Gerard, William, of Southflete, laborer 2
5087698 2382789 2382789 defendant Gerard William laborer 601339 601339 Gerard, William, of Southflete, laborer 1
5097395 2385669 2385669 defendant Gerard Thomas husbandman 601339 601339 Gerard, Thomas, of Southflete, husbandman 2
5138580 2397781 2397781 defendant Loundyssh Roger husbandman 601339 601339 Loundyssh, Roger, of Southflete, husbandman 0
5138581 2397781 2397781 defendant Shirwode John butcher 601339 601339 Shirwode, John, of Southflete, butcher 1
5138582 2397781 2397781 defendant Shirwode William butcher 601339 601339 Shirwode, William, of Southflete, butcher 2
5209055 2418380 2418380 defendant Shirwode Roger husbandman 601339 601339 Shirwode, Roger, of Southflete, husbandman 0
5247903 2429525 2429525 defendant Lundysshe Robert husbandman 601339 601339 Lundysshe, Robert, of Southflete, husbandman 2
5257914 2432598 2432598 defendant Billesby Thomas tailor 601339 601339 Billesby, Thomas, of Southflete, tailor 0
5262764 2434095 2434095 defendant Edmond William husbandman 601339 601339 Edmond, William, of Southflete, husbandman 0
5262765 2434095 2434095 defendant Jurdan Richard husbandman 601339 601339 Jurdan, Richard, of Southflete, husbandman 1
5313077 2448944 2448944 defendant Couper John husbandman 601339 601339 Couper, John, of Southflete, husbandman 0
5313883 2449174 2449174 defendant Bere Richard yeoman 601339 601339 Bere, Richard, of Southflete, yeoman 0
5361768 2463711 2463711 defendant Edward William laborer 601339 601339 Edward, William, of Southflete, laborer 1
5368888 2465858 2465858 defendant Ketyll John yeoman 601339 601339 Ketyll, John, of Southflete, yeoman 0
5479511 2498884 2498884 defendant Pygot William gent 601339 601339 Pygot, William, of Southflete, gent 1
5482149 2499602 2499602 defendant Walsh John gent 601339 601339 Walsh, John, of Southflete, gent 1
5483594 2500043 2500043 defendant Walssh John vintner 601339 601339 Walssh, John, of Southflete, gent, or of London, vintner 0
5494892 2503368 2503368 defendant Swanne William, senior (legal representative) 601339 601339 Swanne, William, senior, of Southflete, gent, executor of 0
5494896 2503369 2503369 defendant Swanne William, senior (legal representative) 601339 601339 Swanne, William, senior, of Southflete, gent, executor of 0
5528237 2513389 2513389 defendant Clerk John, junior husbandman 601339 601339 Clerk, John, junior, of Southflete, husbandman 3
5532053 2514566 2514566 defendant Swan Richard yeoman 601339 601339 Swan, Richard, of Southflete, yeoman 0
5532054 2514566 2514566 defendant Swan William yeoman 601339 601339 Swan, William, of Southflete, yeoman 1
5535215 2515542 2515542 defendant Ketell John yeoman 601339 601339 Ketell, John, of Southflete, yeoman 1
5543952 2518219 2518219 defendant Swan William gent 601339 601339 Swan, William, of Southflete, gent 0
5543955 2518219 2518219 defendant Wybarn Richard gent 601339 601339 Wybarn, Richard, of Southflete, gent 3
5549253 2519830 2519830 defendant Swan William gent 601339 601339 Swan, William, of Southflete, gent 0
5565139 2524390 2524390 defendant Hodson Christopher yeoman 601339 601339 Hodson, Christopher, of Southflete, yeoman 0
5568953 2525471 2525471 defendant Gryffyn William tailor 601339 601339 Gryffyn, William, of Southflete, tailor 0
5568955 2525471 2525471 defendant Teteryke John husbandman 601339 601339 Teteryke, John, of Southflete, husbandman 2
5573413 2526781 2526781 defendant Teteryke John husbandman 601339 601339 Teteryke, John, of Southflete, husbandman 1
5573414 2526781 2526781 defendant Gryffyn William tailor 601339 601339 Gryffyn, William, of Southflete, tailor 2
5636348 2555324 2555324 plaintiff Wrenne William   601339 601339 Wrenne, William, of Southflete 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);