names

32 rows where place_id = 689269

✎ 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
4079714 2053041 2053041 defendant Hunt Thomas butcher 689269 689269 Hunt, Thomas, of Meopham, butcher 2
4079717 2053041 2053041 defendant Stone Richard butcher 689269 689269 Stone, Richard, of Meopham, butcher 5
4112665 2064788 2064788 defendant Warren James blacksmith 689269 689269 Warren, James, of Meopham, blacksmith 0
4112667 2064789 2064789 defendant Warren James blacksmith 689269 689269 Warren, James, of Meopham, blacksmith 0
4128979 2070665 2070665 defendant Brompton John laborer 689269 689269 Brompton, John, of Meopham, laborer 0
4431628 2174660 2174660 plaintiff Brigham John de   689269 689269 Brigham, John de, of Meopham, parson 0
4431630 2174660 2174660 defendant Giles John   689269 689269 Giles, John, of Meopham 1
4467844 2190622 2190622 defendant Osbarn Thomas   689269 689269 Osbarn, Thomas, of Meopham 1
4528799 2209292 2209292 plaintiff Mellere John   689269 689269 Mellere, John, of Meopham 0
4703578 2266496 2266496 defendant Mellere John laborer 689269 689269 Mellere, John, of Meopham, laborer 0
4707309 2267663 2267663 defendant Middelton John laborer 689269 689269 Middelton, John, of Meopham, laborer 0
4714763 2269948 2269948 defendant Salowe John butcher 689269 689269 Salowe, John, of Meopham, butcher 0
4724942 2273094 2273094 defendant Piers Thomas husbandman 689269 689269 Piers, Thomas, of Meopham, husbandman 0
4766317 2285459 2285459 defendant Wronge John smith 689269 689269 Wronge, John, of Meopham, smith 2
4767550 2285828 2285828 defendant Power John husbandman 689269 689269 Power, John, of Meopham, husbandman 0
4826862 2304440 2304440 defendant Myllere Michael husbandman 689269 689269 Myllere, Michael, of Meopham, husbandman 1
4840267 2308503 2308503 defendant Payn Thomas butcher 689269 689269 Payn, Thomas, of Meopham, butcher 0
4928550 2335358 2335358 defendant Verarde John husbandman 689269 689269 Verarde, John, of Meopham, husbandman 1
4991698 2354400 2354400 defendant Letecote Richard laborer 689269 689269 Letecote, Richard, of Meopham, laborer 3
5126514 2394230 2394230 defendant Idley Cecilia widow 689269 689269 with Idley, Cecilia, of Meopham, widow 1
5159345 2403849 2403849 defendant Letecote Nicholas husbandman 689269 689269 Letecote, Nicholas, of Meopham, husbandman 1
5181661 2410379 2410379 defendant Idley Celia widow 689269 689269 Idley, Celia, of Meopham, widow 0
5191390 2413223 2413223 defendant Berarde John husbandman 689269 689269 Berarde, John, of Meopham, husbandman 0
5191391 2413223 2413223 defendant Baker Robert husbandman 689269 689269 Baker, Robert, of Meopham, husbandman 1
5195256 2414359 2414359 defendant Letecote Nicholas husbandman 689269 689269 Letecote, Nicholas, of Meopham, husbandman 1
5203025 2416645 2416645 defendant Idley Cecilia widow 689269 689269 together with Idley, Cecilia, of Meopham, widow 1
5205931 2417471 2417471 defendant Berard John husbandman 689269 689269 Berard, John, of Meopham, husbandman 0
5205932 2417471 2417471 defendant Letrothe Nicholas husbandman 689269 689269 Letrothe, Nicholas, of Meopham, husbandman 1
5207325 2417884 2417884 defendant Berarde John husbandman 689269 689269 Berarde, John, of Meopham, husbandman 0
5207326 2417884 2417884 defendant Baker Robert husbandman 689269 689269 Baker, Robert, of Meopham, husbandman 1
5370320 2466306 2466306 defendant Fuller Thomas husbandman 689269 689269 Fuller, Thomas, of Meopham, husbandman 0
5371343 2466615 2466615 defendant Taillour John husbandman 689269 689269 Taillour, John, of Meopham, husbandman 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);