names

37 rows where place_id = 620054

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3733400 1936683 1936683 defendant Rychemond John yeoman 620054 620054 Rychemond, John, of Skegnes, yeoman 0
3798537 1957445 1957445 defendant Richemond John husbandman 620054 620054 Richemond, John, of Skegnes, husbandman 2
3818634 1963731 1963731 defendant Sutterby John laborer 620054 620054 Sutterby, John, of Skegnes, laborer 1
4122027 2068179 2068179 defendant Hopkinson Charles yeoman 620054 620054 Hopkinson, Charles, of Skegnes, yeoman 0
4233640 2107287 2107287 defendant Fowler Thomas yeoman 620054 620054 Fowler, Thomas, of Skegnes, yeoman 0
4236098 2108195 2108195 defendant Bushie Samuel gent 620054 620054 Bushie, Samuel, of Skegnes, gent 0
4242205 2110386 2110386 defendant Fowler Thomas yeoman 620054 620054 Fowler, Thomas, of Skegnes, yeoman 0
4271245 2119957 2119957 defendant Williamson Thomas laborer 620054 620054 Williamson, Thomas, of Skegnes, laborer 0
4679684 2259261 2259261 defendant atte Milne William husbandman 620054 620054 atte Milne, William, of Skegnes, husbandman 1
4709618 2268370 2268370 defendant Kyng William husbandman 620054 620054 Kyng, William, of Skegnes, husbandman 0
4815095 2300833 2300833 defendant Baron William husbandman 620054 620054 Baron, William, of Skegnes, husbandman 0
4869164 2317334 2317334 defendant Andreweson Simon husbandman 620054 620054 Andreweson, Simon, of Skegnes, husbandman 0
4935758 2337575 2337575 defendant Kneston alias Bacon William husbandman 620054 620054 Kneston alias Bacon, William, of Skegnes, husbandman 1
4935759 2337575 2337575 defendant Adam alias Odam John husbandman 620054 620054 Adam alias Odam, John, of Skegnes, husbandman 2
4952206 2342627 2342627 defendant Taillour William husbandman 620054 620054 Taillour, William, of Skegnes, husbandman 0
4967345 2347174 2347174 defendant Depedale John husbandman 620054 620054 Depedale, John, of Skegnes, husbandman 13
4998850 2356539 2356539 defendant Willyamson Robert husbandman 620054 620054 Willyamson, Robert, of Skegnes, husbandman 4
5011173 2360122 2360122 plaintiff Westby John   620054 620054 Westby, John, of Skegnes 0
5037087 2367717 2367717 plaintiff Westby John   620054 620054 Westby, John, of Skegnes 0
5037088 2367717 2367717 plaintiff Ryby Walter   620054 620054 Ryby, Walter, of Skegnes 1
5045666 2370337 2370337 defendant Andreweson Simon fisher 620054 620054 Andreweson, Simon, of Skegnes, fisher 0
5064417 2375899 2375899 defendant Cokson Richard husbandman 620054 620054 Cokson, Richard, of Skegnes, husbandman 2
5073252 2378488 2378488 defendant Ryby Walter gent 620054 620054 Ryby, Walter, of Skegnes, gent 0
5079574 2380380 2380380 defendant Depedale John husbandman 620054 620054 Depedale, John, of Skegnes, husbandman 0
5124940 2393769 2393769 defendant Richemond Alan shipman 620054 620054 Richemond, Alan, of Skegnes, shipman 0
5189661 2412720 2412720 defendant Crake Simon husbandman 620054 620054 Crake, Simon, of Skegnes, husbandman 0
5194451 2414103 2414103 defendant Russell John shipman 620054 620054 Russell, John, of Skegnes, shipman 0
5206584 2417659 2417659 defendant Crake Simon husbandman 620054 620054 Crake, Simon, of Skegnes, husbandman 0
5222896 2422410 2422410 plaintiff Mylne Richard   620054 620054 Mylne, Richard, of Skegnes 0
5266315 2435217 2435217 defendant Waterlad Walter husbandman 620054 620054 Waterlad, Walter, of Skegnes, husbandman 0
5370261 2466286 2466286 defendant Mylne Robert yeoman 620054 620054 Mylne, Robert, of Skegnes, yeoman 0
5389105 2471933 2471933 defendant Wykes John yeoman 620054 620054 Wykes, John, of Skegnes, yeoman 1
5414761 2479351 2479351 defendant Wykes John yeoman 620054 620054 Wykes, John, of Skegnes, yeoman 1
5430626 2484099 2484099 defendant Wykes John yeoman 620054 620054 Wykes, John, of Skegnes, yeoman 0
5511171 2508332 2508332 defendant Gysyll John fisher 620054 620054 Gysyll, John, of Skegnes, fisher 1
5576803 2527790 2527790 plaintiff Tyler John   620054 620054 Tyler, John, of Skegnes 0
5635670 2555115 2555115 plaintiff Westyby William, senior   620054 620054 Westyby, William, senior, of Skegnes 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);